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同级目录;根据启动类里的文件路径可以改。