通过Struts2添加用户到数据库

通过Struts2添加用户到数据库
点击添加将账号密码添加到数据库，并显示账号和密码

1. web.xml配置

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
  <display-name>Ssss</display-name>
 
    <filter> 
       <filter-name>Struts2</filter-name>  
      
        <filter-class> 
        org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter 
       </filter-class>  
     
      </filter> 
      <filter-mapping>
       <filter-name>Struts2</filter-name> 
       <url-pattern>/*</url-pattern>  
      </filter-mapping> 
       <welcome-file-list>

    <welcome-file>index.jsp</welcome-file>

  </welcome-file-list>
</web-app>

2. struts.xml配置

<struts>
	
	
  <package name="helloWorld"  namespace="/" extends="struts-default">
   
  	<action name="hello" class="com.action.HelloWorldAction">
  		<result name="success">hello.jsp</result>
  		
  		
  		
  	</action>
  	
 
  </package>

</struts>

3添加到数据库，
. `public class HelloWorldAction implements Action{
private String name;
private String password;
private static DbUtil dbUtil = new DbUtil();
private static int addBook(String name, String password)throws Exception{
Connection con=DbUtil.getCon();
String sql=“insert into table1 values(?,?)”;
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1,name);
pstmt.setString(2,password);

	   int result=pstmt.executeUpdate();
	   pstmt.close();
	   con.close();
	   return result;
   }

public String getName() {
	return name;
}

public void setName(String name) {
	this.name = name;
}

public String getPassword() {
	return password;
}

public void setPassword(String password) {
	this.password = password;
}
 


@Override

public String execute() throws Exception {
	System.out.println("执行了Action的默认方法");
	 int result=addBook(name,password);
 	 if(result==1) {
	 System.out.println("添加成功!");
	 
 }
 else {
	 System.out.println("添加失败!");
 }
	return SUCCESS;
}

`
实验结果：