Question

Mybatis的逆向工程如何使用

Answer 1

1. 是否去除自动生成的注释 true：是 ： false:否
   <property name="suppressAllComments" value="true" />
   
   2. 数据库连接的信息：驱动类、连接地址、用户名、密码
   <jdbcConnection driverClass="com.mysql.jdbc.Driver"
   connectionURL="jdbc:mysql://localhost:3306/heiruan" userId="root"
   password="111">
   </jdbcConnection>
   <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 和
   NUMERIC 类型解析为java.math.BigDecimal -->
   <javaTypeResolver>
   <property name="forceBigDecimals" value="false" />
   </javaTypeResolver>
   
   3. targetProject:生成PO类的位置
   <javaModelGenerator targetPackage="www.ijava.pojo"
   targetProject=".\src">
   <!-- enableSubPackages:是否让schema作为包的后缀 -->
   <property name="enableSubPackages" value="false" />
   <!-- 从数据库返回的值被清理前后的空格 -->
   <property name="trimStrings" value="true" />
   </javaModelGenerator>
   4. targetProject:mapper映射文件生成的位置
   <sqlMapGenerator targetPackage="www.ijava.mapper"
   targetProject=".\src">
   <!-- enableSubPackages:是否让schema作为包的后缀 -->
   <property name="enableSubPackages" value="false" />
   </sqlMapGenerator>
   <!-- targetPackage：mapper接口生成的位置 -->
   <javaClientGenerator type="XMLMAPPER"
   targetPackage="www.ijava.mapper"
   targetProject=".\src">
   <!-- enableSubPackages:是否让schema作为包的后缀 -->
   <property name="enableSubPackages" value="false" />
   </javaClientGenerator>
   5.  指定数据库表
   <table schema="" tableName="tb_content"></table>
   <table schema="" tableName="tb_content_category"></table>
   <table schema="" tableName="tb_item"></table>
   <table schema="" tableName="tb_item_cat"></table>
   <table schema="" tableName="tb_item_desc"></table>
   <table schema="" tableName="tb_item_param"></table>
   <table schema="" tableName="tb_item_param_item"></table>
   <table schema="" tableName="tb_order"></table>
   <table schema="" tableName="tb_order_item"></table>
   <table schema="" tableName="tb_order_shipping"></table>
   <table schema="" tableName="tb_user"></table>

   6.直接远行

2. 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();
   }
   
   }