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);
网友评论