基于SSM框架的批量删除的前台+后台实现

喜欢ヅ旅行 2022-05-24 05:15 291阅读 0赞

前台页面：

![20180521161116924][]

前台代码：

<table width="100%" border="1" cellpadding="5" cellspacing="0" style="border:#c2c6cc 1px solid; border-collapse:collapse;">
        <tr class="main_trbg_tit" align="center">
            <td><input type="checkbox" name="checkAll" id="checkAll"></td>
            <td>姓名</td>
            <td>性别</td>
        </tr>
        <c:forEach items="${requestScope.employees}" var="employee" varStatus="stat">
            <tr id="data_${stat.index}" class="main_trbg" align="center">
                <td> <input type="checkbox" id="box_${stat.index}" value="${employee.id}"> </td>
    	    <td> ${employee.name } </td>
    	    <td>
                    <c:choose>
                        <c:when test="${employee.sex == 1 }">男</c:when>
    		    <c:otherwise>女</c:otherwise>
                    </c:choose> </td>
            </tr>
        </c:forEach>
    </table>

JS代码：

后台代码：

@RequestMapping("/removeEmployee.do")
    	public String removeEmployee(Integer[] ids, Model model){
    		
    		int rows = employeeService.removeEmployee(ids);
    		if(rows > 0){
    			return "redirect:/employee/findEmployee.do";
    		} else {
    			model.addAttribute("failMSG", "删除员工失败！");
    			return "/jsp/fail.jsp";
    		}
    	}

这里可以用Integer\[\]类型将接收，也可以用string接收。

Dao层实现（sql）：

<delete id="deleteEmployee">
    		delete from employee_inf where id in
    		<foreach collection="ids" item="id" open="(" close=")" separator=",">
    			#{id}
    		</foreach>
    	</delete>

[20180521161116924]: /images/20220524/cd8c4cc4cf7442b288e3eea3d67ecad1.png