Deleting multiple records through Checkbox with jsp
In my project To-Do List , I had a problem about how to delete multiple records through checkbox, for that I was searching code and I got link which was very suitable for for my project. Make following code as delete.jsp
<%@ page import="java.sql.*"%>
<%
String deleteArray[] = request.getParameterValues("select");
String selected="";
if (deleteArray != null) {
if(deleteArray.length == 1) {
// Only one item is selected
selected = deleteArray[0];
} else {
// multiple items selected
for (int i = 0; i < deleteArray.length; i++) {
selected += deleteArray[i];
if( i < deleteArray.length -1) {
selected += ",";
}
}
}
}
%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection("jdbc:odbc:Task","","");
Statement st = c.createStatement();
PreparedStatement pst = c.prepareStatement("DELETE FROM tasklist WHERE task_id IN
("+selected+")");
pst.executeUpdate();
%>
If you want to know more about it,then follow this link http://forum.java.sun.com/thread.jspa?threadID=629227&messageID=3633428
