JSP第八次作业

数据库test 中建个表 stu(stuid 主键自动增长，用户名，密码，年龄)

1.设计一个注册页面，实现用户注册功能
2.设计一个登陆页面，实现用户名密码登陆
3.两个页面可以互相超链接

 1 package com.gd.entity;

 2

 3 import java.sql.Connection;

 4 import java.sql.DriverManager;

 5 import java.sql.PreparedStatement;

 6 import java.sql.ResultSet;

 7 import java.sql.SQLException;

 8

 9 public class BaseDao {

10     public Connection getConnection() {

11         Connection con = null;

12         try {

13             Class.forName("com.mysql.jdbc.Driver");

14             con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123456");

15         } catch (Exception e) {

16             e.printStackTrace();

17         }

18         return con;

19     }

20

21     protected void closeAll(Connection con,PreparedStatement ps,ResultSet rs){

22         try {

23             if(rs != null)

24                 rs.close();

25             if(ps != null)

26                 ps.close();

27             if(con != null)

28                 con.close();

29             } catch (SQLException e) {

30                 e.printStackTrace();

31             }

32         }

33

34 }

 1 package com.gd.entity;

 2

 3 import java.sql.Connection;

 4 import java.sql.PreparedStatement;

 5 import java.sql.ResultSet;

 6 import java.sql.SQLException;

 7

 8 public class StuDao extends BaseDao{

 9      public int Register(String uname, String password, int age) {

10             int i = -1;

11             Connection con = getConnection();

12             String sql = "insert into stu(uname,password,age)values(?,?,?)";

13             PreparedStatement pred = null;

14             try {

15                 pred = con.prepareStatement(sql);

16                 pred.setString(1, uname);

17                 pred.setString(2, password);

18                 pred.setInt(3, age);

19                 i = pred.executeUpdate();

20             } catch (SQLException e) {

21                 e.printStackTrace();

22             } finally {

23                 closeAll(con, pred, null);

24             }

25             return i;

26         }

27         public boolean Login(String uname, String password) {

28             boolean f=false;

29             Connection con = getConnection();

30             String sql = "select * from stu where uname=? and password=?";

31             PreparedStatement pred = null;

32             ResultSet resultSet = null;

33             try {

34                 pred = con.prepareStatement(sql);

35                 pred.setString(1, uname);

36                 pred.setString(2, password);

37                 resultSet = pred.executeQuery();

38                 while (resultSet.next()) {

39                     f=true;

40                 }

41             } catch (SQLException e) {

42                 e.printStackTrace();

43             } finally {

44                 closeAll(con, pred, resultSet);

45             }

46             return f;

47         }

48

49 }

 1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

 2 <%

 3     request.setCharacterEncoding("utf-8");

 4     response.setCharacterEncoding("utf-8");

 5 %>

 6 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

 7 <html>

 8   <head>

 9     <title>My JSP 'register.jsp' starting page</title>

10   </head>

11   <body>

12      <h1>注册</h1>

13     <form action="doregister.jsp" method="post">

14         <table>

15             <tr>

16                 <td>用户名</td>

17                 <td><input type="text" name="uname"></td>

18             </tr>

19

20             <tr>

21                 <td>密码</td>

22                 <td><input type="password" name="password"></td>

23             </tr>

24             <tr>

25                 <td>年龄</td>

26                 <td><input type="number" name="age"></td>

27             </tr>

28             <tr>

29                 <td><input type="submit" value="注册"></td>

30                 <td><input type="reset" value="重置"></td>

31             </tr>

32         </table>

33     </form>

34   </body>

35 </html>

 1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

 2 <%@page import="com.gd.entity.StuDao"%>

 3 <%@page import="javax.xml.bind.ParseConversionEvent"%>

 4 <%

 5     request.setCharacterEncoding("utf-8");

 6     response.setCharacterEncoding("utf-8");

 7 %>

 8

 9 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

10 <html>

11   <head>

12

13

14     <title>My JSP 'doregister.jsp' starting page</title>

15

16

17   </head>

18

19   <body>

20     <%

21         String uname = request.getParameter("uname");

22         String password = request.getParameter("password");

23         String age = request.getParameter("age");

24         int age1 = age == null ? -1 : Integer.parseInt(age);

25         StuDao sd=new StuDao();

26         int i=sd.Register(uname, password, age1);

27         if(i>0){

28         request.getRequestDispatcher("login.jsp").forward(request, response);

29         }else{

30         out.print("注册失败");

31         }

32     %>

33   </body>

34 </html>

 1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

 2 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

 3 <html>

 4   <head>

 5     <title>My JSP 'login.jsp' starting page</title>

 6   </head>

 7

 8   <body>

 9     <h1>欢迎</h1>

10     <form action="dologin.jsp" method="post">

11         <table>

12             <tr>

13                 <td>用户名</td>

14                 <td><input type="text" name="uname"></td>

15             </tr>

16

17             <tr>

18                 <td>密码</td>

19                 <td><input type="password" name="password"></td>

20             </tr>

21             <tr>

22                 <td><input type="submit" value="登录"></td>

23                 <td><a href="register.jsp">注册</a></td>

24             </tr>

25         </table>

26     </form>

27   </body>

28 </html>

 1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

 2 <%@page import="com.gd.entity.StuDao"%>

 3 <%@page import="javax.xml.bind.ParseConversionEvent"%>

 4 <%

 5     request.setCharacterEncoding("utf-8");

 6     response.setCharacterEncoding("utf-8");

 7 %>

 8 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

 9 <html>

10   <head>

11     <title>My JSP 'dologin.jsp' starting page</title>

12   </head>

13

14   <body>

15      <%

16         String uname = request.getParameter("uname");

17         String password = request.getParameter("password");

18         StuDao sd=new StuDao();

19         if(sd.Login(uname, password)){

20         request.getRequestDispatcher("index.jsp").forward(request, response);

21         }else{

22         out.print("登陆失败，即将跳回登陆页.....");

23         response.setHeader("refresh", "2;url=login.jsp");

24         }

25

26     %>

27   </body>

28 </html>

 1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

 2

 3

 4 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

 5 <html>

 6   <head>

 7

 8

 9     <title>My JSP 'index.jsp' starting page</title>

10

11   </head>

12

13   <body>

14     <h1>登录成功</h1>

15   </body>

16 </html>

搜索

复制

巴特西

JSP第八次作业

最新文章

热门文章