sql分页查询

package day01.demo2;

import util.DBUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;


public class PageNumDemo {
    public static void main(String[] args) {
        Connection con = DBUtil.getConnection();
        ResultSet rs = null;
        PreparedStatement ps =null;
        //返回总行数
        Scanner s1 = new Scanner(System.in);
        try {
        String sql1="select count(*) as num from emp;";
        int singPageNum = 3;
            //拿到总记录数
            ps = con.prepareStatement(sql1);
            rs = ps.executeQuery();
            int sunPage = 0;
            //sunPage=总记录数
            if(rs.next()){
                sunPage = rs.getInt("num");
            }
            //求出展示的总页数
            int sumPageAll = sunPage % singPageNum == 0 ?sunPage/singPageNum:sunPage/singPageNum+1;
            int i=0;
            String sql2 = "select * from emp limit ?,3;";
            while(sumPageAll != i){
                ps = con.prepareStatement(sql2);
                ps.setInt(1, i*singPageNum);
                rs = ps.executeQuery();
                while(rs.next()){
                    System.out.println("员工编号："+rs.getInt("empno")+",员工姓名："+rs.getString("ename"));
                }
                System.out.println("当前页数:"+(i+1));
                i++;
                System.out.println("是否继续翻看下一页|| y/n");
                String input=s1.next();
                if(input.equals("y")){
                }
                else if(input.equals("n")){
                    break;
                }
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }


    }
}