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(); } } }
JDBC分页查询(源码)
最新推荐文章于 2024-05-10 09:54:33 发布