第七周作业
用户表： uid (主键，自动增长) uname upwd
使用分层实现注册。（必做）
使用分层实现登录。（选做）
1.index.jsp
1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> 2 <html> 3 <head> 4 <title>register</title> 5 </head> 6 <body> 7 <form name="form1" method="post" action="control.jsp"> 8 <table> 9 <tr> 10 <td>编号：</td> 11 <td><input type="text" name="uid" id="userName"></td> 12 </tr> 13 <tr> 14 <td>用户名：</td> 15 <td><input type="text" name="uname" id="userName"></td> 16 </tr> 17 <tr> 18 <td>输入登录密码：</td> 19 <td><input type="password" name="upwd" id="pwd"></td> 20 </tr> 21 22 <tr> 23 <td colspan="2"><input type="submit" value="注册"></td> 24 </tr> 25 </table> 26 </form> 27 </body> 28 </html>
2.control.jsp
1 <%@page import="com.wuhao.dao.StuDao"%>
2 <%@page import="com.wuhao.bean.Stu"%>
3 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
4 <%
5 Stu s = new Stu();
6 int id = Integer.parseInt(request.getParameter("uid"));
7 s.setUid(id);
8 String uname = request.getParameter("uname");
9 s.setUname(uname);
10 String upwd = request.getParameter("upwd");
11 s.setUpwd(upwd);
12
13 StuDao sd = new StuDao();
14 if (sd.addStu(s) > 0) {
15 response.sendRedirect("welcome.jsp");
16 } else {
17 response.sendRedirect("fail.jsp");
18 }
19 %>
3.welcome.jsp
1 <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> 2 <head> 3 <title>welcome</title> 4 </head> 5 6 <body> 7 注册成功! 8 <br> 9 </body> 10 </html>
4.fail.jsp
1 <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> 2 <head> 3 <title>fail</title> 4 </head> 5 6 <body> 7 注册失败! 8 <br> 9 </body> 10 </html>
5.Stu.java
1 package com.wuhao.bean;
2
3 public class Stu {
4
5 private int uid;
6 private String uname;
7 private String upwd;
8
9 public int getUid() {
10 return uid;
11 }
12
13 public void setUid(int uid) {
14 this.uid = uid;
15 }
16
17 public String getUname() {
18 return uname;
19 }
20
21 public void setUname(String uname) {
22 this.uname = uname;
23 }
24
25 public String getUpwd() {
26 return upwd;
27 }
28
29 public void setUpwd(String upwd) {
30 this.upwd = upwd;
31 }
32
33 public Stu(int uid, String uname, String upwd) {
34 super();
35 this.uid = uid;
36 this.uname = uname;
37 this.upwd = upwd;
38 }
39
40 public Stu() {
41 super();
42 }
43
44 }
6.StuDao.java
1 package com.wuhao.dao;
2
3 import java.sql.Connection;
4 import java.sql.DriverManager;
5 import java.sql.PreparedStatement;
6
7 import com.wuhao.bean.Stu;
8
9 public class StuDao {
10 // 注册
11 public int addStu(Stu s) {
12 int i = 0;
13
14 try {
15 Class.forName("com.mysql.jdbc.Driver");
16 Connection con = DriverManager.getConnection(
17 "jdbc:mysql://localhost:3306/mysql", "root", "root");
18 String sql = "insert into stu values(?,?,?)";
19 PreparedStatement ps = con.prepareStatement(sql);
20 ps.setInt(1, s.getUid());
21 ps.setString(2, s.getUname());
22 ps.setString(3, s.getUpwd());
23 i = ps.executeUpdate();
24
25 } catch (Exception e) {
26 // TODO Auto-generated catch block
27 e.printStackTrace();
28 }
29 return i;
30
31 }
32
33 }
