创建SpringBoot工程并集成Mybatis的方法

<!--springboot依赖-->
<dependency>
<groupid>org.springframework.boot<groupi>
<artifactid>springbootstarter<artifactid>
</dependency>
<dependency>
<groupid>org.springframework.boot</groupid>
 <artifactid>spring-boot-starter-web</artifactid> 
</dependency>
<!--测试-->
<dependency>
 <groupid>org.springframework.boot</groupid>
 <artifactid>spring-boot-starter-test</artifactid>
 <scope>test</scope>
 </dependency>
 <!--集成mybatis-->
<dependency>
<groupid>org.mybatis.spring.boot</groupid>
<artifactid>mybatis-spring-boot-starter<artifactid>
 <version>1.3.0</version>
 </dependency>
 <dependency>
 <groupid>mysql</groupid>
 <artifactid>mysql-connector-java</artifactid>
  <version>5.1.35</version>
 </dependency>

spring.datasource.name=test
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test
spring.datasource.username=root
spring.datasource.password=root

spring:
 datasource:
  url: jdbc:mysql://127.0.0.1:3306/test
  username: root
  password: root
  driver-class-name: com.mysql.cj.jdbc.driver

create database test;
create table `t_user` (
 `user_id` int(11) not null auto_increment,
 `user_name` varchar(225) not null,
 `password` varchar(225) not null,
 `phone` varchar(225) not null,
 primary key (`user_id`)
) engine=innodb auto_increment=1000 default charset=utf8

<build>
<resources>
  <resource>
    <directory>src/main/resources</directory>
    <filtering>true</filtering>
    <excludes>
      <exclude>generator/**</exclude>
    </excludes>
  </resource>
</resources>
<plugins>
<plugin>
<groupid>org.mybatis.generator</groupid>
<artifactid>mybatis-generator-maven-plugin</artifactid>
<version>1.3.4-snapshot</version>
<dependencies>
<dependency>
  <groupid>mysql</groupid>
  <artifactid>mysql-connector-java</artifactid>
  <version>5.1.39</version>
</dependency>
<dependency>
<groupid>org.mybatis.generator</groupid>
<artifactid>mybatis-generator-core</artifactid>
  <version>1.3.4-snapshot</version>
</dependency>
</dependencies>
  <configuration>
    <overwrite>true</overwrite>
    <configurationfile>src/main/resources/generator/generatorconfig.xml</configurationfile>
  </configuration>
</plugin>
</plugins>
</build>

<?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>
  <context id="db2tables"  targetruntime="mybatis3">
    <commentgenerator>
      <property name="suppressdate" value="true"/>
      <property name="suppressallcomments" value="true"/>
    </commentgenerator>
    <!--数据库链接地址账号密码-->
    <jdbcconnection driverclass="com.mysql.jdbc.driver"
            connectionurl="jdbc:mysql://127.0.0.1:3306/test"
            userid="root"
            password="root">
    </jdbcconnection>
    <javatyperesolver>
      <property name="forcebigdecimals" value="false"/>
    </javatyperesolver>
    <!--生成model类存放位置-->
    <javamodelgenerator targetpackage="com.lw.study.dao.domain" targetproject="src/main/java">
      <property name="enablesubpackages" value="true"/>
      <property name="trimstrings" value="true"/>
    </javamodelgenerator>
    <!--生成映射文件存放位置-->
    <sqlmapgenerator targetpackage="sqlmap" targetproject="src/main/resources/">
      <property name="enablesubpackages" value="true"/>
    </sqlmapgenerator>
    <!--生成dao类存放位置-->
    <!-- 客户端代码，生成易于使用的针对model对象和xml配置文件 的代码
        type="annotatedmapper",生成java model 和基于注解的mapper对象
        type="mixedmapper",生成基于注解的java model 和相应的mapper对象
        type="xmlmapper",生成sqlmap xml文件和独立的mapper接口
    -->
    <javaclientgenerator type="xmlmapper" targetpackage="com.lw.study.dao.mapper" targetproject="src/main/java">
      <property name="enablesubpackages" value="true"/>
    </javaclientgenerator>
    <!--生成对应表及类名-->
    <!--<table schema="loandb" tablename="t_audit_job" domainobjectname="auditjob">-->
      <!--<property name="useactualcolumnnames" value="true"/>-->
      <!--<generatedkey column="id" sqlstatement="mysql" identity="true"/>-->
    <!--</table>-->
    <table tablename="t_user" domainobjectname="user" enablecountbyexample="false" enableupdatebyexample="false" enabledeletebyexample="false" enableselectbyexample="false" selectbyexamplequeryid="false"></table>
  </context>
</generatorconfiguration>

@configuration
@enabletransactionmanagement
public class mybatisconfig {
  @bean
  @configurationproperties(prefix = "spring.datasource")
  public datasource datasource(){
    return new org.apache.tomcat.jdbc.pool.datasource();
  }
  @bean(name = "sqlsessionfactory")
  public sqlsessionfactory sqlsessionfactorybean() throws exception {
    sqlsessionfactorybean sqlsessionfactorybean = new sqlsessionfactorybean();
    sqlsessionfactorybean.setdatasource(datasource());
    pathmatchingresourcepatternresolver resolver = new pathmatchingresourcepatternresolver();
    sqlsessionfactorybean.setmapperlocations(resolver.getresources("classpath:/sqlmap/*.xml"));
    return sqlsessionfactorybean.getobject();
  }
}

@configuration
@autoconfigureafter(mybatisconfig.class)
public class mybatismapperscannerconfig {
  @bean
  public mapperscannerconfigurer mapperscannerconfigurer() {
    mapperscannerconfigurer mapperscannerconfigurer = new mapperscannerconfigurer();
    mapperscannerconfigurer.setsqlsessionfactorybeanname("sqlsessionfactory");
    mapperscannerconfigurer.setbasepackage("com.study.dao.mapper");
    return mapperscannerconfigurer;
  }
}

@springbootapplication(scanbasepackages = {"com.lw.study.*"})
@mapperscan("com.lw.study.mapper")
public class application {
  public static void main(string[] args) {
    springapplication.run(application.class,args);
  }
}