public class Fruit {

    public String getIds() {

        return ids;

    }

    public void setIds(String ids) {

        this.ids = ids;

    }

    public String getName() {

        return name;

    }

    public void setName(String name) {

        this.name = name;

    }

    public double getPrice() {

        return price;

    }

    public void setPrice(double price) {

        this.price = price;

    }

    public String getSource() {

        return source;

    }

    public void setSource(String source) {

        this.source = source;

    }

    public int getNumbers() {

        return numbers;

    }

    public void setNumbers(int numbers) {

        this.numbers = numbers;

    }

    public String getImage() {

        return image;

    }

    public void setImage(String image) {

        this.image = image;

    }

    private String ids;

    private String name;

    private double price;

    private String source;

    private int numbers;

    private String image;

}

import java.sql.*;

import java.util.*;

public class DBConnection {

    private static String drv="com.mysql.jdbc.Driver";

    private static String url="jdbc:mysql://127.0.0.1:3306/mydb?characterEncoding=GBK";

    private static String uid="root";

    private static String pwd="";

    public static Connection getConnection() throws Exception{

        Class.forName(drv);

        Connection conn = DriverManager.getConnection(url,uid,pwd);

        return conn;

    }

}

import java.util.*;

import java.sql.*;

public class FruitDao {

    private Connection conn;

    private PreparedStatement stat;

    private ResultSet rs;

    public FruitDao() throws Exception{

        conn = DBConnection.getConnection();

    }

    //返回总页数

    public int getPageCount(int pageSize) throws Exception{

        int pageCount = 0;

        //求总行数    rowCount

        String sql = "select count(*) from fruit";

        stat = conn.prepareStatement(sql);

        rs = stat.executeQuery();

        rs.next();

        int rowCount = rs.getInt(1);

        //求总页数    pageCount = (rowCount/pageSize)--进位

        pageCount = (int)Math.ceil( 1.0*rowCount/pageSize);

        conn.close();

        return pageCount;

    }

    //返回指定页的数据

    public ArrayList<Fruit> select(int pageSize,int pageNo) throws Exception{

        ArrayList<Fruit> list = new ArrayList<Fruit>();

        String sql = "select * from fruit limit ?,?";    //select TOP 2 * from Fruit where Ids NOT IN (SELECT TOP 4 Ids from fruit)   这是sqlserver的分页语句

        stat = conn.prepareStatement(sql);

        stat.setInt(1, (pageNo-1)*pageSize);

        stat.setInt(2, pageSize);

        rs = stat.executeQuery();

        while(rs.next()){

            Fruit data = new Fruit();

            data.setIds(rs.getString(1));

            data.setName(rs.getString(2));

            data.setPrice(rs.getDouble(3));

            data.setSource(rs.getString(4));

            data.setNumbers(rs.getInt(5));

            data.setImage(rs.getString(6));

            list.add(data);

        }

        conn.close();

        return list;

    }

    //增删改查的方法....略

}

import java.awt.print.Pageable;

import java.util.*;

public class Test {

    private static final int PAGESIZE=2;

    public static void main(String[] args) throws Exception {

        int pageCount = new FruitDao().getPageCount(PAGESIZE);

        System.out.println("一共"+pageCount+"页,每页"+PAGESIZE+"个");

        ArrayList<Fruit> list = new FruitDao().select(PAGESIZE, 1);

        for(int i=0;i<list.size();i++){

            System.out.println(list.get(i).getIds()+" "+list.get(i).getName()+list.get(i).getPrice()+list.get(i).getSource());

        }

    }

}

一共4页，每页2个

k001 苹果 2.4 烟台

k002    菠萝    1.4    广东