Spring Data Jpa条件分页查询（简单查询）

实体类

对应数据库

// An highlighted block
	package com.example.test2.entity;


import javax.persistence.*;
import java.io.Serializable;
import java.util.Date;

/**
 * @author admin
 */
@Entity
@Table(name = "users")
public class Users implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "user_id")
    private Integer userId;

    @Column(name = "username")
    private String username;

    @Column(name = "password")
    private String password;

    @Column(name = "create_time")
    private Date createTime;

    @Override
    public String toString() {
        return "Users{" +
                "userId=" + userId +
                ", username='" + username + '\'' +
                ", password=" + password +
                '}';
    }

    public Date getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    public Integer getUserId() {
        return userId;
    }

    public void setUserId(Integer userId) {
        this.userId = userId;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

dao

@Repository
public interface UsersDao extends JpaRepository<Users, Integer> {

    Page<Users> findAllByUsername(String username, Pageable var1);

}

Controller接口

package com.example.test2.controller;

import com.example.test2.config.tool.Result;
import com.example.test2.dao.UsersDao;
import com.example.test2.entity.Users;
import org.springframework.data.domain.PageRequest;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import java.util.Date;

@RestController
public class UserController {

    @Resource
    UsersDao usersDao;

    @GetMapping("/getUserInfo")
    public Result getUserInfo(Integer page, Integer size) {
        return Result.success(usersDao.findAll(PageRequest.of(page, size)));
    }

    @GetMapping("/getUserInfoByUsername")
    public Result getUserInfoByUsername(String username, Integer page, Integer size) {
        return Result.success(usersDao.findAllByUsername(username, PageRequest.of(page, size)));
    }
}

测试结果

[1]: http://meta.math.stackexchange.com/questions/5020/mathjax-basic-tutorial-and-quick-reference
[2]: https://mermaidjs.github.io/
[3]: https://mermaidjs.github.io/
[4]: http://adrai.github.io/flowchart.js/