數據庫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>
浙公網安備 33010602011771號