pom.xml
依赖如下:
<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><parent><groupId>com.chanshiyu</groupId><artifactId>moemall</artifactId><version>1.0.0-SNAPSHOT</version><relativePath>../pom.xml</relativePath></parent><artifactId>moemall-mbg</artifactId><version>1.0.0-SNAPSHOT</version><packaging>jar</packaging><name>Moe Mall MBG</name><description>Moe Mall MBG</description><properties><!-- Commons Settings --><mysql.version>8.0.17</mysql.version><tk-mybatis.version>2.1.5</tk-mybatis.version><tk-mybatis-mapper.version>4.1.5</tk-mybatis-mapper.version><pagehelper.version>1.2.12</pagehelper.version></properties><dependencies><!-- Mysql数据库驱动 --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>${mysql.version}</version></dependency><!-- Mybatis --><dependency><groupId>tk.mybatis</groupId><artifactId>mapper-spring-boot-starter</artifactId><version>${tk-mybatis.version}</version></dependency><!-- 通用mapper --><dependency><groupId>tk.mybatis</groupId><artifactId>mapper</artifactId><version>${tk-mybatis-mapper.version}</version></dependency><!-- MyBatis分页插件 --><dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper-spring-boot-starter</artifactId><version>${pagehelper.version}</version></dependency></dependencies><build><plugins><plugin><groupId>org.mybatis.generator</groupId><artifactId>mybatis-generator-maven-plugin</artifactId><version>1.3.7</version><configuration><configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile><overwrite>true</overwrite><verbose>true</verbose></configuration><dependencies><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>${mysql.version}</version></dependency><dependency><groupId>tk.mybatis</groupId><artifactId>mapper</artifactId><version>${tk-mybatis-mapper.version}</version></dependency></dependencies></plugin></plugins></build></project>
resources/generator/generatorConfig.xml
文件如下:
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE generatorConfigurationPUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN""http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"><generatorConfiguration><!-- 引入数据库连接配置 --><properties resource="generator/jdbc.properties"/><context id="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat"><property name="beginningDelimiter" value="`"/><property name="endingDelimiter" value="`"/><property name="javaFileEncoding" value="UTF-8"/><!-- 自带插件,实体类序列化 --><plugin type="org.mybatis.generator.plugins.SerializablePlugin"/><!-- 配置 tk.mybatis 插件 --><plugin type="tk.mybatis.mapper.generator.MapperPlugin"><property name="mappers" value="tk.mybatis.mapper.MyMapper"/><property name="caseSensitive" value="true"/><property name="lombok" value="Data"/><property name="swagger" value="true"/></plugin><!-- 配置数据库连接 --><jdbcConnection driverClass="${jdbc.driverClass}"connectionURL="${jdbc.connectionURL}"userId="${jdbc.username}"password="${jdbc.password}"><!--解决mysql驱动升级到8.0后不生成指定数据库代码的问题--><property name="nullCatalogMeansCurrent" value="true" /></jdbcConnection><!-- 配置实体类存放路径 --><javaModelGenerator targetPackage="com.chanshiyu.moemall.mbg.model" targetProject="src/main/java"/><!-- 配置 XML 存放路径 --><sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"/><!-- 配置 DAO 存放路径 --><javaClientGenerator targetPackage="com.chanshiyu.moemall.mbg.mapper"targetProject="src/main/java"type="XMLMAPPER"/><!-- 配置需要指定生成的数据表,% 代表所有表 --><table tableName="%"><!-- mysql 配置 --><generatedKey column="id" sqlStatement="Mysql" identity="true"/></table></context></generatorConfiguration>
resources/generator/jdbc.properties
文件如下:
jdbc.driverClass=com.mysql.cj.jdbc.Driverjdbc.connectionURL=jdbc:mysql://192.168.205.4:3306/moemall?nullCatalogMeansCurrent=truejdbc.username=rootjdbc.password=123456