一、仍然使用前面的环境和示例数据库。
二、建立发出注册请求的页面index3.jsp。
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8">
<title>我的JSP开始页面</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
</head> <body>
<form action="reguser.jsp" method="get">
<table border="0">
<tr><td align ="center" colspan="2">添加用户信息</td></tr>
<tr><td>序号：</td><td><input type="text" name="id" value="4"></td></tr>
<tr><td>姓名：</td><td><input type="text" name="username" value="zhangdaoling"></td></tr>
<tr><td>密码：</td><td><input type="text" name="password" value="mm999999"></td></tr>
<tr><td align ="center" colspan="2"><input type="submit" value="确认"></td></tr>
</table>
</form><br>
</body>
</html>
三、建立用以封装表单请求数据的类User。
package com.kaly.bean;
public class User {
String id;
String username;
String password;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
四、建立用以和数据库连接并且像数据库写数据的页面reguser.jsp。
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8">
<title>我的JSP 'reguser.jsp'开始页面</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
</head> <body>
<%request.setCharacterEncoding("utf-8"); %>
<jsp:useBean id="user1" class="com.kaly.bean.User"></jsp:useBean>
<jsp:setProperty property="*" name="user1"/> <%
String drvStr="com.mysql.jdbc.Driver";
String dataStr="jdbc:mysql://192.168.2.100:3306/logininfo";
String usernameStr="root";
String passwordStr="admin";
String sqlStr="insert into userinfo(id,username,password) values(?,?,?)";
Connection conn=null;
PreparedStatement pStat=null; try{
Class.forName(drvStr);
conn=DriverManager.getConnection(dataStr,usernameStr,passwordStr);
pStat=conn.prepareStatement(sqlStr);
pStat.setString(1, user1.getId());
pStat.setString(2, user1.getUsername());
pStat.setString(3, user1.getPassword());
pStat.executeUpdate();
pStat.close();
conn.close();
}catch(Exception e){
out.print("注册失败");
e.printStackTrace();
}
%>
<br>
<a href="index3.jsp">返回</a>
</body>
</html>
在这个页面中，先引用User，将表单提交的数据封装起来，然后连接数据库，用PreparedStatement把封装的数据读出来写入数据库对应表中。
运行结果：
点击“确认”之后：
打开数据库表刷新：
