批量删除(复选框)

批量删除(复选框)

<a id="batchDel" href="javascript:void(0)">批量删除</a>

<c:forEach items="${requestScope.questionTypes}" var="questionType" varStatus="stat" >
	<table class="result-tab">
		 <input class="allChoose" type="checkbox" />
		 <tr id="tr${questionType.id}">
			<td><input data-id="${questionType.id}" type="checkbox" /></td>
			<td>${questionType.title}</td>
		</tr>
	</table>
<c:forEach>

为表格头部的 全选 复选框添加点击事件

$(".allChoose").click(function(){
	$(".result-tab:checkbox").prop("checked",$(this).prop("checked"));  
	//$("input[type='checkbox']").prop("checked", true);选中所有页面上的复选框
})

为批量删除按钮添加点击事件

$("#batchDel").click(function(){
	var ids = new Array();
	$(".result-tab:checked[class!='allChoose']").each(function(){
		var id =$(this).data("id");
		ids.push(id);
	})
	if(ids.length>0)
	{
		$.get(path+"/servlet/QuestionTypeServlet?action=deleteBatch",{ids:ids.toString()},
			function()
			{
				for(var i=0;i<ids.length,i++)
				{
					$("#tr"+ids[i]).remove();
				}
			}
		)//ajax结束
	}
})

Servlet

 protected void deleteBatch(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
       String ids = request.getParameter("ids");
        System.out.println("ids="+ids);
       QuestionTypeDAO.getDao().delete(ids);
    }

DAO

  public void delete(String ids) {
        String sql ="update question_type set enable=0 where id in("+ids+")";
        DBHelper.getHelper().executeUpdate(sql);
    }
}