Deleting single/multiple rows from databse using checkbox

[Poonam Dhatavkar]

i want to delete single/multiple rows from database table on clicking the checkbox, in addition it should first show all the rows and columns.
A part of code i am using is:

ResultSet rs = null;
Statement st=null;

st=conn.createStatement();
rs = st.executeQuery("select * from book");

int i=0; 
while(rs.next())
{
%>

<table border="1">
<tr><td><input type="checkbox" name="check<%=i%>" value="<%= rs.getString("bookid")%>"></td>
<td><%=rs.getString("bookid")%></td>
<td><%=rs.getString("author")%></td>
<td><%=rs.getString("title")%></td>
</tr>

<%
i++;
}
}catch(SQLException e){ System.out.println(e.getMessage()); } %>

Problem with the code is, when i remove 'value="<%= rs.getString("bookid")' in input type, only then it shows whole data (select*from book)
and it deletes a row, bt as data is not shown, we cant predict which row is about to delete.


Also in case of deletion of multiple rows,

<%
String deleteArray[] = request.getParameterValues("check");
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 += ",";
}
}
}
}
%>

PreparedStatement pst = conn.prepareStatement("DELETE FROM book WHERE bookid IN("+selected+")");
pst.executeUpdate();

i am getting syntax error as==> Syntax error (missing operator) in query expression 'bookid IN()'.

Can somebody help me ??

[Jan Cumps]

Looking at the error message, it seems your selected variable is empty.
It is easier if you give us the complete error, exactly as it is logged in the program.

[Poonam Dhatavkar]

Message i gt is "No data found"

[Poonam Dhatavkar]

i did some changes in code and database, and now i can delete single row.. bt there is still problem with multiple rows selection and deletion. Is there something wrong with the code ?? like in loops ?
i am not getting any kind of error message.

[Poonam Dhatavkar]

i got the solution.