一、仍然使用前面的环境和示例数据库。

二、建立发出注册请求的页面index3.jsp。

 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     <meta http-equiv="Content-Type" content="text/html;charset=utf-8">
 6     <title>我的JSP开始页面</title>
 7     <meta http-equiv="pragma" content="no-cache">
 8     <meta http-equiv="cache-control" content="no-cache">
 9     <meta http-equiv="expires" content="0">    
10     <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
11     <meta http-equiv="description" content="This is my page">
12   </head>
13   
14   <body>
15   <form action="reguser.jsp" method="get">
16       <table border="0">
17           <tr><td align ="center" colspan="2">添加用户信息</td></tr>
18           <tr><td>序号：</td><td><input type="text" name="id" value="4"></td></tr>
19           <tr><td>姓名：</td><td><input type="text" name="username" value="zhangdaoling"></td></tr>
20           <tr><td>密码：</td><td><input type="text" name="password" value="mm999999"></td></tr>
21           <tr><td align ="center" colspan="2"><input type="submit" value="确认"></td></tr>
22       </table>
23   </form><br>
24   </body>
25 </html>
View Code

三、建立用以封装表单请求数据的类User。

 1 package com.kaly.bean;
 2 
 3 public class User {
 4     String id;
 5     String username;
 6     String password;
 7 
 8     public String getId() {
 9         return id;
10     }
11 
12     public void setId(String id) {
13         this.id = id;
14     }
15 
16     public String getUsername() {
17         return username;
18     }
19 
20     public void setUsername(String username) {
21         this.username = username;
22     }
23 
24     public String getPassword() {
25         return password;
26     }
27 
28     public void setPassword(String password) {
29         this.password = password;
30     }
31 }
View Code

四、建立用以和数据库连接并且像数据库写数据的页面reguser.jsp。

 1 <%@page import="java.sql.PreparedStatement"%>
 2 <%@page import="java.sql.DriverManager"%>
 3 <%@page import="java.sql.Connection"%>
 4 <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
 5 
 6 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 7 <html>
 8   <head>
 9     <meta http-equiv="Content-Type" content="text/html;charset=utf-8">
10     <title>我的JSP 'reguser.jsp'开始页面</title>
11     <meta http-equiv="pragma" content="no-cache">
12     <meta http-equiv="cache-control" content="no-cache">
13     <meta http-equiv="expires" content="0">    
14     <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
15     <meta http-equiv="description" content="This is my page">
16   </head>
17   
18   <body>
19     <%request.setCharacterEncoding("utf-8"); %>
20     <jsp:useBean id="user1" class="com.kaly.bean.User"></jsp:useBean>
21     <jsp:setProperty property="*" name="user1"/>
22     
23     <%
24     String drvStr="com.mysql.jdbc.Driver";
25     String dataStr="jdbc:mysql://192.168.2.100:3306/logininfo";
26     String usernameStr="root";
27     String passwordStr="admin";
28     String sqlStr="insert into userinfo(id,username,password) values(?,?,?)";
29     Connection conn=null;
30     PreparedStatement pStat=null;
31     
32     try{
33         Class.forName(drvStr);
34         conn=DriverManager.getConnection(dataStr,usernameStr,passwordStr);
35         pStat=conn.prepareStatement(sqlStr);
36         pStat.setString(1, user1.getId());
37         pStat.setString(2, user1.getUsername());
38         pStat.setString(3, user1.getPassword());
39         pStat.executeUpdate();
40         pStat.close();
41         conn.close();
42     }catch(Exception e){
43         out.print("注册失败");
44         e.printStackTrace();
45     }
46      %>
47      <br>
48      <a href="index3.jsp">返回</a>
49   </body>
50 </html>
View Code

在这个页面中，先引用User，将表单提交的数据封装起来，然后连接数据库，用PreparedStatement把封装的数据读出来写入数据库对应表中。

 

运行结果：

点击“确认”之后：

打开数据库表刷新：