mybatis 映射生成mapper和pojo ---逆向工程的使用过程

1. 使用逆向工程生成mapper和pojo

2. 新建一个项目，随便叫什么

3.导入mybatis-generator-core 、mybatis、mybatis-spring、log4j等jar

 4.在与src目录同级别下生成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>
      <context id="MybatisGenerator" targetRuntime="MyBatis3" >
          <commentGenerator>
          <!-- 是否去除自动生成的注解，true是，false否 -->
              <property name="supressAllComments" value="true"/>
          </commentGenerator>
          <!-- 数据库连接信息： -->
          <jdbcConnection driverClass="com.mysql.jdbc.Driver" 
          connectionURL="jdbc:mysql://localhost:3306/egou" userId="root" password="123456" ></jdbcConnection>
          <!-- 默认值false,把JDBC DECIMAL 和NUMBER类型解析为Integer，为true时 解析为 java.math.BigDecimal -->
          <javaTypeResolver>
              <property name="forceBigDecimals" value="false"/>
          </javaTypeResolver>
          <!-- 生成的po实体类的存放位置 -->
          <javaModelGenerator targetPackage="com.egou.pojo" targetProject=".\src">
              <!-- enableSubPackages:是否让schema作为包的后缀 -->
              <property name="enableSubPackages" value="false"/>
              <!-- 从数据库返回的值为清理前后的空格 -->
              <property name="trimStrings" value="true"/>
          </javaModelGenerator>
          <!-- 生成的mapper映射文件（XML）的存放位置 -->
          <sqlMapGenerator targetPackage="com.egou.mapper" targetProject=".\src">
              <property name="enableSubPackages" value="false"/>
          </sqlMapGenerator>
          <!-- 生成的mapper接口（JAVA文件）的存放位置 -->
          <javaClientGenerator targetPackage="com.egou.mapper" type="XMLMAPPER" targetProject=".\src">
              <property name="enableSubPackages" value="false"/>
          </javaClientGenerator>
          <!-- 指定数据库表 根据表名，有多个表就写多条数据 -->
          <table tableName="tb_content"></table>
          <table tableName="tb_content_category"></table>
          <table tableName="tb_item"></table>
          <table tableName="tb_item_cat"></table>
          <table tableName="tb_item-desc"></table>
          <table tableName="tb_item_param"></table>
          <table tableName="tb_item_param_item"></table>
          <table tableName="tb_order"></table>
          <table tableName="tb_order_item"></table>
          <table tableName="tb_order_shipping"></table>
          <table tableName="tb_user"></table>
      </context>
  </generatorConfiguration>

 

 

 

 

5.新建一个类，随意叫什么

package generatorSqlmapCustom;

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.exception.XMLParserException;
import org.mybatis.generator.internal.DefaultShellCallback;



public class GeneratorSqlmap {
    public void generate() throws Exception {
        List<String> warnings = new ArrayList<String>();
        boolean overwrite =true;
        File configFile = new File("GeneratorConfig.xml");
        System.out.println("--------"+configFile.getAbsolutePath());
        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) {
        GeneratorSqlmap generatorSqlmap = new GeneratorSqlmap();
        try {
            generatorSqlmap.generate();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

6.结果

　　6.1控制台

 　　6.2 多出两个从mysql本地库中生成的包