Mybatis 代码自动生成(generatorConfig.xml配置)

 博客推荐:

Mybatis最入门---代码自动生成(generatorConfig.xml配置)

MyBatis Generator generatorConfig.xml配置详解

 pom.xml<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

  <modelVersion>4.0.0</modelVersion>
  <groupId>com.watermelon</groupId>
  <artifactId>Simple</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  
  <properties>
      <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  </properties>
  
  <dependencies>
      <!-- https://mvnrepository.com/artifact/junit/junit -->
    <dependency>
        <groupId>junit</groupId>
            <artifactId>junit</artifactId>
        <version>4.12</version>
        <scope>test</scope>
    </dependency>
    
    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.3.0</version>
    </dependency>
    
    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.38</version>
    </dependency>
    
    <!-- https://mvnrepository.com/artifact/org.slf4j/slf4j-api -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>1.7.12</version>
    </dependency>
    
    <!-- https://mvnrepository.com/artifact/org.slf4j/slf4j-log4j12 -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-log4j12</artifactId>
        <version>1.7.12</version>
        <scope>test</scope>
    </dependency>
        
    <!-- https://mvnrepository.com/artifact/log4j/log4j -->
    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.17</version>
    </dependency>
    
    <!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core -->
  <!-- 新增加 -->
<dependency> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-core</artifactId> <version>1.3.3</version> </dependency> </dependencies> <build> <plugins> <plugin> <artifactId>maven-compiler-plugin</artifactId> <configuration> <source>1.6</source> <target>1.6</target> </configuration> </plugin> </plugins> </build> </project>

 

 1.java代码生成的方式

<?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>
    <context id="MySqlContext" targetRuntime="MyBatis3Simple" defaultModelType="flat">
        <property name="beginningDelimiter" value="`"/>
        <property name="endingDelimiter" value="`"/>
        
        <commentGenerator>
            <property name="suppressDate" value="true"/>
            <property name="addRemarkComments" value="true"/>
        </commentGenerator>
        
        <jdbcConnection driverClass="com.mysql.jdbc.Driver" 
                    connectionURL="jdbc:mysql://localhost:3306/simple"
                    userId="root"
                    password="123456">
        </jdbcConnection>
        
        <javaModelGenerator targetPackage="test.model" 
                            targetProject="src\main\java">
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>
        
        <sqlMapGenerator targetPackage="test.xml" 
                        targetProject="src\main\resources">
        </sqlMapGenerator>
        
        <javaClientGenerator type="XMLMAPPER"
                            targetPackage="test.dao" 
                            targetProject="src\main\java">
        </javaClientGenerator>
        
        <table tableName="%">
            <generatedKey column="id" sqlStatement="MySql"/>
        </table>
    </context>
</generatorConfiguration>

 


package
com.watermelon.generator; import java.io.IOException; import java.io.InputStream; import java.util.ArrayList; import java.util.List; import org.mybatis.generator.api.MyBatisGenerator; import org.mybatis.generator.config.Configuration; import org.mybatis.generator.config.xml.ConfigurationParser; import org.mybatis.generator.exception.XMLParserException; import org.mybatis.generator.internal.DefaultShellCallback; public class Generator { public static void main(String[] args) throws Exception, XMLParserException { List<String> warnings = new ArrayList<String>(); boolean overwrite = true; InputStream is = Generator.class.getResourceAsStream("/generator/generatorConfig.xml"); ConfigurationParser cp = new ConfigurationParser(warnings); Configuration config = cp.parseConfiguration(is); is.close(); DefaultShellCallback callback = new DefaultShellCallback(overwrite); MyBatisGenerator mybatisGenerator = new MyBatisGenerator(config, callback, warnings); mybatisGenerator.generate(null); for(String warning:warnings) { System.out.println(warning); } } }

 2.Eclispe插件的方式(推荐使用)

  优点;在所有生成的代码中都会有@mbggenerated 标记(通过MBG生成) 但是不管是maven,还是java main方法的方式运行生成的代码,

  重新生成后都会覆盖中间自己修改的代码。只有Eclispe插件的方式才不会修改。

插件下载地址https://github.com/mybatis/generator/releases

<?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>
    <!-- eclipse生成时必须指定classPathEntry 物理数据库驱动电脑上面可以随意指定一个 -->
    <classPathEntry location="E:\java\jar\mysql\mysql-connector-java-5.1.18-bin.jar"/>
    <context id="MySqlContext" targetRuntime="MyBatis3Simple" defaultModelType="flat">
        <!-- 在关键字名称前后自动拼接` -->
        <property name="beginningDelimiter" value="`"/>
        <property name="endingDelimiter" value="`"/>
        
        <property name="javaFileEncoding" value="UTF-8"/>
        
        <!-- 加注释 ,suppressDate去掉时间-->
        <commentGenerator>
            <property name="suppressDate" value="true"/>
            <property name="addRemarkComments" value="true"/>
        </commentGenerator>
        
        <!-- 配置数据库连接 -->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver" 
                    connectionURL="jdbc:mysql://localhost:3306/simple"
                    userId="root"
                    password="123456">
        </jdbcConnection>
        
        <!-- eclipse插件生成时必须targetProject前加项目名称 -->
        <!-- 生成Model -->
        <javaModelGenerator targetPackage="test.model" 
                            targetProject="Simple\src\main\java">
            <!--去掉多余的空格 
                public void setUserName(String userName) {
                    this.userName = userName == null ? null : userName.trim();
                    } -->
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>
        
        <!-- 生成Mapper xml文件 -->
        <sqlMapGenerator targetPackage="test.xml" 
                        targetProject="Simple\src\main\resources">
        </sqlMapGenerator>
        
        <!-- 生成对应的dao文件 -->
        <javaClientGenerator type="XMLMAPPER"
                            targetPackage="test.dao" 
                            targetProject="Simple\src\main\java">
        </javaClientGenerator>
        
        <!-- tableName 生成的表名“%”多个表 -->
        <table tableName="%">
            <generatedKey column="id" sqlStatement="MySql"/>
        </table>
    </context>
</generatorConfiguration>

 

在配置文件上面单机右键运行。

posted @ 2017-09-26 08:34  watermelonBan  阅读(681)  评论(0编辑  收藏  举报