mybatis逆向工程

短命女 2022-05-08 00:26 322阅读 0赞

方式：

编写：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="C:\\Users\\Administrator\\.m2\\repository\\mysql\\mysql-connector-java\\5.1.21\\mysql-connector-java-5.1.21.jar"/>  
    <context id="DB2Tables"  targetRuntime="MyBatis3">  
        <commentGenerator>  
            <property name="suppressDate" value="true"/>  
              
            <property name="suppressAllComments" value="true"/>  
        </commentGenerator>  
          
        <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://192.168.1.15:3306/ruihui" userId="root" password="123456">  
        </jdbcConnection>  
        <javaTypeResolver>  
            <property name="forceBigDecimals" value="false"/>  
        </javaTypeResolver>  
          
        <javaModelGenerator targetPackage="com.ruihui.user.pojo" targetProject="src/main/java">  
            <property name="enableSubPackages" value="true"/>  
            <property name="trimStrings" value="true"/>  
        </javaModelGenerator>  
          
        <sqlMapGenerator targetPackage="mybatis.mapper" targetProject="src/main/resources">  
            <property name="enableSubPackages" value="true"/>  
        </sqlMapGenerator>  
          
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.ruihui.user.mapper" targetProject="src/main/java">  
            <property name="enableSubPackages" value="true"/>  
        </javaClientGenerator>  
          
        <table tableName="ruihui\_member" domainObjectName="User" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>  
    </context>  
</generatorConfiguration>  
执行：run as——maven build或者编写执行类testsql.java

@org.junit.Test  
        public void tests() \{  
            try \{

List<String> warnings = new ArrayList<String>();  
                boolean overwrite = true;  
                File configFile = new File("src/main/resources/mbg.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);

\} catch (Exception e) \{  
                e.printStackTrace();  
            \} finally \{

\}  
        \}