File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes How can a rownum help in implementing Pagination Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How can a rownum help in implementing Pagination " Watch "How can a rownum help in implementing Pagination " New topic
Author

How can a rownum help in implementing Pagination

Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

Hi

How can we use rownum technique to implement pagination .

My query is that we use rownum to limit the the number of records given by database engine .

Where as the concept of Pagination involves to display results based on the click of the Hyper Link
(Similar to Google Search )

For example if i click on "4" Hyperlink i want to display data from 40th record to 50th record , how a rowmnum can help in this case ??

Please share your ideas .

Thanks in advance .






Save India From Corruption - Anna Hazare.
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 9343
    
111

There's a journal article for this.

[My Blog] [JavaRanch Journal]
Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

the link is so helpful .

Thank you very much .

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How can a rownum help in implementing Pagination
 
Similar Threads
Pagination
Pagination
Pagination In struts with oracle database
Pagination
Pagination Query in Oracle