There are a bunch of products around that provide tabulated data display with paging.
Of course, I will mention ours: TICL, get it at http://www.kobrix.com. I'm sure there
are some free ones as well, look around on the JSP related sites. Code sample with
TICL may look like:
<t:tableView model='<%= SQLTableDataFull(connection, ...select statement ...) %>'
pageSize="1000">
<t:tableHeader>
<t:tablePager size="10"/> <!-- Google-like pager of your data -->
</t:tableHeader>
<t:tableColumn name="sql field name" title="Your column title" sortable="true"/>
etc.. other columns to display
</t:tableView>
Boris
----- Original Message -----
From: srinivas tadikonda
To: [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 12:25 AM
Subject: Records Control
Hi,
How can I display limited records in one jsp page. My table haveing 50,000 records.
I want to display these records into browser using jsp.
If I try to display this much records my browser is hanging. because lot of
records. so I want to display 1000 records each page. If user press next button ,
anothor 1000 records will come. at the same time user press previsous button also
previous records will come.
How can I control Resultset . Please tell me. If its possible please send code.
Basically I want to Previous and Next buttons. If you have any better solution
otherthan this please tell me. But My table haveing huge data. I want to display this
into one report format.
Regards
srinivas
------------------------------------------------------------------------------
Send and receive Hotmail on your mobile device: Click Here
=========================================================================== To
unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For
digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some
relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
==========================================================================To
unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
