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();
}