《Struts 的 crud》

女爷i 2022-04-17 05:52 293阅读 0赞

（部分代码，内有注释）  
**1，BaseAction**

package com.zy.action;
    
    import javax.servlet.ServletContext;
    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;
    
    /**
     * 
     * 通用Action
     * 1：传值处理
     * 2：结果码配置
     * 3：向客服端返回提示信息
     * 
     * @author 1
     *
     */
    public class BaseAction implements ServletRequestAware,ServletResponseAware{
    //	1:传值处理
    //	作用域传值
    	protected HttpServletResponse response;
    	protected HttpServletRequest request;
    	protected HttpSession session;
    	protected ServletContext application;
    //	值栈传值
    	protected Object result;
    	
    	public Object getResult() {
    		return result;
    	}
    
    	public void setResult(Object result) {
    		this.result = result;
    	}
    
    
    //	2：结果码配置 （ctrl+shift+x：转为大写 ；    ctrl+shift+y：转为小写 ）
    	protected final String SUCCCESS = "succcess"; //成功
    	protected final String FAIL = "fail"; //失败
    	protected final String LIST = "list"; //结果集
    	protected final String PREADD = "preAdd"; //准备增加
    	protected final String PREEDIT = "preEdit"; //准备修改
    	protected final String TOLIST = "toList"; //编辑成功
    	protected final String DETAIL = "succcess"; //加载详情
    	
    //	3：向客服端返回提示信息
    	protected Object msg; //执行成功/失败（msgInfo:错误信息；handle:解决办法）
    	protected int code; 
    	
    	public Object getMsg() {
    		return msg;
    	}
    
    	public void setMsg(Object msg) {
    		this.msg = msg;
    	}
    
    	public int getCode() {
    		return code;
    	}
    
    	public void setCode(int code) {
    		this.code = code;
    	}
    
    	
    	
    	@Override
    	public void setServletResponse(HttpServletResponse response) {
    		this.response = response;
    		
    	}
    
    	@Override
    	public void setServletRequest(HttpServletRequest request) {
    		this.request = request;
    		this.session = request.getSession();
    		this.application = request.getServletContext();
    		
    	}
    	
    	
    
    }

**2，Action**

package com.zy.action;
    
    import java.sql.SQLException;
    
    import com.zy.dao.ClazzDAO;
    
    public class ClzAction extends BaseAction{
    	
    	public String execute() {
    		try {
    			this.result = new ClazzDAO().list();
    		} catch (InstantiationException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (IllegalAccessException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		return null;
    	}
    	
    	
    }

package com.zy.action;
    
    import java.sql.SQLException;
    
    import com.opensymphony.xwork2.ModelDriven;
    import com.zy.dao.StudentDAO;
    import com.zy.entity.Student;
    import com.zy.util.PageBean;
    
    public class StudentAction extends BaseAction implements ModelDriven<Student>{
    	
    	private Student student = new Student();
    	private StudentDAO studentDao=new StudentDAO();
    	
    	/**
    	 * 查询
    	 * @return
    	 */
    	public String list() {
    		try {
    			this.result = this.studentDao.list(student, new PageBean());
    		} catch (InstantiationException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (IllegalAccessException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		return this.LIST;
    	}
    	
    	/**
    	 * 准备增加
    	 * @return
    	 */
    	public String preAdd() {
    		return PREADD;
    	}
    	
    	/**
    	 * 增加
    	 * @return
    	 */
    	public String add() {
    		try {
    			this.studentDao.add(student);
    		} catch (InstantiationException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (IllegalAccessException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (NoSuchFieldException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (SecurityException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		return TOLIST;
    	}
    	
    	/**
    	 * 准备修改
    	 * @return
    	 */
    	public String preEdit() {
    		try {
    			this.result = this.studentDao.load(student);
    		} catch (InstantiationException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (IllegalAccessException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		return PREEDIT;
    	}
    	
    	/**
    	 * 修改
    	 * @return
    	 */
    	public String edit() {
    		try {
    			this.studentDao.edit(student);
    		} catch (InstantiationException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (IllegalAccessException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (NoSuchFieldException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (SecurityException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		return TOLIST;
    	}
    	
    	/**
    	 * 删除
    	 * @return
    	 */
    	public String del() {
    		try {
    			this.studentDao.del(student);
    		} catch (InstantiationException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (IllegalAccessException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (NoSuchFieldException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (SecurityException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		return TOLIST;
    	}
    	
    	
    	
    	@Override
    	public Student getModel() {
    		// TODO Auto-generated method stub
    		return student;
    	}
    	
    	
    
    }

**3，web.xml**

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
      <display-name>Y2_struts_crud</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>*.action</url-pattern>
      </filter-mapping>
    </web-app>

**4，Struts-sy.xml**

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE struts PUBLIC
        "-//Apache Software Foundation//DTD Struts Configuration 2.5//EN"
        "http://struts.apache.org/dtds/struts-2.5.dtd">
        
    <struts>
    
     <package name="sy" extends="base" namespace="/sy">
     
      <action name="helloAction" class="com.zy.action.helloAction">
       <result name="demo2">/Demo2.jsp</result>
      </action>
      
      
      <action name="calAction_*" class="com.zy.action.calAction" method="{1}">
       <result name="demo2">/Demo2.jsp</result>
      </action>
      
      <action name="paramAction" class="com.zy.action.paramAction">
       <result name="name">/Demo2.jsp</result>
      </action>
      
      <action name="demo7Action" class="com.zy.test.Demo7">
       <result name="demo2">/Demo2.jsp</result>
      </action>
      
      <action name="tagAction" class="com.zy.action.tagAction">
       <result name="demo3">/demo3.jsp</result>
      </action>
      
      
      
      
      <action name="clzAction" class="com.zy.action.ClzAction"></action>
      
      <action name="StudentAction_*" class="com.zy.action.StudentAction" method="{1}">
       <result name="list">/crud/listStudent.jsp</result> 
       <result name="preAdd">/crud/addStudent.jsp</result> 
       <result name="preEdit">/crud/editStudent.jsp</result> 
       <result name="toList" type="redirect">/sy/StudentAction_list.action</result> 
      </action>
      
      
      
     </package>
     
    </struts>

**5，jsp页面**

5.1：查询页面

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
    <%@ include file="/jsp/common/head.jsp" %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>list 页面</title>
    </head>
    <body>
    
    <s:action name="clzAction" namespace="/sy" var="clzAction"></s:action>
    <s:form namespace="/sy" action="StudentAction_list">
     <s:textfield label="姓名" name="sname"></s:textfield>
     <s:select headerKey="" headerValue="<--请选择-->" label="班级" name="cid" list="#clzAction.result" listKey="cid" listValue="cname"></s:select>
     <s:submit value="提交"></s:submit>
    </s:form>
    
    <s:url namespace="/sy" action="StudentAction_preAdd" var="preAddUrl"></s:url>
    <s:a href="%{#preAddUrl}">添加</s:a>
    
    	<table border="1" width="100%">
    		<tr>
    			<td>序号</td>
    			<td>学号</td>
    			<td>姓名</td>
    			<td>拼音</td>
    			<td>性别</td>
    			<td>标记</td>
    			<td>班级</td>
    			<td>操作</td>
    		</tr>
    		<s:iterator var="s" value="result">
    		<tr>
    			<td>序号</td>
    			<td><s:property value="#s.sid"/></td>
    			<td><s:property value="#s.sname"/></td>
    			<td><s:property value="#s.spin"/></td>
    			<td><s:property value="#s.sex"/></td>
    			<td><s:property value="#s.mark"/></td>
    			<td><s:property value="#s.cname"/></td>
    			<td>
    			
    			<s:url namespace="/sy" action="StudentAction_preEdit" var="preEditUrl">
    			 <s:param name="sid" value="#s.sid"></s:param>
    			</s:url>
                <s:a href="%{#preEditUrl}">修改</s:a>
                
                <s:url namespace="/sy" action="StudentAction_del" var="delUrl">
                 <s:param name="sid" value="#s.sid"></s:param>
                </s:url>
                <s:a href="%{#delUrl}">删除</s:a>
    			
    			</td>
    		</tr>
    		</s:iterator>
    	</table>
    
    </body>
    </html>

5.2：增加页面

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <%@ include file="/jsp/common/head.jsp" %>
    </head>
    <body>
    	<h1>add</h1>
    	
    	<s:action name="clzAction" namespace="/sy" var="clzAction"></s:action>
    	<s:form namespace="/sy" action="StudentAction_add">
    		<%-- <s:hidden name="sid" value="5"/> --%>
    		<s:textfield label="学号" name="sid" />
    		<s:textfield label="姓名" name="sname" />
    		<s:radio label="性别" name="sex" list="{'男','女'}"/>
    		<s:select label="班级" name="cid" headerKey="" headerValue="===请选择===" list="#clzAction.result" listKey="cid" listValue="cname" cssStyle="width:160px;" />
    		<s:textarea label="备注" name="mark"></s:textarea>
    		<s:submit value="确定"/>
    	</s:form>
    	
    </body>
    </html>

5.3：修改页面