• Post Reply Bookmark Topic Watch Topic
  • New Topic

pagination  RSS feed

 
Neeraj jain
Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i want to implement the pagination in my application so anyone plss tell me how to implement it ........................and also do tell me the way in oracle to limit the fetching of Record ...................as in MYSql it can be easily done by Select * from tab_name LIMIT 10,20;
 
Ulf Dittmer
Rancher
Posts: 42972
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Lots of good information on this page: https://www.coderanch.com/how-to/java/PaginationOrPaging

Also check out the DisplayTag library.
 
Neeraj jain
Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
heyy thnkxx dude but will you plss also tell me how to implement the pagination in my JSP as i m new to JSP
 
Balaji Vankadaru
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The easiest way would be including display tag in your jsp. later on just few declarations of your table and columns would facilitate in having a easy pagination of your content.
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 66154
146
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Neerajjavafreak jain wrote:now will you please resolve my pagination problem

What more information do you need to get started that is missing from the information that Ulf has already given you? I suggest that you start designing your approach and post with any specific questions that you might have. The information in Ulf's links should get you started on the right track.
 
Neeraj jain
Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i have already started my application and i am attaching it i just want to fetch the records from the database and and show 5 recordss per page so at last i am stucked at this 5 records per page concept so this is why asking it.......
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 66154
146
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Bear Bibeault wrote:
What more information do you need to get started that is missing from the information that Ulf has already given you?
 
Neeraj jain
Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i am getting an ExhaustedResultSet Exception.........
 
Ulf Dittmer
Rancher
Posts: 42972
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Without seeing the code that causes the exception there isn't much we can speculate on.
 
Neeraj jain
Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
actually this forum blocking me from posting the rar file
 
Neeraj jain
Ranch Hand
Posts: 108
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator




this above is index.jsp

now the below is submit.jsp



HOPE this is sufficient
 
Ulf Dittmer
Rancher
Posts: 42972
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No, it's not. Where does the exception occur - in which line of code? What are the values of the relevant variables?

At a quick glance, the code has numerous problems, like using scriptlets in JSPs, being wide open to SQL injection attacks and using variables that have not been assigned to ("table"). I still advise the use of a library like DisplayTag; getting that to work is likely less work than to get from the current code to a properly working solution.
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!