- 浏览器打开 http://start.spring.io/
创建一个空的springboot项目，添加web，mysql依赖
image
导入项目到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
