若依 MyBatis改为MyBatis-Plus

客官°小女子只卖身不卖艺 2023-09-24 20:07 45阅读 0赞

主要内容：升级成mybatis-plus，代码生成也是mybatis-plus版本

跟着我一步一步来，就可完成升级！

检查：启动程序，先保证若依能启动

第一步：添加依赖

这里需要在两个地方添加，一个是最外面的父工程的pom.xml，一个是ruoyi-common的pom.xml。

最外面的父工程的pom.xml：

1.添加版本信息

cf7d1f409863410b902861f49b78dfba.png

  1. 代码：
  2. <!--        mybatis-plus 版本-->
  3.         <mybatis-pluc.version>3.4.2</mybatis-pluc.version>

2.添加mybatis-plus依赖

6096c4bd847f441e9293a9b0e2b4f134.png

代码：

  1. <!-- mybatis-plus 增强CRUD -->
  2. <dependency>
  3.     <groupId>com.baomidou</groupId>
  4.     <artifactId>mybatis-plus-boot-starter</artifactId>
  5.     <version>3.4.2</version>
  6. </dependency>

ruoyi-common的pom.xml：

1.直接继承父工程的依赖

06385196265f42aebe2f8ca53dfacc3c.png

第一步验证：

admin的包中的application.yml文件有mybatis-plus的提示，说明依赖弄好啦！

3f05e091aade40b8ad341cb9af46fffe.png

第二步：修改application.yml文件

1.删除旧的mybatis配置

39b279cf0aa84700905fbcb4aadc6e2b.png

2.写入新配置

1ee70bff179a4495be80b296764e9d6b.png

代码：

  1. # MyBatis Plus配置
  2. mybatis-plus:
  3.   # 搜索指定包别名   根据自己的项目来
  4.   typeAliasesPackage: com.rchuing.sis.**.domain 
  5.   # 配置mapper的扫描，找到所有的mapper.xml映射文件
  6.   mapperLocations: classpath*:mapper/**/*Mapper.xml
  7.   # 加载全局的配置文件
  8.   configLocation: classpath:mybatis/mybatis-config.xml
  9.   global-config:
  10.     enable-sql-runner: true
  11.     db-config:
  12.       id-type: auto

第三步：重写mybatis配置文件

1.在framework中，找到MybatisConfig文件，然后删除。

07a1cce820254e0cad11d459eca3e136.png

2.在刚删除的文件夹下，新建一个MybatisPlus的java文件

复制已下内容到java文件中：

  1. /**
  2.  * Mybatis Plus 配置
  3.  *
  4.  * @author ruoyi
  5.  */
  6. @EnableTransactionManagement(proxyTargetClass = true)
  7. @Configuration
  8. public class MybatisPlusConfig
  9. {
  10.     @Bean
  11.     public MybatisPlusInterceptor mybatisPlusInterceptor()
  12.     {
  13.         MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
  14.         // 分页插件
  15.         interceptor.addInnerInterceptor(paginationInnerInterceptor());
  16.         // 乐观锁插件
  17.         interceptor.addInnerInterceptor(optimisticLockerInnerInterceptor());
  18.         // 阻断插件
  19.         interceptor.addInnerInterceptor(blockAttackInnerInterceptor());
  20.         return interceptor;
  21.     }
  23.     /**
  24.      * 分页插件，自动识别数据库类型 https://baomidou.com/guide/interceptor-pagination.html
  25.      */
  26.     public PaginationInnerInterceptor paginationInnerInterceptor()
  27.     {
  28.         PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor();
  29.         // 设置数据库类型为mysql
  30.         paginationInnerInterceptor.setDbType(DbType.MYSQL);
  31.         // 设置最大单页限制数量，默认 500 条，-1 不受限制
  32.         paginationInnerInterceptor.setMaxLimit(-1L);
  33.         return paginationInnerInterceptor;
  34.     }
  36.     /**
  37.      * 乐观锁插件 https://baomidou.com/guide/interceptor-optimistic-locker.html
  38.      */
  39.     public OptimisticLockerInnerInterceptor optimisticLockerInnerInterceptor()
  40.     {
  41.         return new OptimisticLockerInnerInterceptor();
  42.     }
  44.     /**
  45.      * 如果是对全表的删除或更新操作，就会终止该操作 https://baomidou.com/guide/interceptor-block-attack.html
  46.      */
  47.     public BlockAttackInnerInterceptor blockAttackInnerInterceptor()
  48.     {
  49.         return new BlockAttackInnerInterceptor();
  50.     }
  51. }

如图：

6013c190dabd48cb94edb12070eaa507.png

到这里Mybatis-plus就升级完成了。但代码生成里面还是以前mybatis的，这里也需要升级一下，方便代码生成。

第四步:把代码生成修改为mybatis-plus版本

1.在generator找到vm中的java文件夹

295b16675cc446e9a73bf58dd0bfd2a3.png

2.修改里面内容：这里直接上代码了，找到对应的直接复制粘贴就行。

2.1:domain.java.vm

  1. package ${packageName}.domain;
  3. #foreach ($import in $importList)
  4. import ${import};
  5. #end
  6. import com.baomidou.mybatisplus.annotation.IdType;
  7. import com.baomidou.mybatisplus.annotation.TableId;
  8. import com.baomidou.mybatisplus.annotation.TableName;
  9. import org.apache.commons.lang3.builder.ToStringBuilder;
  10. import org.apache.commons.lang3.builder.ToStringStyle;
  11. import com.rchuing.sis.common.annotation.Excel;
  12. #if($table.crud || $table.sub)
  13. import com.rchuing.sis.common.core.domain.BaseEntity;
  14. #elseif($table.tree)
  15. import com.fenghuang.common.core.domain.TreeEntity;
  16. #end
  18. /**
  19.  * ${functionName}对象 ${tableName}
  20.  *
  21.  * @author ${author}
  22.  * @date ${datetime}
  23.  */
  24. #if($table.crud || $table.sub)
  25.     #set($Entity="BaseEntity")
  26. #elseif($table.tree)
  27.     #set($Entity="TreeEntity")
  28. #end
  29. @TableName(resultMap = "${packageName}.mapper.${ClassName}Mapper.${ClassName}Result")
  30. public class ${ClassName} extends ${Entity}
  31.         {
  32. private static final long serialVersionUID = 1L;
  34. #foreach ($column in $columns)
  35.     #if(!$table.isSuperColumn($column.javaField))
  36.     /** $column.columnComment */
  37.         #if($column.list)
  38.             #set($parentheseIndex=$column.columnComment.indexOf("（"))
  39.             #if($parentheseIndex != -1)
  40.                 #set($comment=$column.columnComment.substring(0, $parentheseIndex))
  41.             #else
  42.                 #set($comment=$column.columnComment)
  43.             #end
  44.             #if($parentheseIndex != -1)
  45.             @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
  46.             #elseif($column.javaType == 'Date')
  47.             @JsonFormat(pattern = "yyyy-MM-dd")
  48.             @Excel(name = "${comment}", width = 30, dateFormat = "yyyy-MM-dd")
  49.             #else
  50.             @Excel(name = "${comment}")
  51.             #end
  52.         #end
  53.         #if($column.isPk == 1)
  54.         @TableId(value = "$column.columnName",type = IdType.AUTO)
  55.         #end
  56.     private $column.javaType $column.javaField;
  58.     #end
  59. #end
  60. #if($table.sub)
  61. /** $table.subTable.functionName信息 */
  62. private List<${subClassName}> ${subclassName}List;
  64. #end
  65. #foreach ($column in $columns)
  66.     #if(!$table.isSuperColumn($column.javaField))
  67.         #if($column.javaField.length() > 2 && $column.javaField.substring(1,2).matches("[A-Z]"))
  68.             #set($AttrName=$column.javaField)
  69.         #else
  70.             #set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)})
  71.         #end
  72.     public void set${AttrName}($column.javaType $column.javaField)
  73.             {
  74.             this.$column.javaField = $column.javaField;
  75.             }
  77.     public $column.javaType get${AttrName}()
  78.             {
  79.             return $column.javaField;
  80.             }
  81.     #end
  82. #end
  84. #if($table.sub)
  85. public List<${subClassName}> get${subClassName}List()
  86.         {
  87.         return ${subclassName}List;
  88.         }
  90. public void set${subClassName}List(List<${subClassName}> ${subclassName}List)
  91.         {
  92.         this.${subclassName}List = ${subclassName}List;
  93.         }
  95. #end
  96. @Override
  97. public String toString() {
  98.         return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
  99.     #foreach ($column in $columns)
  100.         #if($column.javaField.length() > 2 && $column.javaField.substring(1,2).matches("[A-Z]"))
  101.             #set($AttrName=$column.javaField)
  102.         #else
  103.             #set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)})
  104.         #end
  105.             .append("${column.javaField}", get${AttrName}())
  106.     #end
  107.     #if($table.sub)
  108.             .append("${subclassName}List", get${subClassName}List())
  109.     #end
  110.         .toString();
  111.         }
  112.         }

2.2:mapper.java.vm

  1. package ${packageName}.mapper;
  3. import java.util.List;
  4. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  5. import ${packageName}.domain.${ClassName};
  6. #if($table.sub)
  7. import ${packageName}.domain.${subClassName};
  8. #end
  10. /**
  11.  * ${functionName}Mapper接口
  12.  *
  13.  * @author ${author}
  14.  * @date ${datetime}
  15.  */
  16. public interface ${ClassName}Mapper extends BaseMapper<${ClassName}> {
  17.     /**
  18.      * 查询${functionName}
  19.      *
  20.      * @param ${pkColumn.javaField} ${functionName}主键
  21.      * @return ${functionName}
  22.      */
  23.     public ${ClassName} select${ClassName}By${pkColumn.capJavaField}(${pkColumn.javaType} ${pkColumn.javaField});
  25.     /**
  26.      * 查询${functionName}列表
  27.      *
  28.      * @param ${className} ${functionName}
  29.      * @return ${functionName}集合
  30.      */
  31.     public List<${ClassName}> select${ClassName}List(${ClassName} ${className});
  33.     /**
  34.      * 新增${functionName}
  35.      *
  36.      * @param ${className} ${functionName}
  37.      * @return 结果
  38.      */
  39.     public int insert${ClassName}(${ClassName} ${className});
  41.     /**
  42.      * 修改${functionName}
  43.      *
  44.      * @param ${className} ${functionName}
  45.      * @return 结果
  46.      */
  47.     public int update${ClassName}(${ClassName} ${className});
  49.     /**
  50.      * 删除${functionName}
  51.      *
  52.      * @param ${pkColumn.javaField} ${functionName}主键
  53.      * @return 结果
  54.      */
  55.     public int delete${ClassName}By${pkColumn.capJavaField}(${pkColumn.javaType} ${pkColumn.javaField});
  57.     /**
  58.      * 批量删除${functionName}
  59.      *
  60.      * @param ${pkColumn.javaField}s 需要删除的数据主键集合
  61.      * @return 结果
  62.      */
  63.     public int delete${ClassName}By${pkColumn.capJavaField}s(${pkColumn.javaType}[] ${pkColumn.javaField}s);
  64. #if($table.sub)
  66.     /**
  67.      * 批量删除${subTable.functionName}
  68.      *
  69.      * @param ${pkColumn.javaField}s 需要删除的数据主键集合
  70.      * @return 结果
  71.      */
  72.     public int delete${subClassName}By${subTableFkClassName}s(${pkColumn.javaType}[] ${pkColumn.javaField}s);
  74.     /**
  75.      * 批量新增${subTable.functionName}
  76.      *
  77.      * @param ${subclassName}List ${subTable.functionName}列表
  78.      * @return 结果
  79.      */
  80.     public int batch${subClassName}(List<${subClassName}> ${subclassName}List);
  83.     /**
  84.      * 通过${functionName}主键删除${subTable.functionName}信息
  85.      *
  86.      * @param ${pkColumn.javaField} ${functionName}ID
  87.      * @return 结果
  88.      */
  89.     public int delete${subClassName}By${subTableFkClassName}(${pkColumn.javaType} ${pkColumn.javaField});
  90. #end
  91. }

2.3:service.java.vm

  1. package ${packageName}.service;
  3. import java.util.List;
  4. import ${packageName}.domain.${ClassName};
  5. import com.baomidou.mybatisplus.extension.service.IService;
  7. /**
  8.  * ${functionName}Service接口
  9.  *
  10.  * @author ${author}
  11.  * @date ${datetime}
  12.  */
  13. public interface I${ClassName}Service extends IService<${ClassName}> {
  14.     /**
  15.      * 查询${functionName}
  16.      *
  17.      * @param ${pkColumn.javaField} ${functionName}主键
  18.      * @return ${functionName}
  19.      */
  20.     public ${ClassName} select${ClassName}By${pkColumn.capJavaField}(${pkColumn.javaType} ${pkColumn.javaField});
  22.     /**
  23.      * 查询${functionName}列表
  24.      *
  25.      * @param ${className} ${functionName}
  26.      * @return ${functionName}集合
  27.      */
  28.     public List<${ClassName}> select${ClassName}List(${ClassName} ${className});
  30.     /**
  31.      * 新增${functionName}
  32.      *
  33.      * @param ${className} ${functionName}
  34.      * @return 结果
  35.      */
  36.     public int insert${ClassName}(${ClassName} ${className});
  38.     /**
  39.      * 修改${functionName}
  40.      *
  41.      * @param ${className} ${functionName}
  42.      * @return 结果
  43.      */
  44.     public int update${ClassName}(${ClassName} ${className});
  46.     /**
  47.      * 批量删除${functionName}
  48.      *
  49.      * @param ${pkColumn.javaField}s 需要删除的${functionName}主键集合
  50.      * @return 结果
  51.      */
  52.     public int delete${ClassName}By${pkColumn.capJavaField}s(${pkColumn.javaType}[] ${pkColumn.javaField}s);
  54.     /**
  55.      * 删除${functionName}信息
  56.      *
  57.      * @param ${pkColumn.javaField} ${functionName}主键
  58.      * @return 结果
  59.      */
  60.     public int delete${ClassName}By${pkColumn.capJavaField}(${pkColumn.javaType} ${pkColumn.javaField});
  61. }

2.4:serviceimpl.java.vm

  1. package ${packageName}.service.impl;
  3. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  4. import java.util.List;
  5. #foreach ($column in $columns)
  6. #if($column.javaField == 'createTime' || $column.javaField == 'updateTime')
  7. import com.rchuing.common.utils.DateUtils;
  8. #break
  9. #end
  10. #end
  11. import org.springframework.beans.factory.annotation.Autowired;
  12. import org.springframework.stereotype.Service;
  13. #if($table.sub)
  14. import java.util.ArrayList;
  15. import com.rchuing.common.utils.StringUtils;
  16. import org.springframework.transaction.annotation.Transactional;
  17. import ${packageName}.domain.${subClassName};
  18. #end
  19. import ${packageName}.mapper.${ClassName}Mapper;
  20. import ${packageName}.domain.${ClassName};
  21. import ${packageName}.service.I${ClassName}Service;
  23. /**
  24.  * ${functionName}Service业务层处理
  25.  *
  26.  * @author ${author}
  27.  * @date ${datetime}
  28.  */
  29. @Service
  30. public class ${ClassName}ServiceImpl extends ServiceImpl<${ClassName}Mapper, ${ClassName}> implements I${ClassName}Service {
  31.     @Autowired
  32.     private ${ClassName}Mapper ${className}Mapper;
  34.     /**
  35.      * 查询${functionName}
  36.      *
  37.      * @param ${pkColumn.javaField} ${functionName}主键
  38.      * @return ${functionName}
  39.      */
  40.     @Override
  41.     public ${ClassName} select${ClassName}By${pkColumn.capJavaField}(${pkColumn.javaType} ${pkColumn.javaField}) {
  42.         return ${className}Mapper.select${ClassName}By${pkColumn.capJavaField}(${pkColumn.javaField});
  43.     }
  45.     /**
  46.      * 查询${functionName}列表
  47.      *
  48.      * @param ${className} ${functionName}
  49.      * @return ${functionName}
  50.      */
  51.     @Override
  52.     public List<${ClassName}> select${ClassName}List(${ClassName} ${className}) {
  53.         return ${className}Mapper.select${ClassName}List(${className});
  54.     }
  56.     /**
  57.      * 新增${functionName}
  58.      *
  59.      * @param ${className} ${functionName}
  60.      * @return 结果
  61.      */
  62. #if($table.sub)
  63.     @Transactional
  64. #end
  65.     @Override
  66.     public int insert${ClassName}(${ClassName} ${className}) {
  67. #foreach ($column in $columns)
  68. #if($column.javaField == 'createTime')
  69.         ${className}.setCreateTime(DateUtils.getNowDate());
  70. #end
  71. #end
  72. #if($table.sub)
  73.         int rows = ${className}Mapper.insert${ClassName}(${className});
  74.         insert${subClassName}(${className});
  75.         return rows;
  76. #else
  77.         return ${className}Mapper.insert${ClassName}(${className});
  78. #end
  79.     }
  81.     /**
  82.      * 修改${functionName}
  83.      *
  84.      * @param ${className} ${functionName}
  85.      * @return 结果
  86.      */
  87. #if($table.sub)
  88.     @Transactional
  89. #end
  90.     @Override
  91.     public int update${ClassName}(${ClassName} ${className}) {
  92. #foreach ($column in $columns)
  93. #if($column.javaField == 'updateTime')
  94.         ${className}.setUpdateTime(DateUtils.getNowDate());
  95. #end
  96. #end
  97. #if($table.sub)
  98.         ${className}Mapper.delete${subClassName}By${subTableFkClassName}(${className}.get${pkColumn.capJavaField}());
  99.         insert${subClassName}(${className});
  100. #end
  101.         return ${className}Mapper.update${ClassName}(${className});
  102.     }
  104.     /**
  105.      * 批量删除${functionName}
  106.      *
  107.      * @param ${pkColumn.javaField}s 需要删除的${functionName}主键
  108.      * @return 结果
  109.      */
  110. #if($table.sub)
  111.     @Transactional
  112. #end
  113.     @Override
  114.     public int delete${ClassName}By${pkColumn.capJavaField}s(${pkColumn.javaType}[] ${pkColumn.javaField}s) {
  115. #if($table.sub)
  116.         ${className}Mapper.delete${subClassName}By${subTableFkClassName}s(${pkColumn.javaField}s);
  117. #end
  118.         return ${className}Mapper.delete${ClassName}By${pkColumn.capJavaField}s(${pkColumn.javaField}s);
  119.     }
  121.     /**
  122.      * 删除${functionName}信息
  123.      *
  124.      * @param ${pkColumn.javaField} ${functionName}主键
  125.      * @return 结果
  126.      */
  127. #if($table.sub)
  128.     @Transactional
  129. #end
  130.     @Override
  131.     public int delete${ClassName}By${pkColumn.capJavaField}(${pkColumn.javaType} ${pkColumn.javaField}) {
  132. #if($table.sub)
  133.         ${className}Mapper.delete${subClassName}By${subTableFkClassName}(${pkColumn.javaField});
  134. #end
  135.         return ${className}Mapper.delete${ClassName}By${pkColumn.capJavaField}(${pkColumn.javaField});
  136.     }
  137. #if($table.sub)
  139.     /**
  140.      * 新增${subTable.functionName}信息
  141.      *
  142.      * @param ${className} ${functionName}对象
  143.      */
  144.     public void insert${subClassName}(${ClassName} ${className}) {
  145.         List<${subClassName}> ${subclassName}List = ${className}.get${subClassName}List();
  146.         ${pkColumn.javaType} ${pkColumn.javaField} = ${className}.get${pkColumn.capJavaField}();
  147.         if (StringUtils.isNotNull(${subclassName}List))
  148.         {
  149.             List<${subClassName}> list = new ArrayList<${subClassName}>();
  150.             for (${subClassName} ${subclassName} : ${subclassName}List)
  151.             {
  152.                 ${subclassName}.set${subTableFkClassName}(${pkColumn.javaField});
  153.                 list.add(${subclassName});
  154.             }
  155.             if (list.size() > 0)
  156.             {
  157.                 ${className}Mapper.batch${subClassName}(list);
  158.             }
  159.         }
  160.     }
  161. #end
  162. }

2.5:sub-domain.java.vm

  1. package ${packageName}.domain;
  3. #foreach ($import in $subImportList)
  4. import ${import};
  5. #end
  6. import org.apache.commons.lang3.builder.ToStringBuilder;
  7. import org.apache.commons.lang3.builder.ToStringStyle;
  8. import com.rchuing.common.annotation.Excel;
  9. import com.rchuing.common.core.domain.BaseEntity;
  11. /**
  12.  * ${subTable.functionName}对象 ${subTableName}
  13.  *
  14.  * @author ${author}
  15.  * @date ${datetime}
  16.  */
  17. public class ${subClassName} extends BaseEntity {
  18.     private static final long serialVersionUID = 1L;
  20. #foreach ($column in $subTable.columns)
  21. #if(!$table.isSuperColumn($column.javaField))
  22.     /** $column.columnComment */
  23. #if($column.list)
  24. #set($parentheseIndex=$column.columnComment.indexOf("（"))
  25. #if($parentheseIndex != -1)
  26. #set($comment=$column.columnComment.substring(0, $parentheseIndex))
  27. #else
  28. #set($comment=$column.columnComment)
  29. #end
  30. #if($parentheseIndex != -1)
  31.     @Excel(name = "${comment}", readConverterExp = "$column.readConverterExp()")
  32. #elseif($column.javaType == 'Date')
  33.     @JsonFormat(pattern = "yyyy-MM-dd")
  34.     @Excel(name = "${comment}", width = 30, dateFormat = "yyyy-MM-dd")
  35. #else
  36.     @Excel(name = "${comment}")
  37. #end
  38. #end
  39.     private $column.javaType $column.javaField;
  41. #end
  42. #end
  43. #foreach ($column in $subTable.columns)
  44. #if(!$table.isSuperColumn($column.javaField))
  45. #if($column.javaField.length() > 2 && $column.javaField.substring(1,2).matches("[A-Z]"))
  46. #set($AttrName=$column.javaField)
  47. #else
  48. #set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)})
  49. #end
  50.     public void set${AttrName}($column.javaType $column.javaField) {
  51.         this.$column.javaField = $column.javaField;
  52.     }
  54.     public $column.javaType get${AttrName}() {
  55.         return $column.javaField;
  56.     }
  57. #end
  58. #end
  60.     @Override
  61.     public String toString() {
  62.         return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
  63. #foreach ($column in $subTable.columns)
  64. #if($column.javaField.length() > 2 && $column.javaField.substring(1,2).matches("[A-Z]"))
  65. #set($AttrName=$column.javaField)
  66. #else
  67. #set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)})
  68. #end
  69.             .append("${column.javaField}", get${AttrName}())
  70. #end
  71.             .toString();
  72.     }
  73. }

到这里就升级完成。

下面进行测试：

1.

d8265481387044c4a9a94c8603ca474d.png

2.

4403f6778a784138a8e9df57893fce51.png

3.如果看到mybatis的东西，说明升级成功！

32742c36f25c4422afc86eb5c0007554.png

注意：

1.这里可能有些包的路径不对，把爆红的包删除，重新导入就可！

2.因为实际项目路径不同，这里**可能**需要手动修改！

73a4174b95af4494b0bbd3fdc87fc041.png

3.在BaseEntity类中

1a7da61b05c54e6e927ff908ebe9a880.png

发表评论

表情：
评论列表 （有 0 条评论，45人围观）

还没有评论，来说两句吧...

相关阅读