sql 分页查询

	public List<Student> findAllStudent(int page){
		List<Student>list = new ArrayList<>();
		     
		    try {
		        Class.forName("com.mysql.jdbc.Driver");
		    } catch (ClassNotFoundException e1) {
		        e1.printStackTrace();
		    }
		     
		    try (Connection connection = DriverManager.getConnection(url, user, pass)) {
		        int size =2;
		         
		        String sql = "SELECT * FROM student order by id asc limit ?,?";
		        java.sql.PreparedStatement statement = connection.prepareStatement(sql);
		 
		        int p = (page-1)*size;//分页id算法,用于计算开始id
		         
		        statement.setInt(1, p);
		        statement.setInt(2,size);
		 
		    } catch (SQLException e) {
		        e.printStackTrace();
		    }
		    return list;
	}