It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Displaying records Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Displaying records" Watch "Displaying records" New topic

Displaying records

Megha Rajeevan

Joined: Mar 22, 2006
Posts: 24
Hello Ranchers..
I'm using JSP and Oracle for the project..
now in one of the table there are 1000 records.. when a user click the search button.. All the records are displaying in the page..
for that displaying purpose i used <iframes> </iframes>..
in this iframes i put the frameborder="0" and scrolling="auto".. So if the record is more that 10 it will automatically shows the scroll bar..

now i've to put only 10 records in the page.. and when i click next button the iframe shows 11-20 records and in next again 21 to 30.. like that..

please help me ranchers
how to code that.. is that any oralce query. or what..

please reply me..
thanks in advance..

Carl Trusiak

Joined: Jun 13, 2000
Posts: 3340
You can use JSTL to establish paging through a list. There's a good discussion with examples Here

I Hope This Helps
Carl Trusiak, SCJP2, SCWCD
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33111

Take a look at Ask Tom's reply to the Oracle query for paging.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Displaying records
It's not a secret anymore!