建立数据模型pdm,表结构前缀说明
- cms_*:内容管理模块相关表
- oms_*:订单管理模块相关表
- pms_*:商品模块相关表
- sms_*:营销模块相关表
- ums_*:会员模块相关表
新建pom工程如下:
1.pom文件内容如下:
<dependencies>
<!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core -->
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger2</artifactId>
</dependency>
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger-ui</artifactId>
</dependency>
2.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>
<properties resource="generator.properties" />
<context id="MySqlContext" targetRuntime="MyBatis3"
defaultModelType="flat">
<property name="beginningDelimiter" value="`" />
<property name="endingDelimiter" value="`" />
<property name="javaFileEncoding" value="UTF-8" />
<!-- 为模型生成序列化方法 -->
<plugin type="org.mybatis.generator.plugins.SerializablePlugin" />
<!-- 为生成的Java模型创建一个toString方法 -->
<plugin type="org.mybatis.generator.plugins.ToStringPlugin" />
<!--生成mapper.xml时覆盖原文件 -->
<plugin type="org.mybatis.generator.plugins.UnmergeableXmlMappersPlugin" />
<!-- CommentGenerator这里主要是对数据库操作的处理 -->
<commentGenerator type="com.infosys.china.CommentGenerator">
<!-- 是否去除自动生成的注释 true:是 : false:否 -->
<property name="suppressAllComments" value="true" />
<property name="suppressDate" value="true" />
<property name="addRemarkComments" value="true" />
</commentGenerator>
<jdbcConnection driverClass="${jdbc.driverClass}"
connectionURL="${jdbc.connectionURL}" userId="${jdbc.userId}"
password="${jdbc.password}">
<!--解决mysql驱动升级到8.0后不生成指定数据库代码的问题 -->
<property name="nullCatalogMeansCurrent" value="true" />
</jdbcConnection>
<!-- targetProject这里建议用绝对路径存放,以免存在子父工程会报错 -->
<javaModelGenerator targetPackage="com.infosys.mail.model"
targetProject="G:\Documents\GitHub\mall\mail-dbmodel\src\main\java" />
<!-- targetProject这里建议用绝对路径存放,以免存在子父工程会报错 -->
<sqlMapGenerator targetPackage="com.infosys.mail.mapper"
targetProject="G:\Documents\GitHub\mall\mail-dbmodel\src\main\resources" />
<javaClientGenerator type="XMLMAPPER"
targetPackage="com.infosys.mail.mapper" targetProject="G:\Documents\GitHub\mall\mail-dbmodel\src\main\java" />
<!--生成全部表tableName设为% -->
<table tableNa