mybatis generator生成持久层代码

忘是亡心i 2022-03-31 07:20 268阅读 0赞

## mybatis generator的获取方式 ##

mybatis generator jar包下载地址：  
[http://repo1.maven.org/maven2/org/mybatis/generator/mybatis-generator-core/][http_repo1.maven.org_maven2_org_mybatis_generator_mybatis-generator-core]

官网地址：[http://mybatis.org/generator/][http_mybatis.org_generator]

github托管地址：[https://github.com/mybatis/generator][https_github.com_mybatis_generator]

在maven中导入mybatis generator：

<dependency>    
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-core</artifactId>     <version>1.3.2</version>
            <type>jar</type>
            <scope>test</scope>
        </dependency>
     
      
       1
       2
       3
       4
       5
       6

## 配置文件的设置 ##

`generatorConfig.xml`示例：

<?xml version="1.0" encoding="UTF-8"?>
        <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
        <generatorConfiguration>
        <classPathEntry location="/Users/dushenzhi/.m2/repository/mysql/mysql-connector-java/5.1.32/mysql-connector-java-5.1.32.jar"/>
        <context id="MysqlContext" targetRuntime="MyBatis3" defaultModelType="flat">
            <property name="beginningDelimiter" value="`"/>
            <property name="endingDelimiter" value="`"/>
    
            <commentGenerator>
                <property name="suppressDate" value="true"/>
            </commentGenerator>
    
            <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/test" userId="root" password="xxxx">
            </jdbcConnection>
    
            <javaModelGenerator targetPackage="test.model" targetProject="mofang/impl/src/test/java">
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
    
            <sqlMapGenerator targetPackage="test.xml" targetProject="mofang/impl/src/test/resources"/>
    
            <javaClientGenerator type="XMLMAPPER" targetPackage="test.dao" targetProject="mofang/impl/src/test/java"/>
    
            <table tableName="%">
                <generatedKey column="id" sqlStatement="Mysql"/>
            </table>
        </context>
        </generatorConfiguration>
     
      
       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
       27
       28
       29
       30
       31
       32
       33
       34

generatorConfig.xml更多使用可以参考：[http://blog.csdn.net/isea533/article/details/42102297][http_blog.csdn.net_isea533_article_details_42102297]以及官方网站

## mybatis generator的使用方法 ##

*  在命令行中执行：

java -jar mybatis-generator-core-1.3.2.jar -configfile ./generatorConfig.xml -overwrite
     
      
       1

*  在Java中调用：

List<String> warnings = new ArrayList<String>();
        boolean overwrite = true;
        File configFile = new File("generatorConfig.xml");
        ConfigurationParser cp = new ConfigurationParser(warnings);
        Configuration config = cp.parseConfiguration(configFile);
        DefaultShellCallback callback = new DefaultShellCallback(overwrite);
        MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
        myBatisGenerator.generate(null);
     
      
       1
       2
       3
       4
       5
       6
       7
       8

*  maven插件的方式：

<plugin>
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-maven-plugin</artifactId>
        <version>1.3.2</version>
        <configuration>
            <configurationFile>src/main/resources/mybatis-generator/generatorConfig.xml</configurationFile>
            <verbose>true</verbose>
            <overwrite>true</overwrite>
        </configuration>
        <executions>
            <execution>
                <id>Generate MyBatis Artifacts</id>
                <goals>
                    <goal>generate</goal>
                </goals>
            </execution>
        </executions>
        <dependencies>
            <dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-core</artifactId>
                <version>1.3.2</version>
            </dependency>
        </dependencies>
    </plugin>
     
      
       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

## 其他 ##

mybatis generator生成的代码不支持分页，关于limit分页可参考：[http://www.360doc.com/content/14/0321/08/11298474\_362356724.shtml][http_www.360doc.com_content_14_0321_08_11298474_362356724.shtml]

中文帮助文档：[http://mbg.cndocs.tk/index.html][http_mbg.cndocs.tk_index.html]

[http_repo1.maven.org_maven2_org_mybatis_generator_mybatis-generator-core]: http://repo1.maven.org/maven2/org/mybatis/generator/mybatis-generator-core/
[http_mybatis.org_generator]: http://mybatis.org/generator/
[https_github.com_mybatis_generator]: https://github.com/mybatis/generator
[http_blog.csdn.net_isea533_article_details_42102297]: http://blog.csdn.net/isea533/article/details/42102297
[http_www.360doc.com_content_14_0321_08_11298474_362356724.shtml]: http://www.360doc.com/content/14/0321/08/11298474_362356724.shtml
[http_mbg.cndocs.tk_index.html]: http://mbg.cndocs.tk/index.html