Struts2+Maven+表单标签向MySql表插入数据实现简单注册

---

创建一个Mysql数据库：StuDB

create database StuDB;--创建数据库

create table studentInfo(--创建数据表
    stuid int primary key auto_increment,--主键自动增长
    stuname varchar(20) not null unique,
    stupass varchar(20) not null,
    sex varchar(10) not null,
    hobby varchar(100),
    birthday date,
    email varchar(100)
 );

在Eclipse新建一个RegisterStu项目

在pom.xml中加入依赖：

    
      mysql
      mysql-connector-java
      5.1.22
    
    
      org.apache.struts
      struts2-core
      2.5.12
    

新建DBCPUtil类 dao

	private static Connection conn = null;
	String url = "jdbc:mysql://localhost:3306/StuDB";
	String root = "root";
	String pass = "408817";
	
	public DBCPUtil() throws ClassNotFoundException, SQLException {
		Class.forName("com.mysql.jdbc.Driver");
		conn = DriverManager.getConnection(url,root,pass);
	}
	
	public static Connection getConn() {
		return conn;
	} 
		
	public static void closeConn() throws SQLException {
		conn.close();
	}
	

新建Students类  action

public class Students extends ActionSupport {
	private int stuid;
	private String stuname;
	private String stupass;
	private String sex;
	private String hobby;
	private String birthday;
	private String email;
	public int getStuid() {
		return stuid;
	}
	public void setStuid(int stuid) {
		this.stuid = stuid;
	}
	public String getStuname() {
		return stuname;
	}
	public void setStuname(String stuname) {
		this.stuname = stuname;
	}
	public String getStupass() {
		return stupass;
	}
	public void setStupass(String stupass) {
		this.stupass = stupass;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public String getHobby() {
		return hobby;
	}
	public void setHobby(String hobby) {
		this.hobby = hobby;
	}
	public String getBirthday() {
		return birthday;
	}
	public void setBirthday(String birthday) {
		this.birthday = birthday;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	
	public String execute() throws SQLException {
		try {
			new DBCPUtil();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			return INPUT;
		}
		//sql语句
		Connection conn = DBCPUtil.getConn();
		String mysql = "insert into StuDB.studentInfo(stuname,stupass,sex,hobby,birthday,email) values(?,?,?,?,?,?)";
		PreparedStatement ps=null;
		try {
			ps = conn.prepareStatement(mysql);
			ps.setString(1, getStuname());
			ps.setString(2, getStupass());
			ps.setString(3, getSex());
			ps.setString(4, getHobby());
			ps.setString(5, getBirthday());
			ps.setString(6, getEmail());
			int count = ps.executeUpdate();
			
			return count > 0 ? SUCCESS:INPUT;
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			return INPUT;
		}finally {
			DBCPUtil.closeConn();
		}
		
	}

web.xml  添加到内

  
  	struts2
  	org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter
  
  
  	struts2
  	/*
  

index.jsp页面：

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib uri="/struts-tags" prefix="s" %>







	">注册

register.jsp页面：  使用表单标签

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib uri="/struts-tags" prefix="s" %>







	    
    
        
        
        
        
        
        
        
        
        
    
    

再写两个success.jsp成功页面，shibai.jsp失败页面，内容自定

在src/main/resources目录下新建一个struts.xml

	
	
	
	
	
	
		
			/register.jsp
		
		
			/index.jsp
		
	
		
			/success.jsp
			/shibai.jsp
		
	

发布访问：http://localhost:8080/RegisterStu/index.com

刷新数据表：