美文网首页
2019-12-27 mybatis itfsw 批量修改更

2019-12-27 mybatis itfsw 批量修改更

作者: ForestPei | 来源:发表于2019-12-27 18:37 被阅读0次

1. pom.xml 引入jar;

        <dependency>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-core</artifactId>
            <version>1.3.6</version>
        </dependency>
    <dependency>
            <groupId>com.itfsw</groupId>
            <artifactId>mybatis-generator-plugin</artifactId>
            <version>1.3.8</version>
    </dependency> 

2. generatorConfig.xml 加入生成批量方法的依赖;

<!-- 批量插入插件 -->
        <plugin type="com.itfsw.mybatis.generator.plugins.BatchInsertPlugin">
            <!--
            开启后可以实现官方插件根据属性是否为空决定是否插入该字段功能
            !需开启allowMultiQueries=true多条sql提交操作,所以不建议使用!插件默认不开启
            -->
            <property name="allowMultiQueries" value="false"/>
        </plugin>

        <!-- 数据Model属性对应Column获取插件 -->
        <plugin type="com.itfsw.mybatis.generator.plugins.ModelColumnPlugin"/>

        <!-- BatchInsertPlugin, ModelColumnPlugin 两者都需要添加才可以 -->

        <!-- 存在即更新插件 -->
        <plugin type="com.itfsw.mybatis.generator.plugins.UpsertPlugin">
            <!--
            支持upsertByExample,upsertByExampleSelective操作
            !需开启allowMultiQueries=true多条sql提交操作,所以不建议使用!插件默认不开启
            -->
            <property name="allowMultiQueries" value="false"/>
            <!--
            开启批量功能,支持batchUpsert,batchUpsertWithBLOBs,batchUpserSelective
            !这几个方法中无法支持IncrementsPlugin的方法!插件默认不开启
            -->
            <property name="allowBatchUpsert" value="true"/>
        </plugin>

3. 生成批量方法;

/**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table tx_internal_record
     *
     * @mbg.generated
     */
    int batchInsert(@Param("list") List<TxInternalRecord> list);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table tx_internal_record
     *
     * @mbg.generated
     */
    int batchInsertSelective(@Param("list") List<TxInternalRecord> list, @Param("selective") TxInternalRecord.Column ... selective);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table tx_internal_record
     *
     * @mbg.generated
     */
    int upsert(TxInternalRecord record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table tx_internal_record
     *
     * @mbg.generated
     */
    int upsertSelective(TxInternalRecord record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table tx_internal_record
     *
     * @mbg.generated
     */
    int batchUpsert(@Param("list") List<TxInternalRecord> list);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table tx_internal_record
     *
     * @mbg.generated
     */
    int batchUpsertSelective(@Param("list") List<TxInternalRecord> list, @Param("selective") TxInternalRecord.Column ... selective);

4. 参考 https://github.com/itfsw/mybatis-generator-plugin

相关文章

网友评论

      本文标题:2019-12-27 mybatis itfsw 批量修改更

      本文链接:https://www.haomeiwen.com/subject/alndoctx.html