81,091
社区成员
发帖
与我相关
我的任务
分享
<html>
<body>
<form name="form1" method="post" action="newuser.jsp" onsubmit="return RgValidation()" >
注册页面(Demo)
<hr>输入用户ID:
<input size="15" name="userid" ></input><br>
输入用户名:
<input size="15" name="name" ></input>
<input type="submit" name="submit!" value="插入 "/>
</form>
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>
<%@ page import="MyBean.*" %>
<jsp:useBean id="userInfo" class="MyBean.UserInfo" scope="page">
<jsp:setProperty name="userInfo" property="*"/>
</jsp:useBean>
<jsp:useBean id="regist" class="MyBean.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>
String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String SERVANDDB="jdbc:sqlserver://localhost:1433; DatabaseName=JSPTest";
package MyBean;
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:sqlserver://localhost:1433; DatabaseName=JSPTest";
String USER="sa";
String PWD="123456";
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 TABLE2 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;
}
}
}
package MyBean;
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;
}
}
package MyBean;
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;
}
}