SpringBoot + Mybatis 整合

1、创建一个SpringBoot项目

2、填写项目名，选择jdk版本，其他的都是默认的就行

3、因为是web项目，所以选择web

4、选择mysql,jdbc,mybatis, 选择版本2.0.0,目前2.0.0是最新稳定版本

5、项目创建完成，项目视图后面一起贴出

6、修改pom文件，添加Mybatis的generator插件

<plugin>
	<groupId>org.mybatis.generator</groupId>
	<artifactId>mybatis-generator-maven-plugin</artifactId>
	<version>1.3.2</version>
	<configuration>	
	<!-- 填写generatorConfig.xml文件路径-->	<configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
	<overwrite>true</overwrite>
	<verbose>true</verbose>
</configuration>
</plugin>

7、修改pom文件，添加阿里巴巴的数据源

<!-- mysql -->
 <dependency>
     <groupId>mysql</groupId>
     <artifactId>mysql-connector-java</artifactId>
     <version>5.1.35</version>
 </dependency>

 <!-- mybatis start -->
 <dependency>
     <groupId>org.mybatis.spring.boot</groupId>
     <artifactId>mybatis-spring-boot-starter</artifactId>
     <version>1.3.2</version>
 </dependency>

 <dependency>
     <groupId>com.fasterxml.jackson.core</groupId>
     <artifactId>jackson-core</artifactId>
 </dependency>
 <dependency>
     <groupId>com.fasterxml.jackson.core</groupId>
     <artifactId>jackson-databind</artifactId>
 </dependency>
 <dependency>
     <groupId>com.fasterxml.jackson.datatype</groupId>
     <artifactId>jackson-datatype-joda</artifactId>
 </dependency>
 <dependency>
     <groupId>com.fasterxml.jackson.module</groupId>
     <artifactId>jackson-module-parameter-names</artifactId>
 </dependency>
 <!-- 分页插件 -->
 <dependency>
     <groupId>com.github.pagehelper</groupId>
     <artifactId>pagehelper-spring-boot-starter</artifactId>
     <version>1.1.2</version>
 </dependency>
 <!-- alibaba的druid数据库连接池 -->
 <dependency>
     <groupId>com.alibaba</groupId>
     <artifactId>druid-spring-boot-starter</artifactId>
     <version>1.1.13</version>
 </dependency>

 <!-- mybatis end -->

8、删除默认的配置文件application.properties，创建使用更简洁的applicatoin.yml配置文件,并添加配置

server:
  port: 8081

spring:
  datasource:
    name: test
    url: jdbc:mysql://127.0.0.1:3306/springboot
    username: root
    password: 123456
    # 使用阿里巴巴数据源
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.jdbc.Driver
    durid:
	    maxActive: 20
	    initialSize: 1
	    maxWait: 6000
	    minIdle: 1
	    timeBetweenEvictionRunsMillis: 60000
	    minEvictableIdleTimeMillis: 300000
	    validationQuery: select 'x'
	    testWhileIdle: true
	    testOnBorrow: false
	    testOnReturn: false
	    poolPreparedStatements: true
	    maxOpenPreparedStatements: 20

mybatis:
  mapper-locations: classpath:mapping/*.xml
  type-aliases-package: com.van.springbootdemo2.entity
 
#pagehelper分页插件
pagehelper:
  helperDialect: mysql
  reasonable: true
  supportMethodsArguments: true
  params: count=countSql

9、在resoure文件夹下，创建一个文件夹generator, 新建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>
    <!--连接mysql包的位置-->
    <classPathEntry location="D:\java\localRepository\mysql\mysql-connector-java\5.1.30\mysql-connector-java-5.1.30.jar"/>
    <context id="context1">
        <!-- 是否生成注释 -->
        <commentGenerator>
            <property name="suppressDate" value="true"/>
            <property name="suppressAllComments" value="true"/>
        </commentGenerator>
        <!-- 数据库连接 -->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://localhost:3306/springboot"
                        userId="root" password="123456" />

        <!-- 生成的包名和工程名 -->
        <javaModelGenerator targetPackage="com.van.springbootdemo2.entity"
                            targetProject="src/main/java"/>
         <!-- 这里把映射文件放在resource下，因为idea对xml文件的读取，默认是从resource下找-->
        <sqlMapGenerator targetPackage="com.van.springbootdemo2.mapping"
                         targetProject="src/resorce/mapping" />
        <javaClientGenerator targetPackage="com.van.springbootdemo2.dao"
                             targetProject="src/main/java" type="XMLMAPPER" />

        <!-- 数据库表 -->
        <table  tableName="t_user" domainObjectName="User">
            <!-- 设置别名 -->
            <!--
            <columnOverride column="ds_id" property="dsId" />
             -->
        </table>
    </context>
</generatorConfiguration>

10、使用generator插件，生成相应的mapper,entity和映射文件

1. 添加generator插件
   

3) 选择，并启动

11、在springboot的启动类上，添加@MapperScan

@SpringBootApplication
@MapperScan("com.van.springbootdemo2.dao") //将项目中对应的mapper类的路径加进来就可以了
public class Springbootdemo2Application {

	public static void main(String[] args) {
		SpringApplication.run(Springbootdemo2Application.class, args);
	}
}

12、用测试类测试

@RunWith(SpringRunner.class)
@SpringBootTest
public class Springbootdemo2ApplicationTests {

	@Autowired
	private UserMapper userDao;

	@Test
	public void contextLoads() {
		System.out.println(userDao);
		User user = new User();
		user.setPassword("123456");
		user.setPhone("12345");
		user.setUserName("xxxx");
		userDao.insert(user);
	}

}

检查一下数据库，发现数据已经插到表里了。

13、附上整个项目结构图(其中service和controller可以忽略，可以后续使用)