SpringBoot整合Mybatis 以及 mybatis自动生成代码配置

1、springboot的配置文件application.yml

[html]view plain copy
#端口     
server:     
  port: 8080     
     
  #模板页面     
  #注释的部分是Thymeleaf默认的配置，如有其它需求可以自行更改     
  spring:     
    thymeleaf:     
      cache: false     
      prefix: classpath:/templates/     
      suffix: .html     
      mode: LEGACYHTML5     
#      encoding: UTF-8     
#      content-type: text/html     
     
##数据源一     
#spring:     
#      datasource:     
#          driverClass: com.mysql.jdbc.Driver     
#          url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8     
#          username: xuan     
#          password: 123456     
#数据源二     
spring:     
      datasource:     
          url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8     
          username: xuan     
          password: 123456     
          # 使用druid数据源     
          type: com.alibaba.druid.pool.DruidDataSource     
          driver-class-name: com.mysql.cj.jdbc.Driver     
          filters: stat     
          maxActive: 20     
          initialSize: 1     
          maxWait: 60000     
          minIdle: 1     
          timeBetweenEvictionRunsMillis: 60000     
          minEvictableIdleTimeMillis: 300000     
          validationQuery: select 'x'     
          testWhileIdle: true     
          testOnBorrow: false     
          testOnReturn: false     
          poolPreparedStatements: true     
          maxOpenPreparedStatements: 20     
     
#spring-boot整合mybatis     
mybatis:     
  #config-location: classpath:/mapper/config/mybatisConfig.xml #可以注射掉,没用到该配置文件     
  mapper-locations: classpath:/mapper/*Mapper.xml     
  #type-aliases-package: com.xuan.entity    

2、maven的配置文件pom.xml (加入springboot整合mybatis的jar包，以及mysql驱动jar包，阿里的数据库链接池jar包)

以及mybatis 自动生成代码的一些配置

[html]view plain copy
<?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>     
     
    <groupId>com.xuan</groupId>     
    <artifactId>myspringboot</artifactId>     
    <version>0.0.1-SNAPSHOT</version>     
    <packaging>jar</packaging>     
     
    <name>myspringboot</name>     
    <description>Demo project for Spring Boot</description>     
     
    <parent>     
        <groupId>org.springframework.boot</groupId>     
        <artifactId>spring-boot-starter-parent</artifactId>     
        <version>1.5.8.RELEASE</version>     
        <relativePath/> <!-- lookup parent from repository -->     
    </parent>     
     
    <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.version>1.3.2</mybatis.generator.version>     
        <mysql.connector.java.version>6.0.6</mysql.connector.java.version>     
     
     
        <!-- Used by MyBatis Generator to Generate Codes -->     
        <!-- 运行命令: mvn mybatis-generator:generate -e -->     
        <!--<classPathEntry.mysql.location>${basedir}/target/${project.artifactId}/WEB-INF/lib/mysql-connector-java-${mysql.connector.java.version}.jar</classPathEntry.mysql.location>-->     
        <classPathEntry.mysql.location>/Users/chenqixuan/.m2/repository/mysql/mysql-connector-java/5.1.38/mysql-connector-java-5.1.38.jar</classPathEntry.mysql.location>     
        <javaModelGenerator.targetProject>${basedir}/src/main/java</javaModelGenerator.targetProject>     
        <sqlMapGenerator.targetProject>${basedir}/src/main/resources</sqlMapGenerator.targetProject>     
        <javaClientGenerator.targetProject>${basedir}/src/main/java</javaClientGenerator.targetProject>     
        <mybatis.generator.configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</mybatis.generator.configurationFile>     
        <mybatis.generator.overwrite>true</mybatis.generator.overwrite>     
    </properties>     
     
    <dependencies>     
        <!--springboot整合redis-->     
        <dependency>     
            <groupId>org.springframework.boot</groupId>     
            <artifactId>spring-boot-starter-data-redis</artifactId>     
        </dependency>     
        <!--springboot整合mybatis-->     
        <dependency>     
            <groupId>org.mybatis.spring.boot</groupId>     
            <artifactId>mybatis-spring-boot-starter</artifactId>     
            <version>1.3.1</version>     
        </dependency>     
        <!--mysql jdbc驱动 -->     
        <dependency>     
            <groupId>mysql</groupId>     
            <artifactId>mysql-connector-java</artifactId>     
            <version>${mysql.connector.java.version}</version>     
        </dependency>     
        <!-- alibaba的druid数据库连接池 -->     
        <dependency>     
            <groupId>com.alibaba</groupId>     
            <artifactId>druid</artifactId>     
            <version>1.0.11</version>     
        </dependency>     
     
        <dependency>     
            <groupId>org.springframework.boot</groupId>     
            <artifactId>spring-boot-starter-web</artifactId>     
        </dependency>     
     
        <!--模板页面-->     
        <dependency>     
            <groupId>org.springframework.boot</groupId>     
            <artifactId>spring-boot-starter-thymeleaf</artifactId>     
        </dependency>     
        <dependency>     
            <groupId>net.sourceforge.nekohtml</groupId>     
            <artifactId>nekohtml</artifactId>     
            <version>1.9.22</version>     
        </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>     
            <!-- mybatis generator 自动生成代码插件 -->     
            <plugin>     
                <groupId>org.mybatis.generator</groupId>     
                <artifactId>mybatis-generator-maven-plugin</artifactId>     
                <version>${mybatis.generator.version}</version>     
            </plugin>     
        </plugins>     
    </build>     
     
     
</project>    

3、mybatis的配置文件（可以不要需要，因为在application.yml配置了）

[html]view plain copy
<?xml version="1.0" encoding="UTF-8"?>     
<!DOCTYPE configuration     
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"     
        "http://mybatis.org/dtd/mybatis-3-config.dtd">     
     
<configuration>     
    <settings>     
        <!-- changes from the defaults -->     
        <setting name="lazyLoadingEnabled" value="false" />     
    </settings>     
     
    <mappers>     
        <!--在application.yml配置文件中已经配置的*Mapper.xml,所以这里不需要重复添加了-->     
        <!--<mapper resource="mapper/UserMapper.xml" />-->     
    </mappers>     
     
</configuration>    

4、用户实体类xml映射文件 UserMapper.xml

[html]view plain copy
<?xml version="1.0" encoding="UTF-8"?>     
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">     
<mapper namespace="com.xuan.mapper.UserMapper">     
     
    <!-- 查询网校的用户数目 -->     
    <select id="getAllUser" resultType="com.xuan.entity.User">     
          SELECT * from user     
    </select>     
         
</mapper>    

5、自动生成配置文件 generatorConfig.xml（项目目录下运行命令： mvn mybatis-generator:generate -e ）

注意：generatorConfig.xml配置文件中有些参数笔者是配置在pom.xml里的，另外mysql-connector-java-5.1.38.jar 数据库mysql驱动也不要使用太高的版本（笔者使用6.0.6版本是遇到错误，换成低版本就没事）

[html]view plain copy
<?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="${classPathEntry.mysql.location}" />     
     
    <context id="mysqlTables" targetRuntime="MyBatis3">     
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"     
                        connectionURL="jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8"     
                        userId="xuan" password="123456">     
        </jdbcConnection>     
     
        <javaTypeResolver>     
            <property name="forceBigDecimals" value="false" />     
        </javaTypeResolver>     
     
        <javaModelGenerator targetPackage="com.xuan.entity"     
                            targetProject="${javaModelGenerator.targetProject}">     
            <property name="enableSubPackages" value="true" />     
            <property name="trimStrings" value="true" />     
        </javaModelGenerator>     
     
        <sqlMapGenerator targetPackage="mapper"     
                         targetProject="${sqlMapGenerator.targetProject}">     
            <property name="enableSubPackages" value="true" />     
        </sqlMapGenerator>     
     
        <javaClientGenerator type="XMLMAPPER"     
                             targetPackage="com.xuan.mapper" targetProject="${javaClientGenerator.targetProject}">     
            <property name="enableSubPackages" value="false" />     
        </javaClientGenerator>     
     
        <!--    
        <table tableName="live_course_channel" domainObjectName="LiveCourseChannel"></table>    
    
        -->     
        <table tableName="video" domainObjectName="Video"></table>     
     
     
    </context>     
</generatorConfiguration>    

6、用户实体类：

[java]view plain copy
package com.xuan.entity;     
     
import java.io.Serializable;     
     
/**    
 * Created by chenqixuan on 17/10/24.    
 */     
public class User implements Serializable{     
    private static final long serialVersionUID = 2120869894112984147L;     
     
    private Integer id;     
     
    private String  name;     
     
    private  Integer age;     
     
    private String address;     
     
    public Integer getId() {     
        return id;     
    }     
     
    public void setId(Integer id) {     
        this.id = id;     
    }     
     
    public String getName() {     
        return name;     
    }     
     
    public void setName(String name) {     
        this.name = name;     
    }     
     
    public Integer getAge() {     
        return age;     
    }     
     
    public void setAge(Integer age) {     
        this.age = age;     
    }     
     
    public String getAddress() {     
        return address;     
    }     
     
    public void setAddress(String address) {     
        this.address = address;     
    }     
}    

7、dao层是使用@Mapper注解接口***，以前spring是使用自动扫描

[java]view plain copy
package com.xuan.mapper;     
     
import com.xuan.entity.User;     
import org.apache.ibatis.annotations.Mapper;     
     
import java.util.List;     
     
/**    
 * Created by chenqixuan on 17/10/24.    
 */     
@Mapper     
public interface UserMapper {     
     
    public List<User> getAllUser();     
     
}    

8、controller引用：

[java]view plain copy
package com.xuan.controller;     
     
import com.xuan.entity.User;     
import com.xuan.mapper.UserMapper;     
import org.springframework.beans.factory.annotation.Autowired;     
import org.springframework.web.bind.annotation.GetMapping;     
import org.springframework.web.bind.annotation.RequestMapping;     
import org.springframework.web.bind.annotation.RestController;     
     
import java.util.*;     
     
/**    
 * Created by chenqixuan on 17/10/24.    
 */     
@RestController     
@RequestMapping("/user")     
public class UserController {     
     
    @Autowired     
    private UserMapper userMapper;     
     
    @GetMapping(value="/all")     
    public List<User> getAllUser(){     
     
        return userMapper.getAllUser();     
    }     
     
     
}    

9、效果图：

10、目录结构：