struts的增删改查

一、新建项目

二、导入pom.xml依赖

1.web.xml改成3.1

2.导入struts相关的配置文件

3.jdk1.5改为1.8同时需要添加plugins>plugin

4.web 2.3>3.1

pom.xml导入依赖后为

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>com.sjy</groupId>
	<artifactId>struts</artifactId>
	<packaging>war</packaging>
	<version>0.0.1-SNAPSHOT</version>
	<name>struts Maven Webapp</name>
	<url>http://maven.apache.org</url>
	<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.8</maven.compiler.source>
    <maven.compiler.target>1.8</maven.compiler.target>
    <maven.compiler.plugin.version>3.7.0</maven.compiler.plugin.version>

    <!--添加jar包依赖-->
    <!--mysql-->
    <mysql.version>8.0.19</mysql.version>
    <!--5.其他-->
    <junit.version>4.12</junit.version>
    <servlet.version>4.0.0</servlet.version>
    <jackson.version>2.9.3</jackson.version>
    <jstl.version>1.2</jstl.version>
    <standard.version>1.1.2</standard.version>
    <tomcat-jsp-api.version>8.0.47</tomcat-jsp-api.version>
    <commons-beanutils.version>1.9.3</commons-beanutils.version>
    <dom4j.version>1.6.1</dom4j.version>
    <jaxen.version>1.1.6</jaxen.version>
    <struts2-core.version>2.5.13</struts2-core.version>
  </properties>
  <dependencies>
    <dependency>
      <groupId>jaxen</groupId>
      <artifactId>jaxen</artifactId>
      <version>${jaxen.version}</version>
    </dependency>

    <dependency>
      <groupId>dom4j</groupId>
      <artifactId>dom4j</artifactId>
      <version>${dom4j.version}</version>
    </dependency>


    <dependency>
      <groupId>commons-beanutils</groupId>
      <artifactId>commons-beanutils</artifactId>
      <version>${commons-beanutils.version}</version>
    </dependency>

    <!--mysql-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>${mysql.version}</version>
    </dependency>

    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>${junit.version}</version>
      <scope>test</scope>
    </dependency>

    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>${servlet.version}</version>
      <scope>provided</scope>
    </dependency>

    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-databind</artifactId>
      <version>${jackson.version}</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-core</artifactId>
      <version>${jackson.version}</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-annotations</artifactId>
      <version>${jackson.version}</version>
    </dependency>

    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>${jstl.version}</version>
    </dependency>
    <dependency>
      <groupId>taglibs</groupId>
      <artifactId>standard</artifactId>
      <version>${standard.version}</version>
    </dependency>
    <dependency>
      <groupId>org.apache.tomcat</groupId>
      <artifactId>tomcat-jsp-api</artifactId>
      <version>${tomcat-jsp-api.version}</version>
    </dependency>

    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.18.10</version>
      <scope>provided</scope>
    </dependency>

    <dependency>
      <groupId>com.belerweb</groupId>
      <artifactId>pinyin4j</artifactId>
      <version>2.5.0</version>
    </dependency>

    <dependency>
      <groupId>com.github.davidcarboni</groupId>
      <artifactId>encrypted-file-upload</artifactId>
      <version>2.1.0</version>
    </dependency>
    
    <dependency>
			<groupId>org.apache.struts</groupId>
			<artifactId>struts2-core</artifactId>
			<version>${struts2-core.version}</version>
		</dependency> 
  </dependencies>
  
		
		
	<build>
		<finalName>struts</finalName>
		<plugins>
			<plugin>
				<groupId>org.apache.maven.plugins</groupId>
				<artifactId>maven-compiler-plugin</artifactId>
				<version>3.7.0</version>
				<configuration>
					<source>1.8</source>
					<target>1.8</target>
					<encoding>UTF-8</encoding>
				</configuration>
			</plugin>
		</plugins>
	</build>
</project>

三、导入帮助类及tid文件

 四、增删改查的编码

1.实体类 2.dao类 3.子控制器

现象：1.编码习惯问题，容易出现大小写配置错误

           2.每个子控制器都要实现对应接口，拿到request和respons对象

           3.向前端页面反馈的数据变量不统一

基于以上进行优化（BaseAction）

BaseAction内容

package com.sjy.web;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts2.interceptor.ServletRequestAware;
import org.apache.struts2.interceptor.ServletResponseAware;

import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;

public abstract class BaseAction<T> extends ActionSupport implements ServletRequestAware,ServletResponseAware,ModelDriven<T>{
protected static final String LIST="list";
protected static final String TOLIST="toList";
protected static final String TOEDIT="toEdit";
protected HttpServletRequest req;
protected HttpServletResponse resp;
protected HttpSession session;
@Override
public void setServletResponse(HttpServletResponse response) {
	this.resp=response;
}
@Override
public void setServletRequest(HttpServletRequest request) {
	this.req=request;
	this.session=request.getSession();
}
protected Object result;
protected String msg;
protected int code;
public Object getResult() {
	return result;
}
public void setResult(Object result) {
	this.result = result;
}
public String getMsg() {
	return msg;
}
public void setMsg(String msg) {
	this.msg = msg;
}
public int getCode() {
	return code;
}
public void setCode(int code) {
	this.code = code;
}

@Override
public String toString() {
	return "BaseAction [req=" + req + ", resp=" + resp + ", session=" + session + ", result=" + result + ", msg=" + msg
			+ ", code=" + code + "]";
}

}

子控制器只需继承该类即可

实体类

package com.sjy.entity;

public class Clz {

	private int cid;
	private String cname;
	private String cteacher;
	private String pic;
	public int getCid() {
		return cid;
	}
	public void setCid(int cid) {
		this.cid = cid;
	}
	public String getCname() {
		return cname;
	}
	public void setCname(String cname) {
		this.cname = cname;
	}
	public String getCteacher() {
		return cteacher;
	}
	public void setCteacher(String cteacher) {
		this.cteacher = cteacher;
	}
	public String getPic() {
		return pic;
	}
	public void setPic(String pic) {
		this.pic = pic;
	}
	@Override
	public String toString() {
		return "Clz [cid=" + cid + ", cname=" + cname + ", cteacher=" + cteacher + ", pic=" + pic + "]";
	}
	
}

dao类

package com.sjy.dao;

import java.util.List;

import com.sjy.entity.Clz;
import com.zking.util.BaseDao;
import com.zking.util.PageBean;

public class ClzDao extends BaseDao<Clz>{

	public List<Clz> list(Clz clz, PageBean pageBean) throws Exception {
		String sql="select * from t_struts_class where 1=1 ";
		int cid = clz.getCid();
		if(cid!=0) {
			sql+=" and cid="+cid;
		}
		return super.executeQuery(sql, Clz.class, pageBean);
	}
	public void add(Clz t) throws Exception {
		String sql="insert into t_struts_class values(?,?,?,?)";
		super.executeUpdate(sql, t, new String [] {"cid","cname","cteacher","pic"});
	}
	public void del(Clz t) throws Exception {
		String sql="delete from t_struts_class where cid=?";
		super.executeUpdate(sql, t, new String [] {"cid"});
	}
	public void edit(Clz t) throws Exception {
		String sql="update t_struts_class set cname=?,cteacher=?,pic=? where cid=?";
		super.executeUpdate(sql, t, new String [] {"cname","cteacher","pic","cid"});
	}
}

子控制器

package com.sjy.web;


import com.sjy.dao.ClzDao;
import com.sjy.entity.Clz;
import com.zking.util.PageBean;

public class ClzAction extends BaseAction<Clz>{
	
	@Override
	public Clz getModel() {
		return clz;
	}
	private Clz clz=new Clz();
	private ClzDao clzDao=new ClzDao();
    public String list() throws Exception {
	PageBean pageBean=new PageBean();
	pageBean.setRequest(req);
	this.result = clzDao.list(clz, pageBean);
	this.req.setAttribute("result", result);
	this.req.setAttribute("pageBean", pageBean);
	return LIST;
}

public String add() throws Exception {
	clzDao.add(clz);
	return TOLIST;
}
public String del() throws Exception {
	clzDao.del(clz);
	return TOLIST;
}
public String edit() throws Exception {
	clzDao.edit(clz);
	return TOLIST;
}
public String toEdit() throws Exception {
	int cid=clz.getCid();
	if(cid!=0) {
		this.result= clzDao.list(clz, null).get(0);
		this.req.setAttribute("result", result);
	}
	return TOEDIT;
}


}

界面