jsp页面中实现复选框全选和反选、选中删除功能

jsp中表单页面

<span style="font-size:12px;"><form action="<%= request.getContextPath() %>/DelectServlet" method=post>
	  <tr>
	  				  <th>
	  				  	全选/反选<input type="checkbox" id="checkall" name="checkall" οnclick="checkAll(checkall)" /><br>
	  				  	  	   <input type="submit" value="删除"  οnclick="return confirm('确定删除选择项？')" align="left">
  	   							<input type="button"  value="修改" οnclick="doDelete()" align="left">
	  				  </th>
					  <th>编号</th>
					  <th>用户名</th>
					  <th>密码</th>
					  <th>姓名</th>
					  <th>邮箱</th>
					  <th>性别</th>
					  <th>生日</th>
					  <th>爱好</th>
					  <th>薪水</th>
					  <th>其他</th>
					  <th>角色</th>
	  </tr>

	   <c:forEach var="person" items="${jsp}">
  	  <tr>
  	  		<td align ="center"><input type="checkbox" id=' ${person.id}' name='info' value= '${person.id}' /></td>
  	  		<td>${person.id}</td>
  	  		<td>${person.username}</td>
  	  		<td>${person.passwd}</td>
  	  		<td>${person.realname}</td>
  	  		<td>${person.email}</td>
  	  		<td>${person.sex}</td>
  	  		<td>${person.birth}</td>	
  	  		<td>${person.habit}</td>	
  	  		<td>${person.salary}</td>
  	  		<td>${person.other}</td>
  	  		<td>${person.role}</td>			

  	   </tr> 	  
  	   </c:forEach>


  	   </form></span>

js实现全选反选功能

<script type="text/javascript">
		function checkAll(checkall) {  
			arr = document.getElementsByName('info' ); 
			if (checkall.checked == true) { 
				for(i=0;i<arr.length;i++){ 
					
					arr[i].checked = true; 
				}

				}else{
					for(i=0;i<arr.length;i++){ 
						if((arr[i]).checked==false){
							arr[i].checked = true;
						}else
						{arr[i].checked = false; }
					}
				}
	}  

		</script>

实现选中删除的servlet类

package servlet;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Dao.Dao;
import Dao.DaoJDBCImpl;

/**
 * Servlet implementation class DelectServlet
 */
public class DelectServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
   protected void processRequest(HttpServletRequest request, HttpServletResponse response)
		    throws ServletException, IOException {
	   response.setContentType("text/html;charset=UTF-8");
	   PrintWriter out=response.getWriter();
	   String[] selectdelete = request.getParameterValues("info"); 
	   String ids =""; 
	   for(int i=0;i<selectdelete.length;i++){ 
	   ids += "'"+selectdelete[i]+"'"; 
	   if(i!=selectdelete.length-1) ids+=","; 
	   try {
		Dao dao = new DaoJDBCImpl();
		dao.remove(ids);
		out.print("<script language='javascript'>alert('删除成功！');window.location.href='ShowServlet';</script>");
		out.flush();
		out.close();
	} catch (Exception e) {
		// TODO Auto-generated catch block

	}
	   }
   }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
   protected void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
       processRequest(request, response);
   } 

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
   protected void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
       processRequest(request, response);
   }

}

jdbc数据库删除数据

    //删除人员

    public void remove(String id) throws Exception{
    	 dbc = new DaoJDBCImpl();
    	 String sql="delete from person where id in ("+id+")";
    	 PreparedStatement pst = dbc.getConnection().prepareStatement(sql);
    	 pst.executeUpdate();
        pst.close();
        dbc.close();
    }