<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>
Last edited by peter_budo : Jun 9th, 2008 at 3:02 am. Reason: Keep It Organized - please use [code] tags
