# Mybatis-Generator-Plus

**Repository Path**: lml_1992/Mybatis-Generator-Plus

## Basic Information

- **Project Name**: Mybatis-Generator-Plus
- **Description**: 1.介绍: MyBatis generator plus 基于mybatis-generator-core v.1.3.2 扩展，增加如下主要特性: 1.生成支持Oracle、My
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: https://www.oschina.net/p/mybatis-generator-plus
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2022-05-07
- **Last Updated**: 2022-05-07

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# MyBatis Generator Plus

[![License](http://img.shields.io/:license-apache-brightgreen.svg)](http://www.apache.org/licenses/LICENSE-2.0.html)
[![Build Status](https://travis-ci.org/handosme/mybatis-generator-plus.svg?branch=master)](https://travis-ci.org/handosme/mybatis-generator-plus)
[![Maven Central](https://img.shields.io/maven-central/v/org.apache.maven/apache-maven.svg)](http://search.maven.org/#artifactdetails%7Corg.ihansen.mbp%7Cmybatis-generator-plus%7C1.1%7Cjar)

### 1.介绍:  
MyBatis generator plus 基于mybatis-generator-core v.1.3.2 扩展，增加了以下特性:
1. 生成支持Oracle、Mysql、Sqlserver分页查询的代码:   
```java
//分页查询demo
OperateLogExample relationshipsExample = new OperateLogExample();
relationshipsExample.setPagination(0L,10L);
List<OperateLog> operateLogList = operateLogMapper.selectByExample(relationshipsExample);
```  

2. 生成支持Oracle、Mysql、Sqlserver批量插入的代码:   
```java
//批量插入demo
List<OperateLog> operateLogList = new ArrayList<>();
for (int i = 0; i < 5; i++) {
    OperateLog operateLog = new OperateLog.Builder()
        .action("insertBatch_test"+i)
        .build();
    operateLogList.add(operateLog);
}
operateLogMapper.insertBatch(operateLogList);
```  

3. Model类支持Builder模式创建,示例代码:
```java
User user = new User.Builder()
    .userName("insert_test")
    .creatTime(new Date())
    .updateTime(new Date())
    .build();
```   

4. 支持Oracle使用SEQUENCE实现自增主键:  
*需要建立表主键对应的SEQUENCE,并且SEQUENCE的名称作出了要求:格式为table_name_SEQUENCE*
5. 支持Mapper接口设置数据源schema，可用于分库业务;  
[demo.mapper.ooc.UserVisitLogMapper.DATA_SOURCE_NAME](https://github.com/handosme/mybatis-generator-plus/blob/f9f6b609339bdfbc0ba95fa05aad9c85d8bad7e7/src/test/java/demo/mapper/ooc/UserVisitLogMapper.java#L9)  

6. 针对MySQL下分页大偏移量时慢查询优化`List<Domain> selectByBigOffset(DomainExample example)`;

7. 乐观锁支持`int updateByOptimisticLock(Domain record)`;

### 2.使用方式  
#### 方式一: 配置maven插件生成代码【推荐】  
pom里plugin配置如下：  
```xml
<plugin>
  <groupId>org.ihansen.mbp</groupId>
  <artifactId>mybatis-generator-plus-maven-plugin</artifactId>
  <version>1.4</version>
  <configuration>
    <verbose>true</verbose>
    <overwrite>true</overwrite>
    <configurationFile>tool/mbp/MybatisGeneratorCfg.xml</configurationFile>
  </configuration>
</plugin>
```
供参考的MBP配置文件: 
[MybatisGeneratorCfg.xml](https://github.com/handosme/mybatis-generator-plus/blob/master/src/test/resources/MybatisGeneratorCfg.xml)  
终端运行如下命令，生成自动代码：  
```bash
mvn org.ihansen.mbp:mybatis-generator-plus-maven-plugin:1.4:generate
```

#### 方式二：运行可执行jar文件  
包含运行依赖包的可独立执行jar文件：[mybatis-generator-plus-jar-with-dependencies.jar](https://static-ali.ihansen.org/jar/mbp/mybatis-generator-plus-jar-with-dependencies-1.4.jar)   
供参考的MBP配置文件: 
[MybatisGeneratorCfg.xml](https://github.com/handosme/mybatis-generator-plus/blob/master/src/test/resources/MybatisGeneratorCfg.xml)  
使用如下命令执行即可生成自动文件：
```bash
java -jar mybatis-generator-plus-jar-with-dependencies-1.4.jar -configfile MybatisGeneratorCfg.xml -overwrite
```


#### 方式三：main方法运行
本工具的使用方式和原生的MyBatis generator使用方式一致，兼容原生版本。maven 坐标:
```xml
<dependency>
  <groupId>org.ihansen.mbp</groupId>
  <artifactId>mybatis-generator-plus</artifactId>
  <version>1.4</version>
  <scope>test</scope>
</dependency>
```
生成文件的示例入口: 
[test/demo.MBPMain](https://github.com/handosme/mybatis-generator-plus/blob/master/src/test/java/demo/MBPMain.java)    



### 3.MBP的用户:
[![ihansen.org](http://ihansen.oss-cn-hangzhou.aliyuncs.com/img/ihansen.png)](https://api.ihansen.org/)
[![掌上110](http://ihansen.oss-cn-hangzhou.aliyuncs.com/img/110_6b54392.png)](http://www.lvwan.com/110.html)