jsp第十周作业
package zhuce2; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DbUtil { static { try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static Connection getCon() { Connection con = null; try { con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "123456"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return con; } }
package zhuce2; public class User { private Integer id; private String uname; private String password; private Integer age; public User() { } public User(String uname, String password, Integer age) { super(); this.uname = uname; this.password = password; this.age = age; } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getUname() { return uname; } public void setUname(String uname) { this.uname = uname; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public Integer getAge() { return age; } public void setAge(Integer age) { this.age = age; } }
package zhuce2; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class UserDao { public void regUser(User user) { // String sql = "insert into stu(uname,password,age) value( " + user.getUname() + "," + user.getPassword() + "," // + user.getAge() + ")"; String sql = "insert into stu(uname,password,age) value(?,?,?)"; // 建立数据库链接 Connection con = DbUtil.getCon(); try { // 预编译 PreparedStatement pred = con.prepareStatement(sql); // 替换占位符 pred.setString(1, user.getUname()); pred.setString(2, user.getPassword()); pred.setInt(3, user.getAge()); // 执行sql语句 pred.executeUpdate(); pred.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } public User getUserByName(String uname) { User user = null; String sql = "select * from stu where uname = ?"; Connection con = DbUtil.getCon(); try { // 预编译 PreparedStatement pred = con.prepareStatement(sql); // 替换占位符 pred.setString(1, uname); // 执行sql语句 ResultSet res = pred.executeQuery(); if (res.next()) { user = new User(res.getString("uname"), res.getString("password"), res.getInt("age")); } pred.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return user; } }
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> </head> <body> <form action="dologin.jsp" name="formName"> 用户名：<input type="text" name="uname"> <br> 密码：<input type="password" name="password"><br> <input type="button" value="登录" onclick="toDoLogin()"> <input type="button" value="注册" onclick="toReg()"> </form> <script> function toReg() { window.location.href = 'reg.jsp'; } function toDoLogin() { if (formName.uname.value == '' || formName.password.value == '') { alert('账号密码不能为空'); } else { formName.submit(); } } </script> </body> </html>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> </head> <body> <form action="doReg.jsp" method="post"> 用户名：<input type="text" name="uname"><br> 密码：<input type="password" name="password"><br> 确认密码：<input type="password"><br> 年龄：<input type="text" name="age"><br> <input type="submit" value="注册"> </form> </body> </html>
<%@page import="zhuce2.UserDao"%> <%@page import="zhuce2.User"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> </head> <body> <% request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); String uname = request.getParameter("uname"); String password = request.getParameter("password"); Integer age = Integer.parseInt(request.getParameter("age")); User user = new User(uname, password, age); UserDao userDao = new UserDao(); userDao.regUser(user); response.sendRedirect("index.jsp"); %> </body> </html>
<%@page import="zhuce2.User"%> <%@page import="zhuce2.UserDao"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> </head> <body> <% String uname = request.getParameter("uname"); String password = request.getParameter("password"); UserDao userDao = new UserDao(); User user = userDao.getUserByName(uname); if (password.equals(user.getPassword())) { response.sendRedirect("main.jsp"); } else { %> <script> alert('账号或密码错误'); </script> <% response.sendRedirect("index.jsp"); } %> </body> </html>
