Mybatis逆向工程生成

generatorConfig.xml

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE generatorConfiguration
 3         PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
 4         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
 5 
 6 <generatorConfiguration>
 7     <context id="testTables" targetRuntime="MyBatis3">
 8         <commentGenerator>
 9             <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
10             <property name="suppressAllComments" value="true" />
11         </commentGenerator>
12         <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->
13         <jdbcConnection driverClass="com.mysql.jdbc.Driver"
14                         connectionURL="jdbc:mysql://localhost:3306/suibian" userId="root"
15                         password="ycz123456">
16         </jdbcConnection>
17         <!-- <jdbcConnection driverClass="oracle.jdbc.OracleDriver"
18                 connectionURL="jdbc:oracle:thin:@127.0.0.1:1521:yycg"
19                 userId="yycg"
20                 password="yycg">
21         </jdbcConnection> -->
22 
23         <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL和NUMERIC类型解析为java.math.BigDecimal -->
24         <javaTypeResolver>
25             <property name="forceBigDecimals" value="false" />
26         </javaTypeResolver>
27 
28         <!-- targetProject:生成PO类的位置，重要！！ -->
29         <javaModelGenerator targetPackage="mybatis.po"
30                             targetProject=".\src">
31             <!-- enableSubPackages:是否让schema作为包的后缀 -->
32             <property name="enableSubPackages" value="false" />
33             <!-- 从数据库返回的值被清理前后的空格 -->
34             <property name="trimStrings" value="true" />
35         </javaModelGenerator>
36         <!-- targetProject:mapper映射文件生成的位置，重要！！ -->
37         <sqlMapGenerator targetPackage="mybatis.mapper"
38                          targetProject=".\src">
39             <property name="enableSubPackages" value="false" />
40         </sqlMapGenerator>
41         <!-- targetPackage：mapper接口生成的位置，重要！！ -->
42         <javaClientGenerator type="XMLMAPPER"
43                              targetPackage="mybatis.mapper"
44                              targetProject=".\src">
45             <property name="enableSubPackages" value="false" />
46         </javaClientGenerator>
47         <!-- 指定数据库表，要生成哪些表，就写哪些表，要和数据库中对应，不能写错！ -->
48         <table tableName="user"></table>
49     </context>
50 </generatorConfiguration>

启动类：注意包名

package generator;

import java.io.File;
import java.io.IOException;
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.internal.DefaultShellCallback;

public class GeneratorSqlmap {

    public void generator() throws Exception{

        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);

    }
    public static void main(String[] args) throws Exception {
        try {
            GeneratorSqlmap generatorSqlmap = new GeneratorSqlmap();
            generatorSqlmap.generator();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

}

PS:generatorConfig.xml放在与src同级目录；根据启动类里的文件路径可以改。

posted @ 2018-11-01 15:35  hyczzz  阅读(181)  评论(0)  编辑  收藏  举报