JDBC分页查询(源码)

package jdbcwork;

import java.sql.*;
import java.util.Scanner;

//排版:ctrl+alt+l
//alt+enter
public class PageDemo {
    public static void main(String[] args) {
        Connection connection=null;
        PreparedStatement preparedStatement=null;
        ResultSet set=null;

        try {
            Class.forName("com.mysql.jdbc.Driver");
            try {
                String url = "jdbc:mysql://127.0.0.1:3306/scor?characterEncoding=utf-8&useSSL=false";
                String user = "root";
                String password = "12345";
                connection= DriverManager.getConnection(url,user,password);
                String sql="select *from users limit ? ,?";
                preparedStatement=connection.prepareStatement(sql);
                System.out.println("请用户输入每页记录数");
                int offSet=new Scanner(System.in).nextInt();
                System.out.println("请用户输入要查询的页数");
                int pageNumber=new Scanner(System.in).nextInt();

                preparedStatement.setInt(1,(pageNumber-1)*offSet);
                preparedStatement.setInt (2,offSet);

                set=preparedStatement.executeQuery();
                System.out.println("uid\tusername\tpwd\t\t\tage\tgender\tphoneNumber\t");
                while(set.next())
                {

                    String uid=set.getString(1);
                   // System.out.print(uid+"\t");
                    String username=set.getString(2);
                    //System.out.print(username+"\t");
                    String pwd=set.getString(3);
                   // System.out.print(pwd+"\t");
                    String age=set.getString(4);
                   // System.out.print(age+"\t");
                    String gender=set.getString(5);
                   // System.out.print(gender+"\t");
                    String phoneNumber=set.getString(6);
                   // System.out.println(phoneNumber);
                             System.out.println(uid+"\t"+username+"\t\t"+pwd+"\t\t\t"+age+"\t\t"+gender+"\t"+phoneNumber+"\t");
                    //System.out.println("存在shuju");
                }

            } catch (SQLException e) {
                e.printStackTrace();
            }

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }


    }