mybaitis逆向工程实例

逆向工程核心包

mybatis-generator-core-1.3.2-javadoc.jar

mybatis-generator-core-1.3.2-sources.jar

mybatis-generator-core-1.3.2.jar

mysql-connector-java-5.0.8-bin.jar

生成代码配置文件generatorConfig.xml

<?xmlversion="1.0"encoding="UTF-8"?>

<!DOCTYPEgeneratorConfiguration

 PUBLIC"-//mybatis.org//DTD MyBatis GeneratorConfiguration 1.0//EN"

 "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">

 

<generatorConfiguration>

   <contextid="testTables"targetRuntime="MyBatis3">

      <commentGenerator>

          <!--是否去除自动生成的注释 true：是： false:否 -->

          <propertyname="suppressAllComments"value="true"/>

      </commentGenerator>

      <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->

      <jdbcConnectiondriverClass="com.mysql.jdbc.Driver"

          connectionURL="jdbc:mysql://localhost:3306/mybatis?useUnicode=true&amp;characterEncoding=utf-8"

          userId="root"

          password="666666">

      </jdbcConnection>

      <!--<jdbcConnection driverClass="oracle.jdbc.OracleDriver"

          connectionURL="jdbc:oracle:thin:@127.0.0.1:1521: mybatis"

          userId=" mybatis"

          password=" mybatis">

      </jdbcConnection>-->

 

      <!--默认false，把JDBC DECIMAL 和 NUMERIC类型解析为 Integer，为 true时把JDBC DECIMAL和

          NUMERIC 类型解析为java.math.BigDecimal -->

      <javaTypeResolver>

          <propertyname="forceBigDecimals"value="false"/>

      </javaTypeResolver>

 

      <!--targetProject:生成PO类的位置 -->

      <javaModelGeneratortargetPackage="com.mybatis.user.model"

          targetProject=".\src">

          <!--enableSubPackages:是否让schema作为包的后缀 -->

          <propertyname="enableSubPackages"value="false"/>

          <!--从数据库返回的值被清理前后的空格 -->

          <propertyname="trimStrings"value="true"/>

      </javaModelGenerator>

       <!--targetProject:mapper映射文件生成的位置 -->

      <sqlMapGeneratortargetPackage="com.mybatis.user.mapper"

          targetProject=".\src">

          <!--enableSubPackages:是否让schema作为包的后缀 -->

          <propertyname="enableSubPackages"value="false"/>

      </sqlMapGenerator>

      <!--targetPackage：mapper接口生成的位置 -->

      <javaClientGeneratortype="XMLMAPPER"

          targetPackage="com.mybatis.user.mapper"

          targetProject=".\src">

          <!--enableSubPackages:是否让schema作为包的后缀 -->

          <propertyname="enableSubPackages"value="false"/>

      </javaClientGenerator>

      <!--指定数据库表 -->

      <!--<table tableName="cy_mybatis"></table>

      <tabletableName="cy_mybatis"></table>

      <tabletableName="cy_mybatis"></table>

      <tabletableName="cy_mybatis"></table>

      <tabletableName="cy_mybatis"></table>-->

      <tabletableName="cy_user"></table>

      

   </context>

</generatorConfiguration>

 

执行生成程序

publicstaticvoid main(String[]args)throwsInvalidConfigurationException {

     List<String>warnings =newArrayList<String>();

     booleanoverwrite =true;

     //指定逆向工程配置文件

     File configFile =new File("generatorConfig.xml");

     ConfigurationParsercp =new ConfigurationParser(warnings);

     try {

        Configurationconfig =cp.parseConfiguration(configFile);

        DefaultShellCallbackcallback =newDefaultShellCallback(overwrite);

        MyBatisGeneratormyBatisGenerator =newMyBatisGenerator(config,

               callback,warnings);

        myBatisGenerator.generate(null);

     } catch (IOException |XMLParserExceptione) {

        //TODOAuto-generated catch block

        e.printStackTrace();

     } catch (SQLExceptione) {

        //TODOAuto-generated catch block

        e.printStackTrace();

     } catch(InterruptedExceptione) {

        //TODOAuto-generated catch block

        e.printStackTrace();

     }

     

  }