jsp第十周作业
<%@page import="entity.Stu"%> <%@page import="dao.StuDao"%> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <!DOCTYPE HTML> <html> <head> <title></title> </head> <body> <% request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); String uname = request.getParameter("uname"); String password = request.getParameter("password"); StuDao stuDao = new StuDao(); Stu stu = stuDao.getStu(uname); if(password.equals(stu.getPassword())){ response.sendRedirect("index.jsp"); }else{ response.sendRedirect("login.jsp"); } %> </body> </html>
<%@page import="dao.StuDao"%> <%@page import="entity.Stu"%> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <!DOCTYPE HTML> <html> <head> <title></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")); Stu stu = new Stu(uname,password,age); StuDao stuDao = new StuDao(); stuDao.zhuce(stu); response.sendRedirect("login.jsp"); %> </body> </html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <!DOCTYPE HTML> <html> <head> <title>登录页面</title> </head> <body> <form name="loginForm" action="dologin.jsp" method="post"> 用户名：<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 (loginForm.uname.value == "" || loginForm.password.value == "") { alert("用户名或密码不能为空"); }else{ loginForm.submit(); } } </script> </body> </html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <!DOCTYPE HTML> <html> <head> <title>注册</title> </head> <body> <form action="doreg.jsp" method="post"> 用户名：<input type="text" name="uname"><br> 密码：<input type="password" name="password"><br> 年龄：<input type="text" name="age"><br> <input type="submit" value="提交"> </form> </body> </html>
package dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import util.DbUtil; import entity.Stu; public class StuDao { public void zhuce(Stu stu){ String sql = "insert into stu(username,password,age) value (?,?,?)"; Connection connection = DbUtil.getConnection(); try { PreparedStatement ps = connection.prepareStatement(sql); ps.setString(1, stu.getUname()); ps.setString(2, stu.getPassword()); ps.setInt(3, stu.getAge()); ps.executeUpdate(); ps.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { connection.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public Stu getStu(String uname){ String sql = "select * from stu where username=?"; Connection connection = null; PreparedStatement ps = null; ResultSet res = null; connection = DbUtil.getConnection(); try { ps = connection.prepareStatement(sql); ps.setString(1,uname); res = ps.executeQuery(); Stu stu = null; if(res.next()){ stu = new Stu(res.getString("username"),res.getString("password"),res.getInt("age")); } return stu; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ try { res.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { ps.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { connection.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return null; } }
package entity; public class Stu { private int stuId; private String uname; private String password; private int age; public Stu() { super(); } public Stu(String uname, String password, int age) { super(); this.uname = uname; this.password = password; this.age = age; } public int getStuId() { return stuId; } public void setStuId(int stuId) { this.stuId = stuId; } 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 int getAge() { return age; } public void setAge(int age) { this.age = age; } }
package util; 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 getConnection(){ Connection connection = null; try { connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return connection; } }
