Spring Boot中maven下用MyBatis的generator生成文件

1.配置插件，在pom.xml中注入依赖

		<!-- swagger api文档  可不使用-->
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-swagger2</artifactId>
            <version>2.6.1</version>
        </dependency>
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-swagger-ui</artifactId>
            <version>2.6.1</version>
        </dependency>
        <!--mysql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <!--mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>


		<plugin>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-maven-plugin</artifactId>
            <version>1.3.5</version>
        </plugin>

2.配置数据源，在resources文件夹下面配置application.properties文件。

spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://ip地址:默认端口号/数据库名称
spring.datasource.username=root
spring.datasource.password=root密码
server.port=8888
mybatis.mapper-locations= classpath:/mapper/**/*.xml 

3.配置文件，在resources文件夹下面配置generatorConfig.xml文件。要指定的有，数据库驱动，url，username,password，实体包，Mapper映射包及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">
  
<!-- mybatis-generator的核心配置文件 -->
<generatorConfiguration>

  <classPathEntry location="D:\briup\repository\mysql\mysql-connector-java\8.0.15\mysql-connector-java-8.0.15.jar" />
  <context id="DB2Tables" targetRuntime="MyBatis3">

    <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
        connectionURL="jdbc:mysql://ip地址:端口号/数据库名称"
        userId="root"
        password="root密码">
        
      <!--产生selectByPrimaryKey-->
      <property name="useInformationSchema" value="true" />
    </jdbcConnection>
    

	<!--指定生成的类型为java类型，避免数据库中number等类型字段 -->
    <javaTypeResolver >
      <property name="forceBigDecimals" value="false" />
    </javaTypeResolver>

	<!--自动生成的实体的存放包路径 -->
    <javaModelGenerator targetPackage="com.briup.apps.sms.bean" targetProject="./src/main/java">
      <property name="enableSubPackages" value="true" />
      <property name="trimStrings" value="true" />
    </javaModelGenerator>

	<!--自动生成的*Mapper.xml文件存放路径 -->
    <sqlMapGenerator targetPackage="mapper"  targetProject="./src/main/resources">
      <property name="enableSubPackages" value="true" />
    </sqlMapGenerator>

	<!--自动生成的*Mapper.java存放路径 -->
    <javaClientGenerator type="XMLMAPPER" targetPackage="com.briup.apps.sms.mapper"  targetProject="./src/main/java">
      <property name="enableSubPackages" value="true" />
    </javaClientGenerator>


	<!-- 映射配置 -->
    <table tableName="c_course" domainObjectName="Course"></table>
    <table tableName="c_user" domainObjectName="User"></table>
    <table tableName="c_student_course" domainObjectName="StudentCourse"></table>

	<!--
	启动自动生成文件命令
	 mvn -Dmybatis.generator.overwrite=true mybatis-generator:generate
	-->
  </context>
</generatorConfiguration>

4.执行插件，在Terminal中用maven 命令生成

mvn mybatis-generator:generate

5.如果修改了映射配置

>mvn clean
>mvn mybatis-generator:generate

6.如果出现了mysql超出最大连接数

show VARIABLES like '%max_allowed_packet%';
set global max_allowed_packet = 2*1024*1024*10;