Reverse Engineering Database Tables to Generate Mapper and Entity Classes (Simple Tool)
Preparation
- Databsae driver for connetcion
- Reverse engineering JAR file
mybatis-generator-core-1.3.2.jar generatorConfig.xmlstart.bat
1. generatorConfig.xml Content
<?xml version="1.0" encoding="UTF-8"?>
<generatorConfiguration>
<!-- Database JDBC driver JAR path, avoid Chinese characters in path -->
<classPathEntry location="gsjdbc4.jar" />
<context id="DB2Tables" targetRuntime="MyBatis3">
<!-- Encoding for generated Java files, prevents garbled characters -->
<property name="javaFileEncoding" value="UTF-8" />
<commentGenerator>
<!-- Suppress generated comments entirely -->
<property name="suppressAllComments" value="true"/>
</commentGenerator>
<!-- Database connection info: driver, URL, username, password -->
<jdbcConnection
driverClass="org.postgresql.Driver"
connectionURL="jdbc:postgresql://192.134.107.80:8000/ccdb"
userId="Cctest_123"
password="cctest">
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false"/>
</javaTypeResolver>
<!-- Entity class generation: package and project path -->
<javaModelGenerator targetPackage="po" targetProject="P:\documents\reverse-engineering-tool\mybatis-generator_for_cgb\" >
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- SQL mapper XML generation -->
<sqlMapGenerator targetPackage="dao" targetProject="P:\documents\reverse-engineering-tool\mybatis-generator_for_cgb\" >
<property name="enableSubPackages" value="false" />
</sqlMapGenerator>
<!-- Mapper interface generation -->
<javaClientGenerator targetPackage="dao" targetProject="P:\documents\reverse-engineering-tool\mybatis-generator_for_cgb\" type="XMLMAPPER">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<!-- Table configuration: specify which tables to generate code for -->
</context>
</generatorConfiguration>
2. start.bat Content
cd "P:\documents\reverse-engineering-tool\mybatis-generator_for_cgb"
java -jar mybatis-generator-core-1.3.2.jar -configfile generatorConfig.xml -overwrite
3. Execution
After preparing the files, simply double-click start.bat to generate the code into the po and dao directories.
