mybaits + plus
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.2.0</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.1</version>
</dependency>
最佳实践方式,一个人写代码要锤子 service 接口,直接用实现。 QueryWrapper 也非常好用建议使用。
TestBean
@Data
@TableName("test")
public class TestBean{
@TableId("id")
private String id;
@TableField("name")
private String name;
@TableField("brithday")
private String brithday;
@TableField("home_address")
private String homeAddress;
}
Mapper
public interface TestMapperextends BaseMapper<TestBean> {
}
Service 分页。
public class TestService extends ServiceImpl<TestMapper,TestBean> implements IService<ExamGroups> {
@Override
public IPage<TestBean> getExamGroupList(MyPage p) {
Page<TestBean> page = MyUtil.copyPropertiesIgnoreCase(p,Page.class);
QueryWrapper<TestBean> queryWrapper = new QueryWrapper<>();
queryWrapper.orderByDesc("id","DCJSJ");
IPage<TestBean> pageData = page(page, queryWrapper);
return pageData;
}
}
page
@Data
public class MyPage {
//当前页数
int current = 1;
// 每页几条数据
int size = 10;
//搜索关键字
String searchKey;
}