當(dāng)前位置:
首頁(yè) >
前端技术
> javascript
>内容正文
javascript
SpringBoot整合MyBatis-Plus分页查询
生活随笔
收集整理的這篇文章主要介紹了
SpringBoot整合MyBatis-Plus分页查询
小編覺(jué)得挺不錯(cuò)的,現(xiàn)在分享給大家,幫大家做個(gè)參考.
在整合mybatis-plus時(shí)可以先參考官網(wǎng):快速開(kāi)始
一、引入依賴(lài)
<dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><version>3.4.3</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><scope>runtime</scope></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><version>1.18.16</version><scope>provided</scope></dependency>二、yml文件配置
spring.datasource.url=jdbc:mysql://localhost/chapter01?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC spring.datasource.username=root spring.datasource.password=root spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver?三、創(chuàng)建實(shí)體類(lèi)
@Data public class SysUser {private int id;private String username;private String password; }四、分頁(yè)插件配置
@Configuration public class MyBatisConfig {@Beanpublic MybatisPlusInterceptor mybatisPlusInterceptor() {MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));return interceptor;} }五、應(yīng)用實(shí)例
QueryWrapper<SysUser> queryWrapper = new QueryWrapper<>();Page<SysUser> page = new Page();page.setCurrent(2);page.setSize(10);Page<SysUser> page1 = sysUserMapper.selectPage(page, queryWrapper);List<SysUser> records = page1.getRecords();System.out.println(records);詳細(xì)代碼請(qǐng)看:springboot整合mybatis-plus分頁(yè)
總結(jié)
以上是生活随笔為你收集整理的SpringBoot整合MyBatis-Plus分页查询的全部?jī)?nèi)容,希望文章能夠幫你解決所遇到的問(wèn)題。
- 上一篇: SpringBatch处理器Script
- 下一篇: 如何通过递归找父节点或子节点详解