1 引入pom

<dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot</artifactId><version>2.7.14</version>
</dependency>
<dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><version>3.5.3.2</version>
</dependency>
<dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.29</version>
</dependency>

2 編寫配置類MybatisPlusConfig

@Configuration
public class MybatisPlusConfig {/*** 分頁插件*/@Beanpublic MybatisPlusInterceptor mybatisPlusInterceptor() {MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));return interceptor;}
}

3 業務實現

3.1 Controller層

    @AutowiredIComponentService componentService;@ApiOperation(value = "查詢基礎組件列表", notes = "根據條件查詢基礎組件列表")@GetMapping("/list")public ResponseMessage<IPage<Component>> queryList(@RequestBody QueryEntity<ComponentDTO> queryEntity){IPage<Component> page = new Page<>(queryEntity.getPageNum(), queryEntity.getPageSize());LambdaQueryWrapper<Component> query = new LambdaQueryWrapper<>();
//        query.eq(Component::getType, queryEntity.getQuery().getType());return ResponseMessage.success("查詢成功",componentService.queryList(page,query));}

3.2 service層

IPage<Component> queryList(IPage<Component> page, LambdaQueryWrapper<Component> queryWrapper);

3.3 service實現層

	@Overridepublic IPage<Component> queryList(IPage<Component> page, LambdaQueryWrapper<Component> queryWrapper) {return componentMapper.selectPage(page,queryWrapper);}

3.4 dao層

@Mapper
public interface ComponentMapper extends BaseMapper<Component> {}

4 yaml配置

server:#運行端口號port: 8090servlet:context-path: /homspring:
#  mvc:
#    pathmatch:
#      matching-strategy: ANT_PATH_MATCHER#數據源配置datasource:driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/hom?useUnicode=true&useSSL=false&characterEncoding=utf8&serverTimezone=Asia/Shanghaiusername: rootpassword: marlon#mybatis-plus配置
mybatis-plus:configuration:#sql日志打印log-impl: org.apache.ibatis.logging.stdout.StdOutImpl#開啟駝峰命名匹配map-underscore-to-camel-case: true#mapper文件mapper-locations: classpath:mapper/**/*.xml,classpath:mapper/*.xml#數據庫實體類的包全路徑，方便在mapper.xml中不許使用實體類的全路徑，寫類名就行（不區分大小寫）type-aliases-package: cn.com.marlon.hom.entityglobal-config:db-config:#邏輯刪除logic-delete-value: 0logic-not-delete-value: 1logic-delete-field: deleted

5 postman測試