jsp第七周作业

用户表： 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 (bean包)

 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 (dao包)

 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 }

成功

表结构

数据查询

相关阅读:
phonon 播放视频
 ubuntu清理系统垃圾与备份
 QT中调用mplayer显示视频并加透明文字
 Qt中的QFileDialog类的几个示范代码
 Qt Phonon 例子
 Ubuntu 安装qt 和其他开发环境
 qhttp 下载
 QT 中文乱码解决
 thrift oneway的问题
 leveldb 之内存管理
原文地址：https://www.cnblogs.com/wuhaoovo/p/14671051.html