struts_crud

最新推荐文章于 2021-10-20 23:00:00 发布

weixin_43710113

最新推荐文章于 2021-10-20 23:00:00 发布

阅读量157

点赞数

分类专栏： Java 文章标签： struts_crud

本文链接：https://blog.csdn.net/weixin_43710113/article/details/94282665

版权

Java 专栏收录该内容

33 篇文章 0 订阅

订阅专栏

struts实现crud

CRUD是Create（创建）、Read（读取）、Update（更新）和Delete（删除）
利用struts完成增删改查
思路：
1、导入相关的pom依赖（struts、自定义标签库的依赖）、还有MySQL 依赖

  <dependencies>
  
    <dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>4.12</version>
			<scope>test</scope>
		</dependency>
		
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>javax.servlet-api</artifactId>
			<version>4.0.1</version>
			<scope>provided</scope>
		</dependency>
	
		<dependency>
			<groupId>org.apache.struts</groupId>
			<artifactId>struts2-core</artifactId>
			<version>2.5.13</version>
		</dependency>
    
    	<dependency>
			<groupId>jstl</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>
		<dependency>
			<groupId>taglibs</groupId>
			<artifactId>standard</artifactId>
			<version>1.1.2</version>
		</dependency>

		<!-- 5.4、tomcat-jsp-api -->
		<dependency>
			<groupId>org.apache.tomcat</groupId>
			<artifactId>tomcat-jsp-api</artifactId>
			<version>8.0.47</version>
		</dependency>
    	
    	<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.44</version>
		</dependency> 	 	
    
  </dependencies>

2、分页的tag类导入、z.tld、完成web.xml的配置
tag类里就是一个简单公用的分页：PageTag：

package com.xzy.tag;

import java.util.Map;

import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.tagext.BodyTagSupport;

import com.xzy.util.PageBean;


public class PageTag extends BodyTagSupport {

	private static final long serialVersionUID = 8003507841172246203L;

	private PageBean pageBean;

	public PageTag() {
		super();
	}

	public PageBean getPageBean() {
		return pageBean;
	}

	public void setPageBean(PageBean pageBean) {
		this.pageBean = pageBean;
	}

	@Override
	public int doStartTag() throws JspException {
		try {
			JspWriter out = pageContext.getOut();
			out.println(this.toHtml());
			return SKIP_BODY;
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
	}

	private String toHtml() {
		StringBuffer bf = new StringBuffer();
		if (null == pageBean || !pageBean.isPagination()) {
			return bf.toString();
		}

		// 1. 生成表单
		bf.append("<form id='pageBeanForm' action='" + pageBean.getUrl() + "' method='post'>");
		bf.append("<input type='hidden' name='page' value=''>");
		for (Map.Entry<String, String[]> entry : pageBean.getParamMap().entrySet()) {
			String name = entry.getKey();
			String[] values = entry.getValue();
			if ("page".equals(name)) {
				continue;
			}

			for (String value : values) {
				bf.append("<input type='hidden' name='" + name + "' value='" + value + "'>");
			}
		}
		bf.append("</form>");

		// 2. 生成按钮
		bf.append("<div style='text-align: right;font-size: 12px;'>每页" + pageBean.getRows() + "条，共"
				+ pageBean.getTotal() + "条，当前第" + pageBean.getPage() + "页，共" + pageBean.getMaxPage()
				+ "页&nbsp;&nbsp;<a href='javascript:doGotoPage(1)'>首&nbsp;&nbsp;页</a>&nbsp;&nbsp;<a href='javascript:doGotoPage("
				+ pageBean.getPreviousPage() + ")'>上一页</a>&nbsp;&nbsp;<a href='javascript:doGotoPage("
				+ pageBean.getNextPage() + ")'>下一页</a>&nbsp;&nbsp;<a href='javascript:doGotoPage("
				+ pageBean.getMaxPage()
				+ ")'>尾&nbsp;&nbsp;页</a>&nbsp;&nbsp;<input id='pageNumber' type='text' style='text-align: center;width: 30px;'>&nbsp;&nbsp;<a href='javascript:doSkipPage();'>GO</a></div>");

		// 3. 动态生成js
		bf.append("<script type='text/javascript'>");
		bf.append("function doGotoPage(page){");
		bf.append("  var form = document.getElementById('pageBeanForm');");
		bf.append("  form.page.value = page;");
		bf.append("  form.submit();");
		bf.append("}");
		bf.append("function doSkipPage(page){");
		bf.append("  var page = document.getElementById('pageNumber').value;");
		bf.append("  if(!page||isNaN(page)||parseInt(page)<1||parseInt(page)>"+pageBean.getMaxPage()+"){");
		bf.append("    alert('页码必须为1~"+pageBean.getMaxPage()+"之间数字');");
		bf.append("    document.getElementById('pageNumber').value = '';");
		bf.append("    return;");
		bf.append("  }");
		bf.append("  doGotoPage(parseInt(page));");
		bf.append("}");
		bf.append("</script>");
		bf.append("");
		bf.append("");
		bf.append("");
		bf.append("");
		bf.append("");
		return bf.toString();
	}
}

z.tld : 就是自定义标签库

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" version="3.1">
  <display-name>Archetype Created Web Application</display-name>
  
  <!-- 乱码处理过滤器 -->
  <filter>
    <filter-name>encodingFiter</filter-name>
    <filter-class>com.xzy.util.EncodingFiter</filter-class>
  </filter>
  <filter-mapping>
    <filter-name>encodingFiter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
  <filter>
    <filter-name>struts</filter-name>
    <filter-class>org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter</filter-class>
  </filter>
  <filter-mapping>
    <filter-name>struts</filter-name>
    <url-pattern>*.action</url-pattern>
  </filter-mapping>
</web-app>

3、dao层去访问数据

肯定是要与数据交互的，所以我们先写一个实体类： Clazz.jsva

package com.xzy.entity;

public class Clazz {
	
	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;
	}
	
	/**
	 * 无参构造器
	 */
	public Clazz() {
		super();
	}
	
	/**
	 * 有参构造器
	 * @param cid
	 * @param cname
	 * @param cteacher
	 * @param pic
	 */
	public Clazz(int cid, String cname, String cteacher, String pic) {
		super();
		this.cid = cid;
		this.cname = cname;
		this.cteacher = cteacher;
		this.pic = pic;
	}
	@Override
	public String toString() {
		return "Clazz [cid=" + cid + ", cname=" + cname + ", cteacher=" + cteacher + ", pic=" + pic + "]";
	}
	
}

然后我们util包里还有一些公用的文件
在这里插入图片描述
Dao方法：

package com.xzy.dao;

import java.sql.SQLException;
import java.util.List;

import com.xzy.entity.Clazz;
import com.xzy.util.BaseDao;
import com.xzy.util.PageBean;
import com.xzy.util.StringUtils;

public class ClazzDao extends BaseDao<Clazz>{
	
	/**
	 * 查所有及查单个
	 * 
	 * @param clz
	 * @param pageBean
	 * @return
	 * @throws InstantiationException
	 * @throws IllegalAccessException
	 * @throws SQLException
	 */
	public List<Clazz> list(Clazz clz,PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
		String sql = "select * from tb_class where true";
		int cid = clz.getCid();
		String cname = clz.getCname();
		if(cid != 0) {
			sql += " and cid = "+ cid;
		}
		if(StringUtils.isNotBlank(cname)) {
			sql += " and cname like '%"+cname+"%'";
		}
		return super.executeQuery(sql,Clazz.class ,pageBean);
	}
	
	
	/**
	 * 增加
	 * @param clz
	 * @return
	 * @throws NoSuchFieldException
	 * @throws SecurityException
	 * @throws IllegalArgumentException
	 * @throws IllegalAccessException
	 * @throws SQLException
	 */
	public int add(Clazz clz) throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
		String sql = "insert into tb_class values(?,?,?,?)";
		return super.executeUpdate(sql, new String [] {"cid","cname","cteacher","pic"}, clz);
	}
	
	/**
	 * 修改
	 * @param clz
	 * @return
	 * @throws NoSuchFieldException
	 * @throws SecurityException
	 * @throws IllegalArgumentException
	 * @throws IllegalAccessException
	 * @throws SQLException
	 */
	public int edit(Clazz clz) throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
		String sql = "update tb_class set cname=?,cteacher=?,pic=? where cid=?";
		return super.executeUpdate(sql, new String [] {"cname","cteacher","pic","cid"}, clz);
	}
	
	
	/**
	 * 删除
	 * @param clz
	 * @return
	 * @throws NoSuchFieldException
	 * @throws SecurityException
	 * @throws IllegalArgumentException
	 * @throws IllegalAccessException
	 * @throws SQLException
	 */
	public int del(Clazz clz) throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
		String sql = "delete from tb_class where cid=?";
		return super.executeUpdate(sql, new String [] {"cid"}, clz);
	}
	
}

4、web层去调用dao层给前台返回数据

package com.xzy.web;

import java.sql.SQLException;
import java.util.List;

import com.opensymphony.xwork2.ModelDriven;
import com.xzy.dao.ClazzDao;
import com.xzy.entity.Clazz;
import com.xzy.util.PageBean;

public class ClazzAction extends BaseAction implements ModelDriven<Clazz> {

	private ClazzDao clazzDao = new ClazzDao();
	private Clazz clz = new Clazz();
	/**
	 * 
	 * @return
	 * @throws InstantiationException
	 * @throws IllegalAccessException
	 * @throws SQLException
	 */
	public String list() throws InstantiationException, IllegalAccessException, SQLException {
		PageBean pageBean = new PageBean();
		pageBean.setRequest(request);
		List<Clazz> list = this.clazzDao.list(clz, pageBean);
		// this.result = this.clazzDao.list(clz, pageBean);
		request.setAttribute("clzList", list);
		request.setAttribute("pageBean", pageBean);
		return "list";
	}
	
	/**
	 * 修改
	 * @return
	 * @throws SQLException 
	 * @throws IllegalAccessException 
	 * @throws InstantiationException 
	 */
	public String preSave() throws InstantiationException, IllegalAccessException, SQLException {
		if(clz.getCid() != 0) {
			Clazz c = this.clazzDao.list(clz, null).get(0);
			request.setAttribute("clz", c);
		}
		return "preSave";
	}
	
	/**
	 * 新增
	 * @return
	 * @throws SQLException 
	 * @throws IllegalAccessException 
	 * @throws IllegalArgumentException 
	 * @throws SecurityException 
	 * @throws NoSuchFieldException 
	 */
	public String add() throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
		result = this.clazzDao.add(clz);
		return "toList";
	}
	
	/**
	 * 删除
	 * @return
	 * @throws SQLException 
	 * @throws IllegalAccessException 
	 * @throws IllegalArgumentException 
	 * @throws SecurityException 
	 * @throws NoSuchFieldException 
	 */
	public String del() throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
		this.clazzDao.del(clz);
		return "toList";
	}
	
	/**
	 * 修改
	 * @return
	 * @throws NoSuchFieldException
	 * @throws SecurityException
	 * @throws IllegalArgumentException
	 * @throws IllegalAccessException
	 * @throws SQLException
	 */
	public String edit() throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
		this.clazzDao.edit(clz);
		return "toList";
	}
	
	@Override
	public Clazz getModel() {
		// TODO Auto-generated method stub
		return clz;
	}

}

在这有一个通用的Action：
通用的action：
1、处理传值
2、结果码的配置
3、想客户端返回提示信息

package com.xzy.web;

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中。
 * @author Administrator
 *
 */
public class BaseAction implements ServletRequestAware, ServletResponseAware{
	/**
	 * 为了传值使用
	 */
	protected HttpServletResponse response;
	protected HttpServletRequest request;
	protected HttpSession session;
	protected ServletContext application;
	
	/**
	 * 为了配置跳转页面所用	
	 */
	protected final static String SUCCESS = "success";
	protected final static String FAIL = "fail";
	protected final static String LIST = "list";
	protected final static String ADD = "add";
	protected final static String EDIT = "edit";
	protected final static String DETAIL = "detail";
	
	/**
	 * 具体传值字段	后端向jsp页面传值所用字段
	 */
	protected Object result;
	protected Object msg;
	protected int code;

	public Object getResult() {
		return result;
	}

	public Object getMsg() {
		return msg;
	}

	public int getCode() {
		return code;
	}

	@Override
	public void setServletResponse(HttpServletResponse arg0) {
		this.response = arg0;
		
	}

	@Override
	public void setServletRequest(HttpServletRequest arg0) {
		this.request = arg0;
		this.session = arg0.getSession();
		this.application = arg0.getServletContext();
	}
	

}

ClazzAction.java:

package com.xzy.web;

import java.sql.SQLException;
import java.util.List;

import com.opensymphony.xwork2.ModelDriven;
import com.xzy.dao.ClazzDao;
import com.xzy.entity.Clazz;
import com.xzy.util.PageBean;

public class ClazzAction extends BaseAction implements ModelDriven<Clazz> {

	private ClazzDao clazzDao = new ClazzDao();
	private Clazz clz = new Clazz();
	/**
	 * 
	 * @return
	 * @throws InstantiationException
	 * @throws IllegalAccessException
	 * @throws SQLException
	 */
	public String list() throws InstantiationException, IllegalAccessException, SQLException {
		PageBean pageBean = new PageBean();
		pageBean.setRequest(request);
		List<Clazz> list = this.clazzDao.list(clz, pageBean);
		// this.result = this.clazzDao.list(clz, pageBean);
		request.setAttribute("clzList", list);
		request.setAttribute("pageBean", pageBean);
		return "list";
	}
	
	/**
	 * 修改
	 * @return
	 * @throws SQLException 
	 * @throws IllegalAccessException 
	 * @throws InstantiationException 
	 */
	public String preSave() throws InstantiationException, IllegalAccessException, SQLException {
		if(clz.getCid() != 0) {
			Clazz c = this.clazzDao.list(clz, null).get(0);
			request.setAttribute("clz", c);
		}
		return "preSave";
	}
	
	/**
	 * 新增
	 * @return
	 * @throws SQLException 
	 * @throws IllegalAccessException 
	 * @throws IllegalArgumentException 
	 * @throws SecurityException 
	 * @throws NoSuchFieldException 
	 */
	public String add() throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
		result = this.clazzDao.add(clz);
		return "toList";
	}
	
	/**
	 * 删除
	 * @return
	 * @throws SQLException 
	 * @throws IllegalAccessException 
	 * @throws IllegalArgumentException 
	 * @throws SecurityException 
	 * @throws NoSuchFieldException 
	 */
	public String del() throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
		this.clazzDao.del(clz);
		return "toList";
	}
	
	/**
	 * 修改
	 * @return
	 * @throws NoSuchFieldException
	 * @throws SecurityException
	 * @throws IllegalArgumentException
	 * @throws IllegalAccessException
	 * @throws SQLException
	 */
	public String edit() throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
		this.clazzDao.edit(clz);
		return "toList";
	}
	
	@Override
	public Clazz getModel() {
		// TODO Auto-generated method stub
		return clz;
	}

}

5、在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="/clz_*" class="com.xzy.web.ClazzAction" method="{1}">
			<result name="list">/clzList.jsp</result>
			<result name="preSave">/clzEdit.jsp</result>
			<result name="toList" type="redirectAction">/clz_list</result>
		</action>
		
	</package>
</struts>

6、写jsp代码：

界面展示Demo：

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <%@ taglib uri="/xzy" prefix="x" %>
<!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>Insert title here</title>
</head>
<body>
<h2></h2>
	<br>

	<form action="${pageContext.request.contextPath}/sy/clz_list.action" method="post">
		班级名称：<input type="text" name="cname"> 
				 <input type="submit" value="确定">
	</form>
	<a href="${pageContext.request.contextPath}/sy/clz_preSave.action">新增</a>
	<table border="1" width="100%">
		<tr>
			<td>编号</td>
			<td>班级名称</td>
			<td>教员名称</td>
			<td>图片上传</td>
			<td>操作</td>
		</tr>
		<c:forEach items="${clzList }" var="c">
			<tr>
				<td>${c.cid }</td>
				<td>${c.cname }</td>
				<td>${c.cteacher }</td>
				<td>${c.pic }</td>
				
				<td>
					<a href="${pageContext.request.contextPath}/sy/clz_preSave.action?cid=${c.cid}">修改</a>&nbsp;&nbsp;
					<a href="${pageContext.request.contextPath}/sy/clz_del.action?cid=${c.cid}">删除</a>&nbsp;&nbsp;			
					<a href="${pageContext.request.contextPath}/sy/clz_preUpload.action?cid=${c.cid}">图片上传</a>&nbsp;&nbsp;
				</td>
				
			</tr>
		</c:forEach>
	</table>

	<x:page pageBean="${pageBean }"></x:page>


</body>
</html>

在这里插入图片描述
增加、修改通用 clzEdit.jsp:

<%@ 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">
<title>Insert title here</title>
</head>
<body>
	<!-- 新增与修改公用界面 -->
	<form action="${pageContext.request.contextPath}${clz.cname == null ? '/sy/clz_add.action' : '/sy/clz_edit.action'}" method="post">
		cid:<input name="cid" value="${clz.cid }"> <br>
		cname:<input type="text" name="cname" value="${clz.cname}"> <br>
		cteacher:<input type="text" name="cteacher" value="${clz.cteacher}"> <br>
		<%-- pic:<input type="text" name="pic" value="${clz.cname}"> --%>
		<input type="submit"> 
		
	</form>
</body>
</html>

按照自己的思路一步一步来~~~~~~~~~~~~~

weixin_43710113

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
struts_crud

struts实现crudCRUD是Create（创建）、Read（读取）、Update（更新）和Delete（删除）利用struts完成增删改查思路：1、导入相关的pom依赖（struts、自定义标签库的依赖）、还有MySQL 依赖 <dependencies> <dependency> <groupId>junit</gr...
复制链接

扫一扫