It's not a secret anymore!*
The moose likes JDBC and the fly likes Displaying records Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Displaying records" Watch "Displaying records" New topic
Author

Displaying records

Megha Rajeevan
Greenhorn

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..

regards
Megha..
Carl Trusiak
Sheriff

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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30130
    
150

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


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
wood burning stoves
 
subject: Displaying records
 
Similar Threads
Problem while displaying the LIst in JSP
Pagebreak in JSP Page
How to Edit Details in database using JSP page?
navigate through a resultset in a jsp page
ResultSet Paging Help