hi Someone can give me some examples code of how to add to my database result page the option of paging the results, I mean to put the next, previous navigation options. My database is a postgres. thanks
juan If you dont use EJBs you could also add the data from the DB to a list of custome objects and store it in the session. then the links on the page will include params that will indicate the current index and weather it's "next" or "back" which according to you will either add or take the number_per_page (your variable in the servlet/jsp) to/from the index. you just need to watch yourself with the rules for "back" and "next" so that you dont actualy try to get items from the list with wrong index (like -n or more then the list actually has). Of course if you work with ejbs forget about this one.
Shai koren<br />SCJP2 <br />SCEA (well yea only part 1 so far)
I disagree with putting search results on the session, but I disagree with putting anything on the session, in general The best answer to your question is "it depends on the context". This topic turns up very often and there is some very good material available in this and other forums and I'm not going to try to reproduce it here (I'm bound to get it wrong). If you search the Servlet, JSP and JDBC forums you will find some excellent discussions. Dave.
subject: how to paging database results in different html pages