java数据库分页查询语句怎么写_数据库分页

[java]代码库package mysql4;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class TestPage {

private static Connection con = null;

private static PreparedStatement pre=null;

private static ResultSet result=null;

public static void main(String[] args) {

//1.加载数据库驱动

try {

Class.forName("com.mysql.jdbc.Driver");

} catch (ClassNotFoundException e) {

System.out.println("加载失败！");

e.printStackTrace();

}

System.out.println("加载成功！");

//2.连接数据库

try {

con=DriverManager.getConnection("jdbc:mysql://localhost:3306/db_library", "root", "123");

} catch (SQLException e) {

System.out.println("连接数据库失败！");

e.printStackTrace();

}

System.out.println("成功连接数据库！");

/*MySQL分页语句

* select * from person limit M,N

* M表示从第M条数据开始，取N条记录

*/

try {

//page是第几页，pagecount是每页显示多少条记录

int page=3;

int pagecount=10;

pre=con.prepareStatement("select * from person limit ?,?");

pre.setInt(1, (page-1)*10);

pre.setInt(2, pagecount);

result=pre.executeQuery();

while(result.next()){

System.out.println(result.getInt("id"));

System.out.println(result.getString("name"));

System.out.println(result.getInt("age"));

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

//4.释放数据库的资源

finally{

try {

if(result!=null)

result.close();

if(pre!=null)

pre.close();

if(con!=null)

con.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

System.out.println("执行成功！");

}

}