批量删除

1.list.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!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>展示员工信息</title>
<link rel="stylesheet" href="${pageContext.servletContext.contextPath}/css/index_work.css"/>
<script type="text/javascript" src="${pageContext.servletContext.contextPath}/js/jquery-1.8.2.min.js"></script>
<script type="text/javascript">
    $(function(){
        $("#selectAll").click(function(){
            $("[name='eid']").prop("checked", $(this).prop("checked"));
        });
        
        $("#deleteMore").click(function(){
            $("form").attr("action", $(this).attr("href")).submit();
            return false;//关闭默认跳转
        });
    });
</script>
</head>
<body>
    <form method="post">
        <input type="hidden" name="_method" value="DELETE"/>
        <table>
            <tr>
                <th>
                    <input type="checkbox" id="selectAll">
                </th>
                <th>EID</th>
                <th>ENAME</th>
                <th>AGE</th>
                <th>SEX</th>
                <th>DEPARTMENTNAME</th>
                <th>OPTIONS</th>
            </tr>
            <c:forEach items="${empList}" var="emp">
                <tr>
                    <td>
                        <input type="checkbox" name="eid" value="${emp.eid}"/>
                    </td>
                    <td>${emp.eid}</td>
                    <td>${emp.ename}</td>
                    <td>${emp.age}</td>
                    <td>${emp.sex == 0 ? '女':'男'}</td>
                    <td>${emp.dept.dname}</td>
                    <td>
                        <a href="emp">删除</a>
                        <a href="${pageContext.servletContext.contextPath}/emp/${emp.eid}">修改</a>
                    </td>
                </tr>
            </c:forEach>
            <tr>
                <td colspan="10">
                    <a id="deleteMore" href="${pageContext.servletContext.contextPath}/emps">批量删除</a>&nbsp;
                    ${page}
                </td>
            </tr>
        </table>
    </form>
</body>
</html>

2.EmpMapper.java

public interface EmpMapper {
    //获取所有的员工信息
    List<Emp> getAllEmp();
    
    ......
    
    void deleteMore(String eids);
}

3.EmpMapper.xml

<!-- void deleteMore(String eids); -->
<delete id="deleteMore">
    delete from emp where eid in (${value})
</delete>

4.EmpService.java

public interface EmpService {
    ......
    
    void deleteMore(String eids);
}

5.EmpServiceImpl.java

@Service
public class EmpServiceImpl implements EmpService{
    @Autowired
    private EmpMapper empMapper;
    
    ......

    @Override
    public void deleteMore(String eids) {
        // TODO Auto-generated method stub
        empMapper.deleteMore(eids);
    }
}

6.EmpController.java

@Controller
public class EmpController {

    @Autowired
    private EmpService service;
    
    ......
    
    @RequestMapping(value="/emps", method=RequestMethod.DELETE)
    public String deleteMore(String eid){
        //获取客户端name属性相同的多个元素的值，可以通过字符串直接获取，每个值以逗号分隔，也可以以数组直接获取
        System.out.println(eid);
        service.deleteMore(eid);
        return "redirect:/emps/1";
    }
}

victory的博客

SSM | 批量删除

批量删除