1、新建一个项目
项目完整代码:
链接: https://pan.baidu.com/s/1uqFOjb2hRPYXKsJfBkQivA
提取码: 7wxg
选择next
新建项目完成
2、在resources文件下新建文件夹generator,导入两个文件
此文件下载
链接: https://pan.baidu.com/s/1YSl8eAx_ow1lw0F_Undj9Q
提取码: hua4
xml文件改成自己的数据库和配置需生成的表
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>
<!--此文件用于从数据库表结构,自动生成model,自动生成基础CURD的mapper代码 mvn mybatis-generator:generate-->
<!--<properties resource="./generator/generatorConfig.properties"/>-->
<!-- 数据库驱动包位置,使用maven的方法,这个就不用了 -->
<context id="MYSQLTables" targetRuntime="MyBatis3" defaultModelType="flat">
<!-- 生成的Java文件的编码 -->
<property name="javaFileEncoding" value="UTF-8"/>
<!-- 格式化java代码 -->
<property name="javaFormatter" value="org.mybatis.generator.api.dom.DefaultJavaFormatter"/>
<!-- 格式化XML代码 -->
<property name="xmlFormatter" value="org.mybatis.generator.api.dom.DefaultXmlFormatter"/>
<!--对于单表的分页实现limit offset-->
<!--<plugin type="com.xxg.mybatis.plugins.MySQLLimitPlugin"></plugin>-->
<plugin type="org.mybatis.generator.plugins.RowBoundsPlugin"></plugin>
<commentGenerator>
<property name="suppressAllComments" value="true" />
</commentGenerator>
<!-- 数据库链接URL、用户名、密码 -->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/d2?useUnicode=true&characterEncoding=utf8&autoReconnect=true"
userId="root"
password="123456">
</jdbcConnection>
<javaModelGenerator targetPackage="${targetModelPackage}" targetProject="${targetJavaProject}"/>
<sqlMapGenerator targetPackage="${targetXMLPackage}" targetProject="${targetXmlProject}"/>
<javaClientGenerator targetPackage="${targetMapperPackage}" targetProject="${targetJavaProject}" type="XMLMAPPER" />
<!-- mvn mybatis-generator:generate -->
<table tableName="score"/>
<table tableName="course"/>
<table tableName="student"/>
<table tableName="teacher"/>
<table tableName="user"/>
</context>
</generatorConfiguration>
3、把application.properties修改成application.yml文件
修改.yml文件配置详情
.yml文件
server:
port: 20001
################################################# 数据库访问配置
# 主数据源,默认的
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/d2?useUnicode=true&characterEncoding=utf8&autoReconnect=true
username: root
password: 123456
4、修改pom.xml文件
5、执行 mybatis-generator:generate命令
6、代码生成完毕!
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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.1.5.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.example</groupId>
<artifactId>demo</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>demo</name>
<description>Demo project for Spring Boot</description>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<java.version>1.8</java.version>
<!-- MyBatis Generator -->
<!-- Java接口和实体类,自动生成的存放位置 -->
<targetJavaProject>${basedir}/src/main/java</targetJavaProject>
<targetXmlProject>${basedir}/src/main/java</targetXmlProject>
<targetMapperPackage>com.example.demo.common.mapper</targetMapperPackage>
<targetModelPackage>com.example.demo.common.model</targetModelPackage>
<targetXMLPackage>com.example.demo.common.mapper</targetXMLPackage>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.0.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.2</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>5.1.40</version>
</dependency>
<dependency>
<groupId>com.xxg</groupId>
<artifactId>mybatis-generator-plugin</artifactId>
<version>1.0.0</version>
<scope>system</scope>
<systemPath>${basedir}/src/main/resources/generator/mybatis-generator-plugin-1.0.0.jar</systemPath>
</dependency>
</dependencies>
</plugin>
</plugins>
<resources>
<resource>
<directory>src/main/java</directory>
<filtering>false</filtering>
<includes>
<include>**/*.xml</include>
</includes>
</resource>
<resource>
<directory>src/main/resources</directory>
<filtering>false</filtering>
</resource>
</resources>
</build>
</project>