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、跳转页面
那你准是报错404了,看网页路径访问对不
是啊,怎么看网页路径啊!
提示错误是:HTTP Status 404 - There is no Action mapped for namespace [/] and action name [Regist] associated with context path [/struts2-1].
看你贴的东西实在不清楚是什么,我是冲着悬赏来的,只能说说原理了。你的错误信息很清楚了,这个路径(url)“/”和 "Regist"没有action与之对应。也就是struts.xml配错了。一般情况下,应用包的web.xml里会指定一个servelet或者filter,对应一个路径,基本都是'/'根目录。如果用spring的话,这个spring干了,然后spring会加载struts的配置文件(context信息),然后把路由委托给struts,struts会根据配置文件解析路径,找到对应的类(action),执行完成后,返回对应的jsp页面。当然中间这些过程你都可以不管,你只需要保证路径(url)与action类一一对应就可以了,亲,你做到了吗?不明白就看看struts2包里sample里的例子。