hi dave
i started doing exactly what you have told.the following is my code for displaying all the listings from the database.now i want to check only a selected few and show only those things.
thanx
prem
<html>
<head>
<title>
Show Responsibility list
</title>
</head>
<%@ page language="java" import="java.sql.*" %>
<body>
<h1>Responsibility List</h1>
<table border="1" width="400">
<form action="showSelectedList.jsp" method=post>
<tr>
<td><b></b></td>
<td><b>Responsibility</b></td>
<td><b>Role Name</b></td>
</tr>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc
racle:thin:@172.16.40.53:1521:cms","system","manager");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM SCOTT.CMS_responsibilities");
if (rs != null)
{
while (rs.next()){
String respoid=rs.getString("respo_id");
String responame=rs.getString("respo_name");
String rolename=rs.getString("role_name");
%>
<tr>
<td><input type=checkbox name=respoid value=<%=respoid %></td>
<td><%=responame %></td>
<td><%=rolename %></td>
</tr>
<%
}
}
stmt.close();
con.close();
%>
<tr colspan=5>
<td><input type=submit value="Show Selected Items"></td>
</tr>
</form>
</table>
</body>
</html>