jsp中实现批量删除

核心提示：<td width="10%" align="center"><font face="楷体_GB2312" size="3"><%=rst1.getString(3).trim()%></font&

<td width="10%" align="center"><font face="楷体_GB2312" size="3"><%=rst1.getString(3).trim()%></font></td>
<td width="10%" align="center"><font face="楷体_GB2312" size="3"><%=rst1.getString(2).trim()%></font></td>
<td width="20%" align="center"><font face="楷体_GB2312" size="3"><%=rst1.getString(4).trim()%></font></td>
<td width="10%" align="center"><font face="楷体_GB2312" size="3"><%=rst1.getInt(6)%></font></td>
</tr>
<%
i++;
}
rst1.close();
}
catch(Exception e){}
%>
<tr><td colspan="3"> </td>
<td align="center">
<input type="submit" value="删 除" onclick="return confirm('你确定所选？')"></td></tr>
</table>
</form>
</div>
</div>
</body>
</html>

处理页：

public class CommonDeleteServlet extends HttpServlet {

/**
*
*/
private static final long serialVersionUID = 1L;

/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
PrintWriter out=response.getWriter();
String[] selectdelete = request.getParameterValues("selectdelete");
String ids ="";
for(int i=0;i<selectdelete.length;i++){
ids += "'"+selectdelete[i]+"'";
if(i!=selectdelete.length-1) ids+=",";
}
String sql = "delete from COMMON where id in ("+ids+")";
Connection con = null;
Statement dodel = null;
DBcon dbcon = new DBcon();
try
{
con = dbcon.getConn();
dodel = con.createStatement();
dodel.executeUpdate(sql);

con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
out.print("<script language='javascript'>alert('Do Success');window.location.href='delete.jsp';</script>");
out.flush();
out.close();

}

/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request,response);
}

}