三分钟搞定springboot+mybatis分页

本文主要是介绍三分钟搞定springboot+mybatis分页，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

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

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

导入项目到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.LogicDeleteprivate 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 {@Autowiredprivate 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
}