Hi all, I know this is a frequently asked question. But I would like to know if I can find sample code for Previous, Next display of records from the database. In this Architecture I cannot use the pagination taglibs. I have to do everyhting in servlets. Can anyone give me links or a sample code.
But in Oracle LIMIT keyword is used only for BULK fetch or bulk inserts. WHat my idea was to fetch the entire resultset into a ArrayList and Loop through. It would be very helpful if I could get a sample code for this.
Yes but in oracle you can use ROWNUM field in your condition. Suppose if you have a million record inside your table then fetching all would be time consuming and may result in a bottleneck. Wouldn't it better to fetch a small no of record which you really want to show in your first page. Try to use ROWNUM.