假删除业务-单表实现
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'list.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<table>
<tr>
<c:if test="${x==1}">
<th>
<button onclick="location='list.do?x=0'">回收站</button>
</th>
</c:if>
<c:if test="${x==0}">
<th>
<button onclick="location='list.do?x=1'">返回列表</button>
</th>
<th>
<button onclick="location='delAll.do'">彻底删除</button>
</th>
<th>
<button onclick="location='returnAll.do'">还原</button>
</th>
</c:if>
</tr>
<tr>
<th>id</th>
<th>name</th>
<th>age</th>
<th>sex</th>
</tr>
<c:if test="${x==1}">
<c:forEach items="${userList }" var="u">
<c:if test="${u.num==1}">
<tr>
<th>${u.id }</th>
<th>${u.name }</th>
<th>${u.age }</th>
<th>${u.sex }</th>
<th><input type="button" value="删除" onclick="location='updateUser.do?id=${u.id}'"></th>
</tr>
</c:if>
</c:forEach>
</c:if>
<c:if test="${x==0}">
<c:forEach items="${userList }" var="u">
<c:if test="${u.num==0}">
<tr>
<th>${u.id }</th>
<th>${u.name }</th>
<th>${u.age }</th>
<th>${u.sex }</th>
</tr>
</c:if>
</c:forEach>
</c:if>
</table>
</body>
</html>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.mapper.UserMapper">
<select id="getUserList" resultType="com.dto.User">
select * from t_user
</select>
<update id="updateUser">
update t_user set num=0 where id=#{id}
</update>
<update id="returnAll">
update t_user set num=1
</update>
<delete id="delAll">
delete from t_user where num=0
</delete>
</mapper>
没死就不要把自己当成废物