<%
Context ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/test");
Connection conn = ds.getConnection();
ResultSet rs=null;
Statement stmt;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM djadwk");
rs.last()
out.print(rs.getRow());
%><h2>Brooms:</h2>
<br>
<%
while (rs.next()) { %>
<%= rs.getString(1) %>--<%=rs.getRow()%> ;
<%= rs.getString(2) %>;
<%= rs.getString(3) %>;
<%= rs.getString(4) %>;
<%= rs.getString(5) %><br>
<%}
}catch(SQLException e ){}finally{stmt.close();}
%>
