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

Mybatis generator 1.4.x 入门教程

一、前言

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

二、官方文档地址

官方文档地址

三、集成 mybatis Generator 1.4.0

pom文件

 

<!-- dependencies 依赖 -->
<dependencies>
  ...
  <!-- 这里需要引入 动态sql相关的包-->
  <!-- https://mvnrepository.com/artifact/org.mybatis.dynamic-sql/mybatis-dynamic-sql -->
  <dependency>
    <groupId>org.mybatis.dynamic-sql</groupId>
    <artifactId>mybatis-dynamic-sql</artifactId>
    <version>1.1.4</version>
  </dependency>
</dependencies>     

<!-- build 相关配置 -->
<build>
<plugins>
...
<!--mybatis自动生成代码-->
  <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">
<!--配置参考 http://mybatis.org/generator/configreference/xmlconfig.html-->
<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>
            <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
            <property name="suppressAllComments" value="true"/>
        </commentGenerator>
        <!--数据库连接的信息：驱动类、连接地址、用户名、密码,这里配置的是mysql的，当然也可以配置oracle等数据库 -->
        <jdbcConnection driverClass="${jdbc.driver}"
                        connectionURL="${jdbc.url}"                                                        userId="${jdbc.username}" 
                        password="${jdbc.password}">
        </jdbcConnection>

        <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL和 NUMERIC 类型解析为java.math.BigDecimal -->
        <javaTypeResolver>
            <property name="forceBigDecimals" value="false"/>
        </javaTypeResolver>

        <!-- targetProject:生成PO类的位置 -->
        <javaModelGenerator targetPackage="com.xxx.entity"       targetProject="src/main/java">
            <!-- enableSubPackages:是否让schema作为包的后缀 -->
            <property name="enableSubPackages" value="true"/>
            <!-- 从数据库返回的值被清理前后的空格 -->
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>
        <!-- targetPackage：mapper接口生成的位置 -->
        <javaClientGenerator type="XMLMAPPER"                               targetPackage="com.xxx.mapper"
                             targetProject="src/main/java">
            <!-- enableSubPackages:是否让schema作为包的后缀 -->
            <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 查询条件

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

六、自定义查询

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语句该类主要用作select
 */
public class SimpleSelectInLangDriver extends XMLLanguageDriver implements LanguageDriver {

    private static final Pattern inPattern = Pattern.compile("\\(#\\{(\\w+)\\}\\)");

    @Override
    public SqlSource createSqlSource(Configuration configuration, String script, Class<?> parameterType) {

        Matcher matcher = inPattern.matcher(script);
        if (matcher.find()) {
            script = matcher.replaceAll("<foreach collection=\"$1\" item=\"_item\" open=\"(\" "
                    + "separator=\",\" close=\")\" >#{_item}</foreach>");
        }

        script = "<script>" + script + "</script>";
        return super.createSqlSource(configuration, script, parameterType);
    }
}

 

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 了。÷