/mybatis-generator-mysql-plugin

A MyBatis Generator plugin for MySQL.

Primary LanguageJava

Running with Maven

pom.xml

<pluginRepositories>
    <pluginRepository>
        <id>xxg-repository</id>
        <url>http://repo.maven.xxgblog.com/</url>
    </pluginRepository>
</pluginRepositories>

<build>
    <plugins>
        <plugin>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-maven-plugin</artifactId>
            <version>1.3.2</version>
            <dependencies>
                <dependency>
                    <groupId>mysql</groupId>
                    <artifactId>mysql-connector-java</artifactId>
                    <version>5.1.34</version>
                </dependency>
                <dependency>
                    <groupId>com.xxg</groupId>
                    <artifactId>mbg-mysql-plugin</artifactId>
                    <version>1.0.1</version>
                </dependency>
            </dependencies>
            <configuration>
                <overwrite>true</overwrite>
            </configuration>
        </plugin>
    </plugins>
</build>

Run mvn mybatis-generator:generator to generate java and xml files.

Plugins

MySQLLimitPlugin

A MyBatis Generator plugin for MySQL pagination use limit.

http://xxgblog.com/2016/05/06/mybatis-generator-mysql-pagination/

Usage

Add the plugin <plugin type="com.xxg.mybatis.plugins.MySQLLimitPlugin"></plugin> into MyBatis Generator configuration file.

<generatorConfiguration>
    <context id="mysqlgenerator" targetRuntime="MyBatis3">
        <plugin type="com.xxg.mybatis.plugins.MySQLLimitPlugin"></plugin>
        ...
    </context>
</generatorConfiguration>

Using the Generated Objects

XxxExample example = new XxxExample();
...
example.setLimit(10); // page size limit
example.setOffset(20); // offset
List<Xxx> list = xxxMapper.selectByExample(example);

The SQL will be: select ... limit 20, 10

XxxExample example = new XxxExample();
...
example.setLimit(10); // limit
List<Xxx> list = xxxMapper.selectByExample(example);

The SQL will be: select ... limit 10

MySQLReplacePlugin

A MyBatis Generator plugin for MySQL replace syntax.

Usage

Add the plugin <plugin type="com.xxg.mybatis.plugins.MySQLReplacePlugin"></plugin> into MyBatis Generator configuration file.

<generatorConfiguration>
    <context id="mysqlgenerator" targetRuntime="MyBatis3">
        <plugin type="com.xxg.mybatis.plugins.MySQLReplacePlugin"></plugin>
        ...
    </context>
</generatorConfiguration>

Using the Generated Objects

xxxMapper.replace(record);
xxxMapper.replaceSelective(record);

The SQL will be: replace into tableName (column1, column2, ...) values (value1, value2, ...)