转载

三分钟搞定springboot+mybatis分页

  • 浏览器打开 http://start.spring.io/

创建一个空的springboot项目,添加web,mysql依赖

三分钟搞定springboot+mybatis分页

  • 导入项目到IDE

  • pom.xml中添加依赖

<dependency>
    <groupId>net.oschina.durcframework</groupId>
    <artifactId>fastmybatis-spring-boot-starter</artifactId>
    <version>1.0.3</version>
</dependency>
  • application.properties中配置数据库连接
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/stu?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull
spring.datasource.username=root
spring.datasource.password=root
  • 添加实体类,Mapper
// 实体类
@Table(name = "t_user")
public class TUser {
    @Id
    @Column(name = "id")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    /** ID, 数据库字段:id */
    private Integer id;

    /** 用户名, 数据库字段:username */
    private String username;

    /** 状态, 数据库字段:state */
    private Byte state;

    /** 是否删除, 数据库字段:isdel */
    @com.gitee.fastmybatis.core.annotation.LogicDelete
    private Boolean isdel;

    /** 备注, 数据库字段:remark */
    private String remark;

    /** 添加时间, 数据库字段:add_time */
    private Date addTime;

    /** 金额, 数据库字段:money */
    private BigDecimal money;

    /** 剩下的钱, 数据库字段:left_money */
    private Float leftMoney;
    // 省略get set
}

// Mapper
public interface TUserMapper extends CrudMapper<TUser, Integer> {

}
  • 新建Controller
@RestController
public class TUserController {

    @Autowired
    private TUserMapper tUserMapper;

    @GetMapping("/")
    public Object home(@RequestParam(defaultValue = "1") int pageIndex, @RequestParam(defaultValue = "10")int pageSize) {
        Query query = new Query().page(pageIndex, pageSize);
        PageInfo<TUser> pageInfo = MapperUtil.query(this.tUserMapper, query);
        return pageInfo;
    }

}
  • 启动项目,浏览器输入 http://localhost:8080/?pageIndex=2

返回结果:

{
    "list": [
        {
            "id": 13,
            "username": "username1",
            "state": 0,
            "isdel": false,
            "remark": "remark1",
            "addTime": "2018-06-20T02:59:40.000+0000",
            "money": 1,
            "leftMoney": 200
        }
    ],
    "total": 11,
    "start": 10,
    "pageIndex": 2,
    "pageSize": 10,
    "pageCount": 2,
    "currentPageIndex": 2,
    "firstPageIndex": 1,
    "prePageIndex": 1,
    "lastPageIndex": 2,
    "nextPageIndex": 2
}

demo地址: https://gitee.com/durcframework/dev-codes/tree/master/demo-web

更多参考

原文  https://blog.csdn.net/thc1987/article/details/80834664
正文到此结束
Loading...