wood burning stoves 2.0*
The moose likes JDBC and the fly likes paging with mysql and java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "paging with mysql and java" Watch "paging with mysql and java" New topic

paging with mysql and java

Jitto P.Jose

Joined: Sep 18, 2007
Posts: 27
hello friends,
i am looking for a database paging for my application. i am using mysql. after some search, i found that there is two queries that would help to get total no of records and also paged data...what i found is given below
mysql> SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name WHERE {condition} LIMIT 10, 10;

but am very new to database concepts. so i dont know how to use these 2 queries together in a function.
if anybody know about the query execute method, please give me code snippet ... i just need the query and how these 2 queries are used in same function. i am not using any stored procedures.
thank you

Get updated with the world http://hallowdemon.ismywebsite.com
jQuery in Action, 2nd edition
subject: paging with mysql and java
Similar Threads
Solving for Page With Slow Response Time
Want clarification for some of the methods of Criteria class of org.hibernate
select values that do not have state = x
How to do Paging in struts
How can I paging use mysql'seek function?