通用mapper已经帮我们写好了常用的curd功能,我们只要继承它就可以直接调用,大大节约开发的时间,提高开发效率,pageHelper是一款好用的分页插件,只需简单的几行代码就可以实现数据的分页查询,下面介绍他们的使用方法
1、创建springboot项目
2、依赖
dency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper-spring-boot-starter</artifactId>
<version>2.0.2</version>
</dependency>
<!-- 分页插件
文档地址:https://github.com/pagehelper/Mybatis-PageHelper/blob/master/wikis/zh/HowToUse.md -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
3、启动类注解,注意MapperScan要使用tk的MapperScan
package com.llg.mybatis;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import tk.mybatis.spring.annotation.MapperScan;
@SpringBootApplication
@MapperScan("com.llg.mybatis.dao")
public class MybatisApplication {
public static void main(String[] args) {
SpringApplication.run(MybatisApplication.class, args);
}
}
4、mapper接口继承BaseMapper,就可以使用baseMapper的方法了
package com.llg.mybatis.dao;
import com.llg.mybatis.entity.Users;
import tk.mybatis.mapper.common.BaseMapper;
public interface UserMapper extends BaseMapper<Users>{
}
5、
package com.llg.mybatis.service;
import com.llg.mybatis.dao.UserMapper;
import com.llg.mybatis.entity.Users;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class UserService {
@Autowired
UserMapper userMapper;
public void addUser(Users u) {
userMapper.insertSelective(u);
}
}
6、使用pegeHelper
public PageInfo<Users> listUser(){
PageHelper.startPage(1, 10).setOrderBy("id desc");
final PageInfo<Users> userPageInfo = new PageInfo<>(this.userMapper.selectAll());
return userPageInfo;
}