准备：1：新建一个名为test的数据库，建表 名为：user_info
建立两个字段：userID和userName，类型都是nvarchar（40）
2：管理用户注册信息的类UserInfo.java，代码如下：
package com.JSP_P11.ch5;public class UserInfo
...{
private String userid; private String name; //setter property public void setUserid(String value)
...{ this.userid=value;
} public void setName(String value) ...{ this.name=value; } //getter property public String getUserid() ...{ return this.userid; } public String getName() ...{ return this.name; }
}3：封装数据库操作的类UserRegist.java如下：
package com.JSP_P11.ch5;import com.microsoft.jdbc.sqlserver.SQLServerDriver;import java.sql.*;public class UserRegist ...{ private UserInfo userInfo; private Connection conn; //get database connection public UserRegist() ...{ String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver"; String SERVANDDB="jdbc:microsoft:sqlserver://127.0.0.1:1029;DatabaseName=test"; String USER="sa"; String PWD=""; try ...{ Class.forName(CLASSFORNAME); conn=DriverManager.getConnection(SERVANDDB,USER,PWD); } catch(Exception e) ...{ e.printStackTrace(); } } //set register user info public void setUserInfo(UserInfo userInfo) ...{ this.userInfo=userInfo; } //begin register public void regist()throws Exception ...{ String reg="INSERT INTO user_info values(?,?)"; try ...{ PreparedStatement pstmt=conn.prepareStatement(reg); pstmt.setString(1,userInfo.getUserid()); pstmt.setString(2,userInfo.getName()); pstmt.executeUpdate(); } catch(Exception e) ...{ e.printStackTrace(); throw e; } } }
4：新建一个 index.jsp,源代码如下：
<%@ page language="java" import="java.applet.*" pageEncoding="GB2312"%><html> <head> <title>JavaBean Sample</title> </head> <body> <script language="javascirpt"> function RgValidation() ...{ if(document.form1.userid.value=="") ...{ window.alert("Please input userID"); } if(document.form1.name.value=="") ...{ window.alert("Please input name"); } return true;} </script> <% String userid=request.getParameter("userid"); String name=request.getParameter("name"); if(userid==null) ...{ userid=""; } if(name==null) ...{ name=""; } %> <form name="form1" method="post" action="newuser.jsp"> 注册页面（Demo） <hr>输入用户ID： <input size="15" name="userid" value=<%=userid %>></input><br> 输入用户名： <input size="15" name="name" value=<%=name%>></input> <input type="submit" name="submit!" value="插入"> </form> </body></html>
5：注册页面newuser.jsp页面代码如下：
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%><%@ page import="com.JSP_P11.ch5.*" %><jsp:useBean id="userInfo" class="com.JSP_P11.ch5.UserInfo" scope="page"><jsp:setProperty name="userInfo" property="*"/></jsp:useBean><jsp:useBean id="regist" class="com.JSP_P11.ch5.UserRegist" scope="page"/><%regist.setUserInfo(userInfo);regist.regist();out.println("Success!");%><html> <head> <title>My JSP 'newuser.jsp' starting page</title> </head> <body> This is my JSP page. <br> </body></html>