Select * from User limit 10,10; //第一个10是偏移量(从第11条来看),第二个10是显示每页10个数据。
package JDBC;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Arrays;
import java.util.Scanner;
/*
* 分页
*/
public class Demo15 {
public static void main(String[] args) {
Scanner scan = new Scanner(System.in);
System.out.println("请输入要查看的页数:");
int page = scan.nextInt();
System.out.println("请输入一页显示的条数:");
int pageSize = scan.nextInt();
Connection conn = null;
try {
conn = DBUtil3.getConnection();
String sql = "select * from user limit ?,?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1, (page-1)*pageSize); //偏移量
ps.setInt(2, pageSize); //每页的条数
ResultSet rs = ps.executeQuery();
while(rs.next()) {