-
导入依赖
<dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.3.0</version> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.2.0</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency>
-
配置文件
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.url=jdbc:mysql://127.0.0.1:3306/mytest?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC&useSSL=false spring.datasource.username=root spring.datasource.password=root1234 pagehelper.helper-dialect=mysql pagehelper.reasonable=true pagehelper.support-methods-arguments=true
-
dao层
@Mapper public interface TestDao { @Select("select * from myuser") List<Map<String,Object>> selects(); }
-
使用
@RestController public class TestController { @Autowired private TestDao testDao; @GetMapping(path = "/test") public Object test(){ //第一个参数是页数,第二个为显示数 PageHelper.startPage(1, 1); return testDao.selects(); } }
SpringBoot使用Mybatis插件pagehelper
最新推荐文章于 2024-05-28 20:33:00 发布