1、注册网页
欢迎来次注册账号
账号: | |
密码: | |
姓名: | |
地址: | |
工作单位: | |
2、struts.xml配置
/CaraLogin.jsp
/pages1/Register.jsp
3、java类
(1)
package com.JDBC.card;
import java.sql.*;
public class JdbcCard {
String driverName ="com.mysql.jdbc.Driver";
String userName ="root";
String userPwd ="123456";
String dbName ="test";
public String getDriverName() {
return driverName;
}
public void setDriverName(String driverName) {
this.driverName = driverName;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getUserPwd() {
return userPwd;
}
public void setUserPwd(String userPwd) {
this.userPwd = userPwd;
}
public String getDbName() {
return dbName;
}
public void setDbName(String dbName) {
this.dbName = dbName;
}
public Connection getConnect()throws SQLException,ClassNotFoundException{
String url1 ="jdbc:mysql://localhost:3306/"+dbName;
String url2 ="?user="+userName+"&password="+userPwd;
String url3 ="&useUnicode=true&characterEncading=UTF-8";
String url=url1+url2+url3;
Class.forName(driverName);
return DriverManager.getConnection(url);
}
}
(2)、
package com.javabean.card;
import java.sql.SQLException;
import com.JDBC.card.JdbcCard;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
public class Register {
private String userName;
private String userPwd;
private String uName;
private String userTelephone;
private String userAddress;
private String userWork;
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getUserPwd() {
return userPwd;
}
public void setUserPwd(String userPwd) {
this.userPwd = userPwd;
}
public String getuName() {
return uName;
}
public void setuName(String uName) {
this.uName = uName;
}
public String getUserTelephone() {
return userTelephone;
}
public void setUserTelephone(String userTelephone) {
this.userTelephone = userTelephone;
}
public String getUserAddress() {
return userAddress;
}
public void setUserAddress(String userAddress) {
this.userAddress = userAddress;
}
public String getUserWork() {
return userWork;
}
public void setUserWork(String userWork) {
this.userWork = userWork;
}
public String execute() throws ClassNotFoundException, SQLException{
JdbcCard jbc=new JdbcCard();
Connection conn=(Connection) jbc.getConnect();
String sql="INSERT INTO `test`.`user` (`userName`, `userPwd`, `uName`, `userAddress`, `userWork`) VALUES (?,?,?,?,?);";
PreparedStatement pstmt=(PreparedStatement) conn.prepareStatement(sql);
pstmt.setString(1,getUserName());
pstmt.setString(2,getUserPwd());
pstmt.setString(3,getuName());
pstmt.setString(4,getUserAddress());
pstmt.setString(5,getUserWork());
int n=pstmt.executeUpdate();
if(n==0){return "false";};
if(pstmt!=null){pstmt.close();};
if(conn!=null){conn.close();};
return "success";
}
}
4、跳转页面