SpringBoot框架中Mybatis的配置

1. pom.xml

<dependencies>
	<!-- version版本要与电脑中安装的mysql一致  -->
	<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
		<version>8.0.16</version>
	</dependency>
	<!-- 尽量使用高版本的druid  -->
    <dependency>
    	<groupId>com.alibaba</groupId>
    	<artifactId>druid</artifactId>
    	<version>1.1.10</version>
    </dependency>
    <!-- 为防止plugin中的mybatis-generator-core不自动下载  -->
    <dependency>
    	<groupId>org.mybatis.generator</groupId>
    	<artifactId>mybatis-generator-core</artifactId>
    	<version>1.3.7</version>
    </dependency>
    <dependency>
    	<groupId>org.mybatis.spring.boot</groupId>
    	<artifactId>mybatis-spring-boot-starter</artifactId>
    	<version>1.3.1</version>
    </dependency>
</dependencies>

<build>
	<pluginManagement>
		<plugins>
			<plugin>
				<groupId>org.mybatis.generator</groupId>
				<artifactId>mybatis-generator-maven-plugin</artifactId>
				<version>1.3.7</version>
				<dependencies>
					<dependency>
						<groupId>org.mybatis.generator</groupId>
						<artifactId>mybatis-generator-core</artifactId>
						<version>1.3.7</version>
					</dependency>
					<dependency>
						<groupId>mysql</groupId>
						<artifactId>mysql-connector-java</artifactId>
						<version>8.0.16</version>
					</dependency>
				</dependencies>
				<executions>
					<execution>
						<id>mybatis generator</id>
						<phase>package</phase>
						<goals>
							<goal>generate</goal>
						</goals>
					</execution>
				</executions>
				<configuration>
					<!-- 允许移动生成的文件 -->
					<verbose>true</verbose>
					<!-- 允许自动覆盖文件  -->
					<overwrite>true</overwrite>
					<configurationFile>
              			src/main/resources/mybatis-generator.xml
            		</configurationFile>
          		</configuration>
        	</plugin>
		</plugins>
	</pluginManagement>
</build>

2. application.properties

1.对 Mybatis 的配置
mybatis.mapperLocations=classpath:mapping/*.xml
spring.datasource.name=nannan
spring.datasource.url=jdbc:mysql://localhost:3306/nannan?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=123456
2.使用 druid 数据源（高版本druid的driverClassName为com.mysql.cj.jdbc.Driver）
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver

3. mybatis-generator.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>
    <classPathEntry location="D:\maven\repo\mysql\mysql-connector-java\5.1.30\mysql-connector-java-5.1.30.jar" />
    <context id="DB2Tables" targetRuntime="MyBatis3">

        <!-- 数据库链接地址账号密码 -->
        <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/nannan?serverTimezone=UTC" userId="root" password="123456"/>

        <!-- 生成DataObject类存放位置 -->
        <javaModelGenerator targetPackage="com.miaoshaproject.dataobject" targetProject="src/main/java">
            <property name="enableSubPackages" value="true"/>
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>

        <!-- 生成映射文件存放的位置 -->
        <sqlMapGenerator targetPackage="mapping" targetProject="src/main/resources">
            <property name="enableSubPackages" value="true"/>
        </sqlMapGenerator>

        <!-- 生成Dao类存放的位置 -->
        <!--
            客户端代码，生成易于使用的针对DataObject（Model）对象和XML配置文件的代码
            type="ANNOTATEDMAPPER"，生成Java Model 和基于注解的Mapper对象
            type="MIXEDMAPPER"，生成基于注解的Java Model 和相应的Mapper对象
            type="XMLMAPPER"，生成SQLMap XML文件和独立的Mapper接口
         -->
        <javaClientGenerator targetPackage="com.miaoshaproject.dao" targetProject="src/main/java" type="XMLMAPPER">
            <property name="enableSubPackages" value="true"/>
        </javaClientGenerator>

        <!-- 生成表及类名 -->
        <table tableName="user_info" domainObjectName="UserDO" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false">
        </table>
        <table tableName="user_password" domainObjectName="UserPasswordDO" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false">
        </table>

    </context>
</generatorConfiguration>

4. 设置编辑器中的检查选项

• 使用 Ctrl+Alt+s 进入设置(Settings)
• 在 Editor -> Inspections 中找到Spring，将 Spring 全部改为 Warning

5. 添加Maven启动/调试配置

• Run -> Edit configurations -> Maven 添加一个Maven启动配置

• 双击 mybatis-generator 执行mybatis

最终

• 最终会生成这样的目录结构以及文件信息