mybatis-generator插件使用 批量插入、更新

1、

<dependency>
    <groupId>org.mybatis.generator</groupId>
    <artifactId>mybatis-generator-core</artifactId>
    <version>1.3.2</version>
</dependency>

2、

<plugin>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
<plugin>
   <groupId>org.mybatis.generator</groupId>
   <artifactId>mybatis-generator-maven-plugin</artifactId>
   <version>1.3.5</version>
   <dependencies>
      <dependency>
         <groupId> mysql</groupId>
         <artifactId> mysql-connector-java</artifactId>
         <version> 5.1.39</version>
      </dependency>
      <dependency>
         <groupId>org.mybatis.generator</groupId>
         <artifactId>mybatis-generator-core</artifactId>
         <version>1.3.5</version>
      </dependency>
   </dependencies>
   <executions>
      <execution>
         <id>Generate MyBatis Artifacts</id>
         <phase>package</phase>
         <goals>
            <goal>generate</goal>
         </goals>
      </execution>
   </executions>
   <configuration>
      <!--允许移动生成的文件 -->
      <verbose>true</verbose>
      <!-- 是否覆盖 -->
      <overwrite>true</overwrite>
      <!-- 自动生成的配置 -->
      <configurationFile>
         src/main/resources/mybatis-generator.xml</configurationFile>
   </configuration>
</plugin>

3、配置执行命令

4、

mybatis-generator:generate -e

 

 

MyBatis Generator 批量插入插件

 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

<!-- mybatis-generator 自动代码插件 --> <plugin> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-maven-plugin</artifactId> <version>1.3.5</version> <configuration> <!-- 配置文件 --> <configurationFile>src/main/resources/mybatis-generator.xml</configurationFile> <!-- 允许移动和修改 --> <verbose>true</verbose> <overwrite>true</overwrite> </configuration> <dependencies> <!-- jdbc 依赖 --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.40</version> </dependency> <dependency> <groupId>com.itfsw</groupId> <artifactId>mybatis-generator-plugin</artifactId> <version>1.0.5</version> </dependency> </dependencies> </plugin>

 

二、mybatis-generator.xml配置文件中增加插件配置；

 

 

1 2	<!-- 批量插入插件 --> <plugin type="com.itfsw.mybatis.generator.plugins.BatchInsertPlugin"/>

 

三、具体使用；

 

 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

public class Test {     public static void main(String[] args) {         // 构建插入数据         List<Tb> list = new ArrayList<>();         list.add(                 new Tb.Builder()                 .field1(0)                 .field2("xx0")                 .field3(0)                 .createTime(new Date())                 .build()         );         list.add(                 new Tb.Builder()                 .field1(1)                 .field2("xx1")                 .field3(1)                 .createTime(new Date())                 .build()         );         // 普通插入，插入所有列         this.tbMapper.batchInsert(list);         // !!!下面按需插入指定列（类似于insertSelective），需要数据Model属性对应Column获取插件（ModelColumnPlugin）插件         this.tbMapper.batchInsert(list, Tb.Column.field1, Tb.Column.field2, Tb.Column.field3, Tb.Column.createTime);     } }   批量更新<plugin type="cc.bandaotixi.plugins.BatchUpdatePlugin"></plugin>