jdbc分页查询limit问题

jdbc分页查询limit问题

• 重点

int currentPage = page; // 当前页码
int pageSize = limit; // 每页显示的记录数
int offset = (currentPage - 1) * pageSize; // 查询结果的偏移量

• 案例

  @Override
    public List<User> pageByLikeName(Integer page, Integer limit, String name) throws SQLException {
        int currentPage = page; // 当前页码
        int pageSize = limit; // 每页显示的记录数
        int offset = (currentPage - 1) * pageSize; // 查询结果的偏移量

        ResultSet resultSet = null;
        if (name == null) {
            resultSet = JdbcUtils.executeQuery("select * from user limit ?,?", offset, pageSize);
        } else {
            name = "%" + name + "%";
            resultSet = JdbcUtils.executeQuery("select * from user where username like ? limit ?,?", name, offset, pageSize);
        }
        List<User> userList = new ArrayList<>();
        while (resultSet.next()) {
            User user = new User(resultSet.getInt("id"), resultSet.getString("username"), resultSet.getString("password"), resultSet.getString("nickname"), resultSet.getString("phone"), resultSet.getInt("identity"));
            userList.add(user);
        }
        return userList;
    }