how to delete multiple records using jsp

•

What is DaniWeb IT Discussion Community?

You're currently browsing the JSP section within the Web Development category of DaniWeb, a massive community of 330,218 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,834 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

•

FAQ | Community Rules | Welcome Guide

Please support our JSP advertiser: Lunarpages JSP Web Hosting

Thread Tools Display Modes

Views: 125 | Replies: 1

•

Join Date: May 2008

Posts: 1

Reputation: ashish1234 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

ashish1234 ashish1234 is offline

Offline

Newbie Poster

how to delete multiple records using jsp

5 Days Ago

hi,
i am new to jsp..i am trying do sort out a pblm..
i have 2 jsp files..

file1.jsp..
which is used to select all the records from a table called staff and display the records in a table..each record is coming with a check boxes which is used for marking..

i need to select all the records i want to delete and by pressing a submit button i want to delte all the records frm the table..
how is it possible..i wrote the code for the first part..it is like..

page1.jsp

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
<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>

how to do the second part...any one to help me plzzzz....

Last edited by peter_budo : 4 Days Ago at 7:27 am. Reason: Keep It Organized - please use [code] tags

•

Join Date: Dec 2004

Location: London or Slovakia

Posts: 1,551

Reputation: peter_budo will become famous soon enough

Rep Power: 8

Solved Threads: 149

peter_budo peter_budo is offline

Offline

Posting Virtuoso

Re: how to delete multiple records using jsp

4 Days Ago

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

Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.