一、前言MyBatis-Plus 是一个 Mybatis 增强版工具在 MyBatis 上扩充了其他功能没有改变其基本功能为了简化开发提交效率而存在。二、整合MybatisPlus新建一个Spring Boot项目2.1 引入依赖dependency groupIdorg.freemarker/groupId artifactIdfreemarker/artifactId /dependency dependency groupIdcom.baomidou/groupId artifactIdmybatis-plus-boot-starter/artifactId version3.4.0/version /dependency dependency groupIdcom.baomidou/groupId artifactIdmybatis-plus-generator/artifactId version3.4.0/version /dependency dependency groupIdcom.alibaba/groupId artifactIddruid-spring-boot-starter/artifactId version1.1.22/version /dependency dependency groupIdmysql/groupId artifactIdmysql-connector-java/artifactId /dependency dependency groupIdorg.apache.commons/groupId artifactIdcommons-lang3/artifactId version3.11/version /dependency2.2 application.ymlspring:datasource:druid:# 数据库访问配置, 使用druid数据源type:com.alibaba.druid.pool.DruidDataSourcedriver-class-name:com.mysql.cj.jdbc.Driverurl:jdbc:mysql://127.0.0.1:3306/springboot?useUnicodetruecharacterEncodingutf8serverTimezoneUTCallowMultiQueriestrueuseSSLfalseusername:springpassword:spring#123# 连接池配置initial-size:5min-idle:5max-active:20# 连接等待超时时间max-wait:30000# 配置检测可以关闭的空闲连接间隔时间time-between-eviction-runs-millis:60000# 配置连接在池中的最小生存时间min-evictable-idle-time-millis:300000validation-query:select 1 from dualtest-while-idle:truetest-on-borrow:falsetest-on-return:false# 打开PSCache并且指定每个连接上PSCache的大小pool-prepared-statements:truemax-open-prepared-statements:20max-pool-prepared-statement-per-connection-size:20# 配置监控统计拦截的filters, 去掉后监控界面sql无法统计, wall用于防火墙filters:stat,wall# Spring监控AOP切入点如x.y.z.service.*,配置多个英文逗号分隔aop-patterns:com.wno704.boot.servie.*# WebStatFilter配置web-stat-filter:enabled:true# 添加过滤规则url-pattern:/*# 忽略过滤的格式exclusions:*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*# StatViewServlet配置stat-view-servlet:enabled:true# 访问路径为/druid时跳转到StatViewServleturl-pattern:/druid/*# 是否能够重置数据reset-enable:false# 需要账号密码才能访问控制台login-username:druidlogin-password:druid123# IP白名单# allow: 127.0.0.1# IP黑名单共同存在时deny优先于allow# deny: 192.168.1.218# 配置StatFilterfilter:stat:log-slow-sql:truemybatis-plus:configuration:map-underscore-to-camel-case:trueauto-mapping-behavior:fulllog-impl:org.apache.ibatis.logging.stdout.StdOutImplmapper-locations:classpath:mapper/*Mapper.xmlglobal-config:# 逻辑删除配置db-config:# 删除前logic-not-delete-value:1# 删除后logic-delete-value:02.3 分页插件配置创建MybatisPlusConfig.javaConfigurationMapperScan(com.wno704.boot.mapper)publicclassMybatisPlusConfig{/** * 新的分页插件,一缓和二缓遵循mybatis的规则,需要设置 MybatisConfiguration#useDeprecatedExecutor false 避免缓存出现问题(该属性会在旧插件移除后一同移除) */BeanpublicMybatisPlusInterceptormybatisPlusInterceptor(){MybatisPlusInterceptorinterceptornewMybatisPlusInterceptor();interceptor.addInnerInterceptor(newPaginationInnerInterceptor(DbType.MYSQL));returninterceptor;}BeanpublicConfigurationCustomizerconfigurationCustomizer(){returnconfiguration-configuration.setUseDeprecatedExecutor(false);}}2.4 自动生成代码创建GeneratorCodeConfig.javapublicclassGeneratorCodeConfig{publicstaticStringscanner(Stringtip){ScannerscannernewScanner(System.in);StringBuilderhelpnewStringBuilder();help.append(请输入tip);System.out.println(help.toString());if(scanner.hasNext()){Stringiptscanner.next();if(StringUtils.isNotEmpty(ipt)){returnipt;}}thrownewMybatisPlusException(请输入正确的tip);}publicstaticvoidmain(String[]args){// 代码生成器AutoGeneratormpgnewAutoGenerator();// 全局配置GlobalConfiggcnewGlobalConfig();StringprojectPathSystem.getProperty(user.dir);projectPathE:\\workspace\\workspace(idea)\\spring\\boot\\24springboot-mybatisplus;gc.setOutputDir(projectPath/src/main/java);gc.setAuthor(wno704);gc.setOpen(false);//实体属性 Swagger2 注解gc.setSwagger2(false);mpg.setGlobalConfig(gc);// 数据源配置DataSourceConfigdscnewDataSourceConfig();dsc.setUrl(jdbc:mysql://127.0.0.1:3306/springboot?useUnicodetruecharacterEncodingutf8serverTimezoneUTCallowPublicKeyRetrievaltrueallowMultiQueriestrueuseSSLfalse);dsc.setDriverName(com.mysql.cj.jdbc.Driver);dsc.setUsername(spring);dsc.setPassword(spring#123);mpg.setDataSource(dsc);// 包配置PackageConfigpcnewPackageConfig();//pc.setModuleName(scanner(模块名));pc.setParent(com.wno704.boot);pc.setEntity(model);//entitypc.setMapper(mapper);pc.setService(service);pc.setServiceImpl(service.impl);mpg.setPackageInfo(pc);// 配置模板TemplateConfigtemplateConfignewTemplateConfig();templateConfig.setXml(null);mpg.setTemplate(templateConfig);// 策略配置StrategyConfigstrategynewStrategyConfig();strategy.setNaming(NamingStrategy.underline_to_camel);strategy.setColumnNaming(NamingStrategy.underline_to_camel);strategy.setSuperEntityClass(com.baomidou.mybatisplus.extension.activerecord.Model);strategy.setEntityLombokModel(true);strategy.setRestControllerStyle(true);strategy.setEntityLombokModel(true);strategy.setInclude(scanner(表名多个英文逗号分割).split(,));strategy.setControllerMappingHyphenStyle(true);strategy.setTablePrefix(pc.getModuleName()_);mpg.setStrategy(strategy);mpg.setTemplateEngine(newFreemarkerTemplateEngine());mpg.execute();}}2.5 数据准备这里我们使用以前的测试数据这里以sys_log表做测试2.6 测试运行GeneratorCodeConfig.java输入sys_log生产代码如下我们编写控制代码调用Autowired private ISysLogService iSysLogService; RequestMapping( value /getLog, method RequestMethod.GET) public SysLog getLog(){ return iSysLogService.getById(1); }启动项目浏览器访问 http://localhost:8080/sys-log/getLog三、自定义sql3.1 定义Mapper.xml在resources目录下新建mapper文件夹新建SysLogMapper.xml文件?xml version1.0 encodingUTF-8?!DOCTYPEmapperPUBLIC-//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtdmappernamespacecom.wno704.boot.mapper.SysLogMapper!-- 查找所有信息 --selectidfindAllSysLogresultTypecom.wno704.boot.model.SysLogselect * from sys_log/select/mapper3.2 代码改造在SysLogMapper.java新增findAllSysLog()代码如下publicinterfaceSysLogMapperextendsBaseMapperSysLog{publicListSysLogfindAllSysLog();}在ISysLogService.java新增findAllSysLog()代码如下publicinterfaceISysLogServiceextendsIServiceSysLog{publicListSysLogfindAllSysLog();}在SysLogServiceImpl.java新增findAllSysLog()代码如下ServicepublicclassSysLogServiceImplextendsServiceImplSysLogMapper,SysLogimplementsISysLogService{AutowiredprivateSysLogMappersysLogMapper;OverridepublicListSysLogfindAllSysLog(){returnsysLogMapper.findAllSysLog();}}在SysLogController.java新增getAllLog()代码如下RestControllerRequestMapping(/sys-log)publicclassSysLogController{AutowiredprivateISysLogServiceiSysLogService;RequestMapping(value/getLog,methodRequestMethod.GET)publicSysLoggetLog(){returniSysLogService.getById(1);}RequestMapping(value/getAllLog,methodRequestMethod.GET)publicListSysLoggetAllLog(){returniSysLogService.findAllSysLog();}}3.3 测试启动项目浏览器访问http://localhost:8080/sys-log/getAllLog控制台显示如下mybatis-plus3.3之前的版本参考https://www.cnblogs.com/liuyj-top/p/12976396.html四、分页查询4.1 代码改造在ISysLogService.java新增findSysLogByPage()代码如下publicListSysLogfindSysLogByPage(Integercurrpage,Integerpagesize);在SysLogServiceImpl.java新增findSysLogByPage()代码如下OverridepublicListSysLogfindSysLogByPage(Integercurrpage,Integerpagesize){//分页查询需要配置分页插件PageSysLogpagenewPage(currpage,pagesize);IPageSysLogpagessysLogMapper.selectPage(page,null);System.out.println(总记录数:pages.getTotal());System.out.println(总页数pages.getSize());returnpages.getRecords();}在SysLogController.java新增getLogbyPage()代码如下GetMapping(getLogbyPage/{currpage}/{pagesize})publicListSysLoggetLogbyPage(PathVariableIntegercurrpage,PathVariableIntegerpagesize){returniSysLogService.findSysLogByPage(currpage,pagesize);}4.2 测试启动项目使用http请求测试如下五、模糊查询5.1 代码改造在ISysLogService.java新增findSysLogWithMethod()代码如下publicListSysLogfindSysLogWithMethod(Stringmethod);在SysLogServiceImpl.java新增findSysLogWithMethod()代码如下OverridepublicListSysLogfindSysLogWithMethod(Stringmethod){QueryWrapperSysLogwrappernewQueryWrapper();wrapper.like(method,method);wrapper.orderByDesc(true,create_time);returnsysLogMapper.selectList(wrapper);}在SysLogController.java新增getLogbyMethod()代码如下GetMapping(getLogbyMethod/{method})publicListSysLoggetLogbyMethod(PathVariableStringmethod){returniSysLogService.findSysLogWithMethod(method);}5.2 测试启动项目使用http请求测试如下更多条件构造器官方文档
一、前言MyBatis-Plus 是一个 Mybatis 增强版工具在 MyBatis 上扩充了其他功能没有改变其基本功能为了简化开发提交效率而存在。二、整合MybatisPlus新建一个Spring Boot项目2.1 引入依赖dependency groupIdorg.freemarker/groupId artifactIdfreemarker/artifactId /dependency dependency groupIdcom.baomidou/groupId artifactIdmybatis-plus-boot-starter/artifactId version3.4.0/version /dependency dependency groupIdcom.baomidou/groupId artifactIdmybatis-plus-generator/artifactId version3.4.0/version /dependency dependency groupIdcom.alibaba/groupId artifactIddruid-spring-boot-starter/artifactId version1.1.22/version /dependency dependency groupIdmysql/groupId artifactIdmysql-connector-java/artifactId /dependency dependency groupIdorg.apache.commons/groupId artifactIdcommons-lang3/artifactId version3.11/version /dependency2.2 application.ymlspring:datasource:druid:# 数据库访问配置, 使用druid数据源type:com.alibaba.druid.pool.DruidDataSourcedriver-class-name:com.mysql.cj.jdbc.Driverurl:jdbc:mysql://127.0.0.1:3306/springboot?useUnicodetruecharacterEncodingutf8serverTimezoneUTCallowMultiQueriestrueuseSSLfalseusername:springpassword:spring#123# 连接池配置initial-size:5min-idle:5max-active:20# 连接等待超时时间max-wait:30000# 配置检测可以关闭的空闲连接间隔时间time-between-eviction-runs-millis:60000# 配置连接在池中的最小生存时间min-evictable-idle-time-millis:300000validation-query:select 1 from dualtest-while-idle:truetest-on-borrow:falsetest-on-return:false# 打开PSCache并且指定每个连接上PSCache的大小pool-prepared-statements:truemax-open-prepared-statements:20max-pool-prepared-statement-per-connection-size:20# 配置监控统计拦截的filters, 去掉后监控界面sql无法统计, wall用于防火墙filters:stat,wall# Spring监控AOP切入点如x.y.z.service.*,配置多个英文逗号分隔aop-patterns:com.wno704.boot.servie.*# WebStatFilter配置web-stat-filter:enabled:true# 添加过滤规则url-pattern:/*# 忽略过滤的格式exclusions:*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*# StatViewServlet配置stat-view-servlet:enabled:true# 访问路径为/druid时跳转到StatViewServleturl-pattern:/druid/*# 是否能够重置数据reset-enable:false# 需要账号密码才能访问控制台login-username:druidlogin-password:druid123# IP白名单# allow: 127.0.0.1# IP黑名单共同存在时deny优先于allow# deny: 192.168.1.218# 配置StatFilterfilter:stat:log-slow-sql:truemybatis-plus:configuration:map-underscore-to-camel-case:trueauto-mapping-behavior:fulllog-impl:org.apache.ibatis.logging.stdout.StdOutImplmapper-locations:classpath:mapper/*Mapper.xmlglobal-config:# 逻辑删除配置db-config:# 删除前logic-not-delete-value:1# 删除后logic-delete-value:02.3 分页插件配置创建MybatisPlusConfig.javaConfigurationMapperScan(com.wno704.boot.mapper)publicclassMybatisPlusConfig{/** * 新的分页插件,一缓和二缓遵循mybatis的规则,需要设置 MybatisConfiguration#useDeprecatedExecutor false 避免缓存出现问题(该属性会在旧插件移除后一同移除) */BeanpublicMybatisPlusInterceptormybatisPlusInterceptor(){MybatisPlusInterceptorinterceptornewMybatisPlusInterceptor();interceptor.addInnerInterceptor(newPaginationInnerInterceptor(DbType.MYSQL));returninterceptor;}BeanpublicConfigurationCustomizerconfigurationCustomizer(){returnconfiguration-configuration.setUseDeprecatedExecutor(false);}}2.4 自动生成代码创建GeneratorCodeConfig.javapublicclassGeneratorCodeConfig{publicstaticStringscanner(Stringtip){ScannerscannernewScanner(System.in);StringBuilderhelpnewStringBuilder();help.append(请输入tip);System.out.println(help.toString());if(scanner.hasNext()){Stringiptscanner.next();if(StringUtils.isNotEmpty(ipt)){returnipt;}}thrownewMybatisPlusException(请输入正确的tip);}publicstaticvoidmain(String[]args){// 代码生成器AutoGeneratormpgnewAutoGenerator();// 全局配置GlobalConfiggcnewGlobalConfig();StringprojectPathSystem.getProperty(user.dir);projectPathE:\\workspace\\workspace(idea)\\spring\\boot\\24springboot-mybatisplus;gc.setOutputDir(projectPath/src/main/java);gc.setAuthor(wno704);gc.setOpen(false);//实体属性 Swagger2 注解gc.setSwagger2(false);mpg.setGlobalConfig(gc);// 数据源配置DataSourceConfigdscnewDataSourceConfig();dsc.setUrl(jdbc:mysql://127.0.0.1:3306/springboot?useUnicodetruecharacterEncodingutf8serverTimezoneUTCallowPublicKeyRetrievaltrueallowMultiQueriestrueuseSSLfalse);dsc.setDriverName(com.mysql.cj.jdbc.Driver);dsc.setUsername(spring);dsc.setPassword(spring#123);mpg.setDataSource(dsc);// 包配置PackageConfigpcnewPackageConfig();//pc.setModuleName(scanner(模块名));pc.setParent(com.wno704.boot);pc.setEntity(model);//entitypc.setMapper(mapper);pc.setService(service);pc.setServiceImpl(service.impl);mpg.setPackageInfo(pc);// 配置模板TemplateConfigtemplateConfignewTemplateConfig();templateConfig.setXml(null);mpg.setTemplate(templateConfig);// 策略配置StrategyConfigstrategynewStrategyConfig();strategy.setNaming(NamingStrategy.underline_to_camel);strategy.setColumnNaming(NamingStrategy.underline_to_camel);strategy.setSuperEntityClass(com.baomidou.mybatisplus.extension.activerecord.Model);strategy.setEntityLombokModel(true);strategy.setRestControllerStyle(true);strategy.setEntityLombokModel(true);strategy.setInclude(scanner(表名多个英文逗号分割).split(,));strategy.setControllerMappingHyphenStyle(true);strategy.setTablePrefix(pc.getModuleName()_);mpg.setStrategy(strategy);mpg.setTemplateEngine(newFreemarkerTemplateEngine());mpg.execute();}}2.5 数据准备这里我们使用以前的测试数据这里以sys_log表做测试2.6 测试运行GeneratorCodeConfig.java输入sys_log生产代码如下我们编写控制代码调用Autowired private ISysLogService iSysLogService; RequestMapping( value /getLog, method RequestMethod.GET) public SysLog getLog(){ return iSysLogService.getById(1); }启动项目浏览器访问 http://localhost:8080/sys-log/getLog三、自定义sql3.1 定义Mapper.xml在resources目录下新建mapper文件夹新建SysLogMapper.xml文件?xml version1.0 encodingUTF-8?!DOCTYPEmapperPUBLIC-//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtdmappernamespacecom.wno704.boot.mapper.SysLogMapper!-- 查找所有信息 --selectidfindAllSysLogresultTypecom.wno704.boot.model.SysLogselect * from sys_log/select/mapper3.2 代码改造在SysLogMapper.java新增findAllSysLog()代码如下publicinterfaceSysLogMapperextendsBaseMapperSysLog{publicListSysLogfindAllSysLog();}在ISysLogService.java新增findAllSysLog()代码如下publicinterfaceISysLogServiceextendsIServiceSysLog{publicListSysLogfindAllSysLog();}在SysLogServiceImpl.java新增findAllSysLog()代码如下ServicepublicclassSysLogServiceImplextendsServiceImplSysLogMapper,SysLogimplementsISysLogService{AutowiredprivateSysLogMappersysLogMapper;OverridepublicListSysLogfindAllSysLog(){returnsysLogMapper.findAllSysLog();}}在SysLogController.java新增getAllLog()代码如下RestControllerRequestMapping(/sys-log)publicclassSysLogController{AutowiredprivateISysLogServiceiSysLogService;RequestMapping(value/getLog,methodRequestMethod.GET)publicSysLoggetLog(){returniSysLogService.getById(1);}RequestMapping(value/getAllLog,methodRequestMethod.GET)publicListSysLoggetAllLog(){returniSysLogService.findAllSysLog();}}3.3 测试启动项目浏览器访问http://localhost:8080/sys-log/getAllLog控制台显示如下mybatis-plus3.3之前的版本参考https://www.cnblogs.com/liuyj-top/p/12976396.html四、分页查询4.1 代码改造在ISysLogService.java新增findSysLogByPage()代码如下publicListSysLogfindSysLogByPage(Integercurrpage,Integerpagesize);在SysLogServiceImpl.java新增findSysLogByPage()代码如下OverridepublicListSysLogfindSysLogByPage(Integercurrpage,Integerpagesize){//分页查询需要配置分页插件PageSysLogpagenewPage(currpage,pagesize);IPageSysLogpagessysLogMapper.selectPage(page,null);System.out.println(总记录数:pages.getTotal());System.out.println(总页数pages.getSize());returnpages.getRecords();}在SysLogController.java新增getLogbyPage()代码如下GetMapping(getLogbyPage/{currpage}/{pagesize})publicListSysLoggetLogbyPage(PathVariableIntegercurrpage,PathVariableIntegerpagesize){returniSysLogService.findSysLogByPage(currpage,pagesize);}4.2 测试启动项目使用http请求测试如下五、模糊查询5.1 代码改造在ISysLogService.java新增findSysLogWithMethod()代码如下publicListSysLogfindSysLogWithMethod(Stringmethod);在SysLogServiceImpl.java新增findSysLogWithMethod()代码如下OverridepublicListSysLogfindSysLogWithMethod(Stringmethod){QueryWrapperSysLogwrappernewQueryWrapper();wrapper.like(method,method);wrapper.orderByDesc(true,create_time);returnsysLogMapper.selectList(wrapper);}在SysLogController.java新增getLogbyMethod()代码如下GetMapping(getLogbyMethod/{method})publicListSysLoggetLogbyMethod(PathVariableStringmethod){returniSysLogService.findSysLogWithMethod(method);}5.2 测试启动项目使用http请求测试如下更多条件构造器官方文档
