This week's book giveaway is in the Java in General forum.
We're giving away four copies of Think Java: How to Think Like a Computer Scientist and have Allen B. Downey & Chris Mayfield on-line!
See this thread for details.
Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

retrieving data pagewise

 
Shashank Anand
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I need to retrieve data from mysql database using jsp and servlets and display it in pages, 5 records per page. And provide for link to next page to display next 5 records. I am using command like SELECT name,date,message FROM my_table ORDER BY date LIMIT 5 OFFSET 5 to display 5 records. Please anyone suggest me how to display the records in pages. I am using netbeans 6.5


Thanks in advance.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64824
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Since you already know about LIMIT and OFFSET you are obtaining the data in pages already. What's your specific issue?
 
Shashank Anand
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I want to know how to provide links to different pages with result got as above (using resultset and stored in arrays), if I am using the above code is a jsp page.



Thanks.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64824
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Links have nothing to do with resultsets. You'd simply need to keep track of what "page" you are one (perhaps in a hidden input) and increment it for "next" or decrement it for "previous".
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic