Mybatis-Plus映射实现过程（附赠代码）

1.需要建立maven项目，导入jar包

  <dependencies>
    <!--mybatis-plus依赖jar包-->
    <dependency>
      <groupId>com.baomidou</groupId>
      <artifactId>mybatis-plus</artifactId>
      <version>3.0.4</version>
    </dependency>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter</artifactId>
      <version>2.0.5.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-test</artifactId>
      <version>2.0.5.RELEASE</version>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>org.apache.velocity</groupId>
      <artifactId>velocity-engine-core</artifactId>
      <version>2.0</version>
    </dependency>
    <dependency>
      <groupId>com.baomidou</groupId>
      <artifactId>mybatis-plus-boot-starter</artifactId>
      <version>3.0.4</version>
    </dependency>
    <dependency>
      <groupId>com.h2database</groupId>
      <artifactId>h2</artifactId>
      <version>1.4.200</version>
      <scope>runtime</scope>
    </dependency>
    <!--Lombok用于生成日志-->
    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.16.22</version>
    </dependency>
    <!-- 引入数据源包 -->
    <dependency>
      <groupId>commons-dbcp</groupId>
      <artifactId>commons-dbcp</artifactId>
      <version>1.2.2</version>
    </dependency>
    <!-- 连接池 -->
    <dependency>
      <groupId>commons-pool</groupId>
      <artifactId>commons-pool</artifactId>
      <version>1.5.4</version>
    </dependency>

    <!-- 引入mysql驱动 -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.48</version>
    </dependency>

    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>servlet-api</artifactId>
      <version>2.5</version>
      <!-- scope:compile,test,provided,system,runtime -->
      <scope>provided</scope>
    </dependency>
    <!-- jstl的依赖 -->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>

    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
  </dependencies>

文件项目架构

2.配置文件详解

mp.outputDir=E:/project/untitled1//映射生成位置
mp.author=cxl//映射作者
mp.driver=com.mysql.jdbc.Driver
mp.url=jdbc:mysql://localhost:3306/demo?serverTimezone=UTC&useSSL=false
mp.username=root
mp.password=root
mp.tableName=info//需要映射的数据表
mp.parent=src//项目根目录
mp.moduleName=main//项目主文件夹——生成模块

3.映射工具

public class CodeGenerator {
    public static void main(String args[]) {
        //获取配置文件内容
        ResourceBundle resourceBundle = ResourceBundle.getBundle("mybatis-plus");
        AutoGenerator autoGenerator = new AutoGenerator();

        //全局配置
        GlobalConfig globalConfig = new GlobalConfig();
        globalConfig.setOutputDir(resourceBundle.getString("mp.outputDir"));//输出目录
        globalConfig.setFileOverride(true);//是否覆盖
        globalConfig.setActiveRecord(true);//开启 activeRecord 模式
        globalConfig.setEnableCache(false);//XML 二级缓存
        globalConfig.setBaseResultMap(true);//XML ResultMap
        globalConfig.setBaseColumnList(false);//XML columnList
        globalConfig.setAuthor(resourceBundle.getString("mp.author"));//作者
        // 自定义文件命名，%s会自动填充表实体属性
        //globalConfig.setMapperName("%sMapper");
        //globalConfig.setXmlName("%sMapper");
        globalConfig.setServiceName("%sService");

        //globalConfig.setServiceImplName("%sServiceImpl");
        //globalConfig.setControllerName("%sController");
        globalConfig.setDateType(DateType.ONLY_DATE);
        globalConfig.setSwagger2(true);//实体属性 Swagger2 注释
        autoGenerator.setGlobalConfig(globalConfig);

        //数据源配置
        DataSourceConfig dataSourceConfig = new DataSourceConfig();
        dataSourceConfig.setDbType(DbType.MYSQL);//选择自己的数据源 DbType.ORACLE 等
        dataSourceConfig.setDriverName(resourceBundle.getString("mp.driver"));
        dataSourceConfig.setUsername(resourceBundle.getString("mp.username"));
        dataSourceConfig.setPassword(resourceBundle.getString("mp.password"));
        dataSourceConfig.setUrl(resourceBundle.getString("mp.url"));
        dataSourceConfig.setTypeConvert(new MySqlTypeConvert() {
            @Override
            public IColumnType processTypeConvert(GlobalConfig global, String fieldType) {
                if (fieldType.toLowerCase().contains("blob")) {
                    return DbColumnType.OBJECT;
                } else if (fieldType.toLowerCase().contains("clob")) {
                    return DbColumnType.STRING;
                }
                return super.processTypeConvert(global, fieldType);
            }
        });
        autoGenerator.setDataSource(dataSourceConfig);

        //策略配置
        StrategyConfig strategyConfig = new StrategyConfig();
        //strategyConfig.setTablePrefix(new String[]{"bb","zz"});//表名前缀，生成实体类时忽略前缀只根据表名生成
        strategyConfig.setNaming(NamingStrategy.underline_to_camel);//表名生成策略，驼峰
        String[] tableNames=resourceBundle.getString("mp.tableName").split(",");//
        strategyConfig.setInclude(tableNames);//需要生成的表
        autoGenerator.setStrategy(strategyConfig);

        //包配置
        PackageConfig packageConfig = new PackageConfig();
        packageConfig.setParent(resourceBundle.getString("mp.parent"));//自定义包路径
        packageConfig.setModuleName(resourceBundle.getString("mp.moduleName"));//模块名称
        packageConfig.setController("java.test.controller");//控制器包名，默认web
        packageConfig.setEntity("java.com.test.entity");//创建生成位置
        packageConfig.setMapper("java.com.test.mapper");
        packageConfig.setService("java.com.test.service");
        packageConfig.setServiceImpl("java.com.test.service.impl");
        packageConfig.setXml("resources.mapper");//创建mapper位置
        autoGenerator.setPackageInfo(packageConfig);

        //执行生成
        autoGenerator.execute();

    }
}

4.执行结果。

5.总结

初次使用mybatis映射机制，很好用。文件生成后对于单表操作的SQL是可以直接调用的，不在xml文件中显示。

附赠代码：https://download.csdn.net/download/LieYingZhiYan/12534833