Display Result set in Different Jsp pages

kalya · Sep 14, 2000

Hello Friends, My Object has a result set which gets a large data(around 5000 records). I first wrote a JSP which gets all the data in one single page. But here half of my jsp works fine and the other half doesnt. Someone told me that its because of Single JSP page and asked me to break it and display it in different pages. I have no clue how to display it in different pages. I am just a beginner and started using JSP just a week ago.
Can anyone help!!!!!!!!!!!!!!!!

thanks

sunKing · Sep 18, 2000

from Duane Fields book - "wed developement with JavaServer Pages" - get it - worh every $$

get the "sun.jdbc.rowset.*" package from java.sun
make sure you have a driver for your database

<%@ page import="java.sql.*,javax.sql.*,sun.jdbc.rowset.*" %>
<jsp:useBean id="crs" class="CachedRowSet" scope="session">
<% try { Class.forName("your.Driver&quot

; }
catch (ClassNotFoundException e) {
System.err.println("Error" + e);
}
%>
<jsp:setProperty name="crs" property="url"
value="jdbc

ostgresql://locationOf/yourDBTable" />
<jsp:setProperty name="crs" property="username" value="guest" />
<jsp:setProperty name="crs" property="password" value="apple" />
<jsp:setProperty name="crs" property="command"
value="select * from shuttles order by id" />
<% try { crs.execute(); }
catch (SQLException e) { out.println("SQL Error: " + e); }
%>
</jsp:useBean>

<html>
<body>
<center>
<h2>Cached Query Results</h2>
<P>
<table border="2">
<tr bgcolor="tan">
<th>id</th><th>Airport</th><th>Departure</th><th>Seats</th></tr>
<% try {
if ("first".equals(request.getParameter("action&quot

))
crs.beforeFirst();
for (int i=0; (i < 5) && crs.next(); i++) {
%>
<tr>
<td><%= crs.getString("id&quot

%></td>
<td><%= crs.getString("airport&quot

%></td>
<td><%= crs.getString("time&quot

%></td>
<td><%= crs.getString("seats&quot

%></td>
</tr>
<% } %>
</table>
</p>
<% if (crs.isAfterLast()) {
crs.beforeFirst(); %>
<br>At the end of the result set<br>
<% } }
catch (SQLException e) { out.println("SQL Error" + e); }
%>

<a href="<%= HttpUtils.getRequestURL(request) %>?action=first">
[First 5]</a> 
<a href="<%= HttpUtils.getRequestURL(request) %>?action=next">
[Next 5]</a> 
</center>
</body>
</html>
[sig][/sig]

kumarbabu · Sep 25, 2000

hi kalya,
let me give u the way how u can do this hope this will solve
the purpose.create the logic based on the record size and
the number of records to be displayed.ie if u want to display 200 records(let us say) then for the first 200 records only the forward button should appear and next back and forward and for every click on the buttons the same page should be called ie the page calling itself.if u r still not sure how to implement it here is the clue.
create a session value where when forward is clicked the session should be incremented by 200 and decremented by200
when the backward is clicked.if u still have problem.u can
contact me again. all the best
[sig][/sig]

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Display Result set in Different Jsp pages

kalya

Programmer

sunKing

Programmer

kumarbabu

Programmer

Similar threads

Part and Inventory Search

Sponsor