how to delete multiple records using jsp

peter_budo · 2008-05-09T17:34:06+00:00

JSP is for presentation only (meaning to provide interface for web page), servlet is proper component to setup connection with database. So the process should be as follows

JSP - to collect data
Servlet - execute logic
- Data retrival
- Validation
- Connection to DB
- Retriving any data from DB
- Possibly saving in session
JSP - to display outcome

Validation also can be done on the JSP befor submit, but then you have to know JavaScript or similar

Sprashant -3 Newbie Poster · 2008-06-09T12:49:26+00:00

<html>
<body>

      <table width="50%" border="1" rules=ALL>

      <tr><th> Username</th><th>Access Level</th><th>Delete</th></tr>

      <%@ page language="java" import="java.sql.*" %>

      <%

      int j=0;

      Connection con =null;

      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

      con=DriverManager.getConnection("jdbc:odbc:udsn","","");

      Statement st=con.createStatement();

      ResultSet rs=st.executeQuery("select * from staff");

       

      while (rs.next())

      { j=j+1;%>

      <tr><td align="center"><%=rs.getString(1)%></td><td align="center"><%=rs.getString(3)%></td><td><input type="checkbox" name="delete" value="yes"></tr>

      <%}

      %>

      <form action="deleteuser.jsp">

      <input type="hidden" name="recordcount" value="<%=j%>">

      <input type="submit" name="b1" value="Delete" >

      </table>

      </form>

      </body>

      </html>

<html> <body> <table width="50%" border="1" rules=ALL> <tr><th> Username</th><th>Access Level</th><th>Delete</th></tr> <%@ page language="java" import="java.sql.*" %> <% int j=0; Connection con =null; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:udsn","",""); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from staff"); while (rs.next()) { j=j+1;%> <tr><td align="center"><%=rs.getString(1)%></td><td align="center"><%=rs.getString(3)%></td><td><input type="checkbox" name="delete" value="yes"></tr> <%} %> <form action="deleteuser.jsp"> <input type="hidden" name="recordcount" value="<%=j%>"> <input type="submit" name="b1" value="Delete" > </table> </form> </body> </html>

jwenting 1,889 duckman Team Colleague · 2008-06-09T21:04:21+00:00

and don't revive old dead threads to post nonsense "solutions".