how to access previous page in a database

Hi,

I am using struts now and MySQL as my database.

the problem is, I dont know how will I show the first page up to the last page of my database, using previous and next. My database consists of employees details, I want to show 10 rows of employees per page.

[280 byte] By [ladyCrofta] at [2007-11-27 11:10:15]
# 1

The magic word here is "paging".

Google on that together with the keywords "struts" and "mysql", then you will get enough answers.

http://www.google.com/search?q=paging+struts+mysql

BalusCa at 2007-7-29 13:40:32 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 2

Hi,,

http://forum.java.sun.com/thread.jspa?threadID=5194183

i hope it will help you

drvijayy2k2a at 2007-7-29 13:40:32 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 3

Thanks! I'll try to view that page.

ladyCrofta at 2007-7-29 13:40:32 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 4

Thanks! I'll try to view that page.

ladyCrofta at 2007-7-29 13:40:32 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 5

Maintain the beginRow and endRow concept..

use query the data from beginCounter numbet to EndCounter

I have used the same logic using JSTL <sql> tag

i have also maintain the paging

MiracleShivaa at 2007-7-29 13:40:32 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...