jsp删除mysql_jsp+servlet+mysql-----------批量删除

jsp:

method="post">

name="checkall" οnclick="checkAll(checkall)" />

type="submit" value="批量删除" οnclick="return confirm('确定删除选择项？')"

align="left">

	行号	用户编号	用户名	注册人	年龄	性别	编辑

--%>

name="info" value="${user.uid }" type="checkbox">

${stat.count }${user.uid }${user.uname }${user.urealname }${user.uage }${user.usex==1?"男":"女" } 修改  

href="deleteUser?uid=${user.uid }">删除

2 条 1/1 页

js代码：

function checkAll(checkall) {

arr = document.getElementsByName("info");

if (checkall.checked == true) {

for (var i = 0; i < arr.length; i++) {

arr[i].checked = true;

}

} else {

for (var i = 0; i < arr.length; i++) {

if ((arr[i]).checked == false) {

arr[i].checked = true;

} else {

arr[i].checked = false;

}

}

}

}

servlet部分：收集数据，跳转连接

/**

*

*/

package com.qingmang.servlet;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import com.qingmang.dao.UserDao;

import com.qingmang.service.UserService;

/**

* @author administrator

*

*/

public class DeleteServlet extends HttpServlet {

UserDao dao = new UserDao();

UserService service = new UserService();

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

request.setCharacterEncoding("utf-8");

response.setContentType("text/html;charset=utf-8");

PrintWriter out = response.getWriter();

String[] str = request.getParameterValues("info");

/* 如何加非空判断？ */

if (str == null) {

request.getRequestDispatcher("user").forward(request, response);

} else {

String ids = "";

for (int i = 0; i < str.length; i++) {

if (i != str.length - 1) {

ids += str[i] + ",";

} else {

ids += str[i];

}

}

service.remove(ids);

out.print("");

out.flush();

out.close();

}

}

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

doGet(request, response);

}

}

dao层：对数据库的处理

/**

* 根据用户id删除用户

* */

public void remove(String uid){

try {

conn = JdbcUtil.getConnection();

String sql="delete from users where uid in (" + uid + ")";

pstmt = conn.prepareStatement(sql);

pstmt.executeUpdate();

} catch (Exception e) {

e.printStackTrace();

throw new RuntimeException(e);

} finally{

try {

JdbcUtil.close(conn, pstmt);

} catch (Exception e) {

e.printStackTrace();

throw new RuntimeException(e);

}

}

}