how to make query first,last next,previous on table to rtetriveb data.

Hi, Can anyone help me how to retrieve data from table in the following manner. In my application I have five button namely First,last,next,previous,and Query. When I will press the query button, it should show me last data that I had feed to the table. When I press first button it should show first entry that I had entered to the table .likewise for the last button. Now after pressing query button, when I press the previous button it should show me data that I had entered through the table before the last entry. Like wise. Here I am retrieving data from two tables where we have entry no as a common field between them. Also each table have unique serial no as break no. field.

And my second query is about the connection pooling. How the connection pooling is achieved throughout the application. In my current application, I have nearly 150 servlet where I have to make separate connection for each servlet to work with database. Is it possible to make connection with database in only login servlet and such connection object can I use in remaining servlet so my application becomes more reliable and speedy. Please help me on this issue as I am looking the same from long time. Kindly help me on above issue. Any suggestion is highly appreciated. Thanks Harshal

Harshal, 1) SQL has a "union" keyword that you can use to include two tables in your query. This lets it look like one table from the point of view of paging.

2) Creating a connection in the servlet and leaving it open for a long time is not a good practice. It would be better to use an actual connection pool. Many databases come with a pooling driver you can use on your app server. Otherwise, you can use the Apache DBCP library.

Hi Jeanne Boyarsky , thanks for your reply. my query is how to retrive first,last row data from table. in my form, once i click on first data it should show data that i had entered before. so once i get last or first entered the data i can use other button like orevious,next buttton. is there any query to retrieve first or last data from table? any suggestion is highly appreciated. thansk and regards harshal