Mybatis generator 1.4.x 入门教程--转载

不念不忘少年蓝@ 2023-01-05 01:20 266阅读 0赞

# Mybatis generator 1.4.x 入门教程 #

## 一、前言 ##

最近因为公司开了新的项目，所以在构建骨架的时候发现mybatis最新的版本已经更新到了1.4.0了,尝试了一下，比起之前的mybatis版本，有了更好的优化，用上了lamada表达式，还支持动态sql查询，所以在这里安利一波,因为之前我用的Laravel ORM,所以比较习惯使用这种lamada表达式来查询，可能之前用习惯了以前的查询方式的

## 二、官方文档地址 ##

[官方文档地址][Link 1]

## 三、集成 mybatis Generator 1.4.0 ##

### pom文件 ###

<dependencies>
      ...
      
      
      <dependency>
        <groupId>org.mybatis.dynamic-sql</groupId>
        <artifactId>mybatis-dynamic-sql</artifactId>
        <version>1.1.4</version>
      </dependency>
    </dependencies>     
    
    
    <build>
    <plugins>
    ...
    
      <plugin>
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-maven-plugin</artifactId>
        <version>1.4.0</version>
        <dependencies>
        </dependencies>
        <configuration>
        
      <configurationFile>src/main/resources/mybatis/configuration.xml</configurationFile>
        <verbose>true</verbose>
        <overwrite>true</overwrite>
        </configuration>
      </plugin>
    </plugins>
    </build>

### 配置文件 mybatis configuration.xml ###

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration  PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
        "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
    <generatorConfiguration>
            
        <properties resource="mybatis/db.properties"/>
        <classPathEntry location="${jdbc.jar.path}"/>
        <context id="testTables"
                 defaultModelType="flat">
            <plugin type="org.mybatis.generator.plugins.SerializablePlugin"></plugin>
            <commentGenerator>
                
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
            
            <jdbcConnection driverClass="${jdbc.driver}"
                            connectionURL="${jdbc.url}"                                                        userId="${jdbc.username}" 
                            password="${jdbc.password}">
            </jdbcConnection>
    
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="com.xxx.entity"       targetProject="src/main/java">
                
                <property name="enableSubPackages" value="true"/>
                
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
            
            <javaClientGenerator type="XMLMAPPER"                               targetPackage="com.xxx.mapper"
                                 targetProject="src/main/java">
                
                <property name="enableSubPackages" value="true"/>
            </javaClientGenerator>
            
                    <table tableName="xxx" schema="xxx"></table>
        </context>
    </generatorConfiguration>

### 配置属性文件 db.properties ###

jdbc.jar.path=/Users/xxx/.m2/repository/mysql/mysql-connector-java/8.0.17/mysql-connector-java-8.0.17.jar
    jdbc.driver=com.mysql.cj.jdbc.Driver
    jdbc.url=jdbc:mysql://xxx:xxx:xxx:xxx:port/dbname?characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&verifyServerCertificate=false
    jdbc.username=username
    jdbc.password=password
    ...

## 四、执行generator生成 dao类和mapper接口 ##

*  生成dao类中每个属性会自动加上@Generated

生成的dao类

*  生成的mapper接口类，会自动生成Mapper和DynamicSqlSupport

## 五、使用举例 ##

*  Dao实例

import java.io.Serializable;
    import java.util.Date;
    import javax.annotation.Generated;
    public class Teacher implements Serializable {
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        private Integer id;
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        private String teacherNumber;
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        private String teacherName;
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        private String telephone;
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        private String email;
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        private String password;
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        private Boolean deleted;
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        private Date createdTime;
        @Generated("org.mybatis.gener" +
                "ator.api.MyBatisGenerator")
        private Date updatedTime;
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        private static final long serialVersionUID = 1L;
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        public Integer getId() {
            return id;
        }
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        public void setId(Integer id) {
            this.id = id;
        }
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        public String getTeacherNumber() {
            return teacherNumber;
        }
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        public void setTeacherNumber(String teacherNumber) {
            this.teacherNumber = teacherNumber == null ? null : teacherNumber.trim();
        }
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        public String getTeacherName() {
            return teacherName;
        }
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        public void setTeacherName(String teacherName) {
            this.teacherName = teacherName == null ? null : teacherName.trim();
        }
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        public String getTelephone() {
            return telephone;
        }
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        public void setTelephone(String telephone) {
            this.telephone = telephone == null ? null : telephone.trim();
        }
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        public String getEmail() {
            return email;
        }
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        public void setEmail(String email) {
            this.email = email == null ? null : email.trim();
        }
        ...
    }

### 5.1 查找 ###

源码

// 根据provider查询多个记录
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        @SelectProvider(type=SqlProviderAdapter.class, method="select")
        @ResultMap("TeacherResult")
        Optional<Teacher> selectOne(SelectStatementProvider selectStatement);
            
    // 根据provider查询多个记录
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        @SelectProvider(type=SqlProviderAdapter.class, method="select")
        @Results(id="TeacherResult", value = {
            @Result(column="id", property="id", jdbcType=JdbcType.INTEGER, id=true),
            @Result(column="teacher_number", property="teacherNumber", jdbcType=JdbcType.VARCHAR),
            @Result(column="teacher_name", property="teacherName", jdbcType=JdbcType.VARCHAR),
            @Result(column="telephone", property="telephone", jdbcType=JdbcType.VARCHAR),
            @Result(column="email", property="email", jdbcType=JdbcType.VARCHAR),
            @Result(column="password", property="password", jdbcType=JdbcType.VARCHAR),
            @Result(column="deleted", property="deleted", jdbcType=JdbcType.BIT),
            @Result(column="created_time", property="createdTime", jdbcType=JdbcType.TIMESTAMP),
            @Result(column="updated_time", property="updatedTime", jdbcType=JdbcType.TIMESTAMP)
        })
        List<Teacher> selectMany(SelectStatementProvider selectStatement);
    
    // 根据dsl 查询单个记录
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        default Optional<Teacher> selectOne(SelectDSLCompleter completer) {
            return MyBatis3Utils.selectOne(this::selectOne, selectList, teacher, completer);
        }
    // 根据dsl 查询多个记录
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        default List<Teacher> select(SelectDSLCompleter completer) {
            return MyBatis3Utils.selectList(this::selectMany, selectList, teacher, completer);
        }
    
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        default List<Teacher> selectDistinct(SelectDSLCompleter completer) {
            return MyBatis3Utils.selectDistinct(this::selectMany, selectList, teacher, completer);
        }
    // 根据主键查询记录
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        default Optional<Teacher> selectByPrimaryKey(Integer id_) {
            return selectOne(c ->
                c.where(id, isEqualTo(id_))
            );
        }

实例

// 基本条件查询
     @Override
        public Teacher findById(Integer teacherId) {
            Optional<Teacher> teacher = teacherMapper.selectOne(c ->
                    c.where(TeacherDynamicSqlSupport.deleted, isEqualTo(false))
                            .and(TeacherDynamicSqlSupport.id, isEqualTo(teacherId))
            );
            if (teacher.isPresent()){
                return teacher.get();
            }
            return null;
        }
    
    // 条件查询分页
     @Override
        public List<Teacher> getListByPager(TeacherSearchModel model) {
          QueryExpressionWhereBuilder builder =        select(TeacherDynamicSqlSupport.teacher.allColumns())
            .from(TeacherDynamicSqlSupport.teacher)
            .where(TeacherDynamicSqlSupport.deleted, isEqualTo(false));
            if (!StringUtils.isEmpty(model.getNumberKeyWord()))
            {
                builder.and(TeacherDynamicSqlSupport.teacherNumber,isLike(model.getNumberKeyWord()));
            }
            if (!StringUtils.isEmpty(model.getNameKeyWord()))
            {
                builder.and(TeacherDynamicSqlSupport.teacherName,isLike(model.getNameKeyWord()));
            }
            builder.limit(model.getPageSize())
                    .offset(((model.getPageNumber()-1)*model.getPageSize()));
            SelectStatementProvider provider = builder.build().render(RenderingStrategy.MYBATIS3);
            List<Teacher> teachers = teacherMapper.selectMany(provider);
            return teachers;
        }

### 5.2 更新 ###

源码

// 根据provide更新
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        @UpdateProvider(type=SqlProviderAdapter.class, method="update")
        int update(UpdateStatementProvider updateStatement);
    
            @Generated("org.mybatis.generator.api.MyBatisGenerator")
        default int update(UpdateDSLCompleter completer) {
            return MyBatis3Utils.update(this::update, teacher, completer);
        }
    
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        static UpdateDSL<UpdateModel> updateAllColumns(Teacher record, UpdateDSL<UpdateModel> dsl) {
            return dsl.set(id).equalTo(record::getId)
                    .set(teacherNumber).equalTo(record::getTeacherNumber)
                    .set(teacherName).equalTo(record::getTeacherName)
                    .set(telephone).equalTo(record::getTelephone)
                    .set(email).equalTo(record::getEmail)
                    .set(password).equalTo(record::getPassword)
                    .set(deleted).equalTo(record::getDeleted)
                    .set(createdTime).equalTo(record::getCreatedTime)
                    .set(updatedTime).equalTo(record::getUpdatedTime);
        }
    
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        static UpdateDSL<UpdateModel> updateSelectiveColumns(Teacher record, UpdateDSL<UpdateModel> dsl) {
            return dsl.set(id).equalToWhenPresent(record::getId)
                    .set(teacherNumber).equalToWhenPresent(record::getTeacherNumber)
                    .set(teacherName).equalToWhenPresent(record::getTeacherName)
                    .set(telephone).equalToWhenPresent(record::getTelephone)
                    .set(email).equalToWhenPresent(record::getEmail)
                    .set(password).equalToWhenPresent(record::getPassword)
                    .set(deleted).equalToWhenPresent(record::getDeleted)
                    .set(createdTime).equalToWhenPresent(record::getCreatedTime)
                    .set(updatedTime).equalToWhenPresent(record::getUpdatedTime);
        }
            // 通过主键更新数据
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        default int updateByPrimaryKey(Teacher record) {
            return update(c ->
                c.set(teacherNumber).equalTo(record::getTeacherNumber)
                .set(teacherName).equalTo(record::getTeacherName)
                .set(telephone).equalTo(record::getTelephone)
                .set(email).equalTo(record::getEmail)
                .set(password).equalTo(record::getPassword)
                .set(deleted).equalTo(record::getDeleted)
                .set(createdTime).equalTo(record::getCreatedTime)
                .set(updatedTime).equalTo(record::getUpdatedTime)
                .where(id, isEqualTo(record::getId))
            );
        }
    
            // 通过主键条件更新数据
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        default int updateByPrimaryKeySelective(Teacher record) {
            return update(c ->
                c.set(teacherNumber).equalToWhenPresent(record::getTeacherNumber)
                .set(teacherName).equalToWhenPresent(record::getTeacherName)
                .set(telephone).equalToWhenPresent(record::getTelephone)
                .set(email).equalToWhenPresent(record::getEmail)
                .set(password).equalToWhenPresent(record::getPassword)
                .set(deleted).equalToWhenPresent(record::getDeleted)
                .set(createdTime).equalToWhenPresent(record::getCreatedTime)
                .set(updatedTime).equalToWhenPresent(record::getUpdatedTime)
                .where(id, isEqualTo(record::getId))
            );
        }

实例

@Override
        public int update(Teacher teacher) {
            return teacherMapper.updateByPrimaryKeySelective(teacher);
        }

### 5.3 添加(插入) ###

源码

// 直接完整插入
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        @InsertProvider(type=SqlProviderAdapter.class, method="insert")
        int insert(InsertStatementProvider<Teacher> insertStatement);
    
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        @InsertProvider(type=SqlProviderAdapter.class, method="insertMultiple")
        int insertMultiple(MultiRowInsertStatementProvider<Teacher> multipleInsertStatement);
        // 直接完整插入
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        default int insert(Teacher record) {
            return MyBatis3Utils.insert(this::insert, record, teacher, c ->
                c.map(id).toProperty("id")
                .map(teacherNumber).toProperty("teacherNumber")
                .map(teacherName).toProperty("teacherName")
                .map(telephone).toProperty("telephone")
                .map(email).toProperty("email")
                .map(password).toProperty("password")
                .map(deleted).toProperty("deleted")
                .map(createdTime).toProperty("createdTime")
                .map(updatedTime).toProperty("updatedTime")
            );
        }
            
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        default int insertMultiple(Collection<Teacher> records) {
            return MyBatis3Utils.insertMultiple(this::insertMultiple, records, teacher, c ->
                c.map(id).toProperty("id")
                .map(teacherNumber).toProperty("teacherNumber")
                .map(teacherName).toProperty("teacherName")
                .map(telephone).toProperty("telephone")
                .map(email).toProperty("email")
                .map(password).toProperty("password")
                .map(deleted).toProperty("deleted")
                .map(createdTime).toProperty("createdTime")
                .map(updatedTime).toProperty("updatedTime")
            );
        }
            // 条件部分插入
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        default int insertSelective(Teacher record) {
            return MyBatis3Utils.insert(this::insert, record, teacher, c ->
                c.map(id).toPropertyWhenPresent("id", record::getId)
                .map(teacherNumber).toPropertyWhenPresent("teacherNumber", record::getTeacherNumber)
                .map(teacherName).toPropertyWhenPresent("teacherName", record::getTeacherName)
                .map(telephone).toPropertyWhenPresent("telephone", record::getTelephone)
                .map(email).toPropertyWhenPresent("email", record::getEmail)
                .map(password).toPropertyWhenPresent("password", record::getPassword)
                .map(deleted).toPropertyWhenPresent("deleted", record::getDeleted)
                .map(createdTime).toPropertyWhenPresent("createdTime", record::getCreatedTime)
                .map(updatedTime).toPropertyWhenPresent("updatedTime", record::getUpdatedTime)
            );
        }

实例

@Override
        public int create(Teacher teacher) {
            return teacherMapper.insertSelective(teacher);
        }

### 5.4 删除 ###

源码

@Generated("org.mybatis.generator.api.MyBatisGenerator")
        @DeleteProvider(type=SqlProviderAdapter.class, method="delete")
        int delete(DeleteStatementProvider deleteStatement);
    
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        default int delete(DeleteDSLCompleter completer) {
            return MyBatis3Utils.deleteFrom(this::delete, teacher, completer);
        }
    
        @Generated("org.mybatis.generator.api.MyBatisGenerator")
        default int deleteByPrimaryKey(Integer id_) {
            return delete(c -> 
                c.where(id, isEqualTo(id_))
            );
        }

### 5.5 查询数量 Count ###

源码

@Generated("org.mybatis.generator.api.MyBatisGenerator")
        @SelectProvider(type=SqlProviderAdapter.class, method="select")
        long count(SelectStatementProvider selectStatement);
    
     @Generated("org.mybatis.generator.api.MyBatisGenerator")
        @SelectProvider(type=SqlProviderAdapter.class, method="select")
        long count(SelectStatementProvider selectStatement);
     @Generated("org.mybatis.generator.api.MyBatisGenerator")
        default long count(CountDSLCompleter completer) {
            return MyBatis3Utils.countFrom(this::count, teacher, completer);
        }

实例

// 这里比较坑的是select的参数是count，如果是其他的会报错
            @Override
        public long getCountByModel(TeacherSearchModel model) {
            QueryExpressionWhereBuilder builder = select(count()).
                                                            from(TeacherDynamicSqlSupport.teacher)
                                                        .where(TeacherDynamicSqlSupport.deleted, isEqualTo(false));
            if (!StringUtils.isEmpty(model.getNumberKeyWord()))
            {             builder.and(TeacherDynamicSqlSupport.teacherNumber,isLike(model.getNumberKeyWord()));
            }
            if (!StringUtils.isEmpty(model.getNameKeyWord()))
            {
                builder.and(TeacherDynamicSqlSupport.teacherName,isLike(model.getNameKeyWord()));
            }
            SelectStatementProvider provider = builder.build().render(RenderingStrategy.MYBATIS3);
            long count = teacherMapper.count(provider);
            return count;
        }

### 5.6 查询条件 ###

<table> 
 <thead> 
  <tr> 
   <th>方法</th> 
   <th>说明</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>isNull/isNotNull</td> 
   <td>是否为空/不为空</td> 
  </tr> 
  <tr> 
   <td>isEqualTo/isNotEqualTo</td> 
   <td>是否等于/不等于</td> 
  </tr> 
  <tr> 
   <td>isEqualToWhenPresent/isNotEqualToWhenPresent</td> 
   <td>当存在时是否(不)等于</td> 
  </tr> 
  <tr> 
   <td>isGreaterThan/isGreaterThanWhenPresent</td> 
   <td>大于</td> 
  </tr> 
  <tr> 
   <td>isGreaterThanOrEqualTo/isGreaterThanOrEqualToWhenPresent</td> 
   <td>大于等于</td> 
  </tr> 
  <tr> 
   <td>isLessThan/isLessThanWhenPresent/</td> 
   <td>小于</td> 
  </tr> 
  <tr> 
   <td>isLessThanOrEqualTo/isLessThanOrEqualToWhenPresent</td> 
   <td>小于等于</td> 
  </tr> 
  <tr> 
   <td>isIn/isNotIn</td> 
   <td>in操作</td> 
  </tr> 
  <tr> 
   <td>isInWhenPresent/isNotInWhenPresent</td> 
   <td>in操作</td> 
  </tr> 
  <tr> 
   <td>isBetween/isNotBetween</td> 
   <td>是否在区间</td> 
  </tr> 
  <tr> 
   <td>isBetweenWhenPresent/isNotBetweenWhenPresent</td> 
   <td>是否在区间</td> 
  </tr> 
  <tr> 
   <td>isLike/isNotLike</td> 
   <td>like(需要添加%)</td> 
  </tr> 
  <tr> 
   <td>isLikeWhenPresent/isNotLikeWhenPresent</td> 
   <td>like(需要添加%)</td> 
  </tr> 
  <tr> 
   <td>isTrue/isFalse</td> 
   <td>是否是true/false</td> 
  </tr> 
  <tr> 
   <td>isLikeCaseInsensitive/isLikeCaseInsensitiveWhenPresent</td> 
   <td>like(需要添加%)</td> 
  </tr> 
  <tr> 
   <td>isNotLikeCaseInsensitive/isNotLikeCaseInsensitiveWhenPresent</td> 
   <td>like(需要添加%)</td> 
  </tr> 
  <tr> 
   <td>isInCaseInsensitive/isInCaseInsensitiveWhenPresent</td> 
   <td>in操作</td> 
  </tr> 
  <tr> 
   <td>isNotInCaseInsensitive/isNotInCaseInsensitiveWhenPresent</td> 
   <td>in操作</td> 
  </tr> 
 </tbody> 
</table>

## 六、自定义查询 ##

### 6.1 自定义mapper接口查询 ###

@Generated(value = "org.mybatis.generator.api.MyBatisGenerator",comments = "Source Table: user")
        @SelectProvider(type = SqlProviderAdapter.class,method = "select")
        @Results(id="UserVOResult", value = {
            @Result(column="id", property="id", jdbcType= JdbcType.VARCHAR, id=true),
            @Result(column="user_name", property="userName", jdbcType=JdbcType.VARCHAR),
            @Result(column="gender", property="gender", jdbcType=JdbcType.BIT),
            @Result(column="avatar", property="avatar", jdbcType=JdbcType.VARCHAR),
            @Result(column="mobile", property="mobile", jdbcType=JdbcType.VARCHAR),
            @Result(column="email", property="email", jdbcType=JdbcType.VARCHAR),
            @Result(column="organization_name", property="organizationName", jdbcType=JdbcType.VARCHAR),
            @Result(column="real_name", property="realName", jdbcType=JdbcType.VARCHAR),
            @Result(column="main_organization", property="mainOrganization", jdbcType=JdbcType.INTEGER),
            @Result(column="organization", property="organization", jdbcType=JdbcType.VARCHAR),
            @Result(column="create_time", property="createTime", jdbcType=JdbcType.TIMESTAMP),
            @Result(column="update_time", property="updateTime", jdbcType=JdbcType.TIMESTAMP)
        })
        List<UserVO> selectManyJoin(SelectStatementProvider selectStatementProvider);

### 6.2 自定义sql解析器查询 ###

import java.util.regex.Matcher;
    import java.util.regex.Pattern;
    
    import org.apache.ibatis.mapping.SqlSource;
    import org.apache.ibatis.scripting.LanguageDriver;
    import org.apache.ibatis.scripting.xmltags.XMLLanguageDriver;
    import org.apache.ibatis.session.Configuration;
    
    /**
     * 解析sql语句
     */
    public class SimpleUpdateLangDriver extends XMLLanguageDriver implements LanguageDriver{
    
        private final Pattern inPattern = Pattern.compile("\$#\\{(\\w+)\\}\$");
    
        @Override
        public SqlSource createSqlSource(Configuration configuration, String script, Class<?> parameterType) {
    //        Matcher matcher = inPattern.matcher(script);
    //        if (matcher.find()) {
    //            StringBuilder sb = new StringBuilder();
    //            sb.append("<set>");
    //
    //            sb.append("<if test=\"name != null \">   name = #{name},</if>");
    //            sb.append("<if test=\"price != null \"> price = #{price},</if>");
    
    
             /*   for (Field field : parameterType.getDeclaredFields()) {
                    String tmp = "<if test=\"_field != null\">_column=#{_field},</if>";
                    sb.append(tmp.replaceAll("_field", field.getName()).replaceAll("_column",
                            CaseFormat.LOWER_CAMEL.to(CaseFormat.LOWER_UNDERSCORE, field.getName())));
                }*/
    
    //            sb.deleteCharAt(sb.lastIndexOf(","));
    //            sb.append("</set>");
    
    //            script = matcher.replaceAll(sb.toString());
    //            script = "<script>" + script + "</script>";
    //        }
    
            return super.createSqlSource(configuration, script, parameterType);
        }
    }

import cn.jhunicom.visitor.miniapp.model.entity.mysql.UserBaseEntity;
    import cn.jhunicom.visitor.miniapp.utils.SimpleSelectInLangDriver;
    import cn.jhunicom.visitor.miniapp.utils.SimpleUpdateLangDriver;
    import org.apache.ibatis.annotations.Lang;
    import org.apache.ibatis.annotations.Param;
    import org.apache.ibatis.annotations.Select;
    import org.apache.ibatis.annotations.Update;
    
    import java.util.List;
    
    public interface UserBaseEntityMapperExt extends UserBaseEntityMapper {
      @Select("SELECT * FROM user_base")
      @Lang(SimpleSelectInLangDriver.class)
      List<UserBaseEntity> selectUserEntity();
    
      @Select("SELECT * FROM user_base  WHERE `name` NOT IN (SELECT name FROM user_base  WHERE id IN (#{idList}))")
      @Lang(SimpleSelectInLangDriver.class)
      List<UserBaseEntity> getUserByIdInBatch(@Param("idList") List<String> idList);
    
      @Update("UPDATE user_base set name = #{name} WHERE id = #{id}")
      @Lang(SimpleUpdateLangDriver.class)
      void updateUsersById(UserBaseEntity userBaseEntity);
    }

## 七、bug记录 ##

### 7.1 in操作的坑 ###

> isIn/isNotIn/isInCaseInsensitive/isInCaseInsensitiveWhenPresent/isNotInCaseInsensitive/isNotInCaseInsensitiveWhenPresent 操作中，如果给的List(获取其他可迭代对象)为空的话，这个条件就不生效了。

*  例如你要进行如下操作

select * from user where id in ("xxx","xxx")

*  mybatis 中写法

List<String> userIds = ...
    List<User> users = userMapper.select(c -> c.where(UserDynamicSqlSupport.id, isIn(userIds)));

*  bug

> 如果userIds 不为空(length = 0)的话，sql 语句是对的，如果userIds为空的话，sql语句就变成`select * from user` 了。÷

[Link 1]: https://links.jianshu.com/go?to=http%3A%2F%2Fmybatis.org%2Fgenerator%2Findex.html