<!-- 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>

        </dependency>

#mysql配置

spring.datasource.chen.jdbc-url=jdbc:mysql://localhost:3306/chen?serverTimezone=Asia/Shanghai

spring.datasource.chen.username=root

spring.datasource.chen.password=root

#mysql-connector-java 6中的

spring.datasource.chen.driver-class-name=com.mysql.cj.jdbc.Driver

package com.example.demo.configuration;

import org.springframework.boot.context.properties.ConfigurationProperties;

import org.springframework.boot.jdbc.DataSourceBuilder;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;

@Configuration

public class DataSourceConfig {

    @Bean(name = "dataSource")

    @ConfigurationProperties(prefix = "spring.datasource.chen")

    public DataSource chenDataSource() {

        return DataSourceBuilder.create().build();

    }

}

package com.example.demo.biz.dao;

import com.example.demo.biz.dto.User;

import org.apache.ibatis.annotations.Param;

import org.springframework.stereotype.Repository;

import java.util.List;

/**

 * xml  形式配置

 */

@Repository

public interface UserMapper {

    List<User> getAll();

    User getOne(int id);

    void insertUser(User user);

    void deleteUserById(int id);

    /**

     * 动态sql

     * @param sql

     * @return

     */

    List<User> queyrUserList(String sql);

    /**

     * 动态sql

     * @param sql

     * @return

     */

    List<User> queyrUserList2(@Param("querySql") String sql);

}

#mybatis xml配置

mybatis.config-location=classpath:mybatis/mybatis-config.xml

mybatis.mapper-locations=classpath:mybatis/mapper/*.xml

<?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>

        <!--当返回行的所有列都是空时，MyBatis默认返回null  注意pom.xml ：mybatis 1.3.0-->

        <setting name="returnInstanceForEmptyRow" value="true"/>

        <!-- 显示查询语句 -->

        <setting name="logImpl" value="STDOUT_LOGGING" />

        <!--是否使用缓存-->

        <setting name="cacheEnabled" value="true" />

        <!-- 懒加载 -->

        <setting name="lazyLoadingEnabled" value="true" />

        <!--是否允许单条sql 返回多个数据集  (取决于驱动的兼容性) default:true-->

        <setting name="multipleResultSetsEnabled" value="true"/>

        <!--是否可以使用列的别名 (取决于驱动的兼容性) default:true-->

        <setting name="useColumnLabel" value="true"/>

    </settings>

    <!--

      3.typeAliases:起别名的标签

          typeAlias:为某个java类型起别名

              type:指定要起别名的全类名，默认别名就是类小写，(但是其实他是不区分大小写的，也就是说你全部大写也没问题)

              alias:新的别名

          package:为某个包下的类批量起别名(这个会存在的一个问题就是可能会重复，重复的情况下还可以用@Alias来解决)

              name:指定包名(这个就相当于是为这个包下的所有的类都创建了一个默认的别名)

      当然还有一个起别名的方式就是在实体上使用@Alias来起别名

      注：起别名看自己的情况，推荐还是在mapper文件中使用全类名

  -->

    <typeAliases>

        <typeAlias alias="Integer" type="java.lang.Integer" />

        <typeAlias alias="Long" type="java.lang.Long" />

        <typeAlias alias="HashMap" type="java.util.HashMap" />

        <typeAlias alias="LinkedHashMap" type="java.util.LinkedHashMap" />

        <typeAlias alias="ArrayList" type="java.util.ArrayList" />

        <typeAlias alias="LinkedList" type="java.util.LinkedList" />

    </typeAliases>

</configuration>

<?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.example.demo.biz.dao.UserMapper">

    <resultMap id="BaseResultMap" type="com.example.demo.biz.dto.User" >

        <id column="id" property="id" jdbcType="INTEGER" />

        <result column="username" property="userName" jdbcType="VARCHAR" />

        <result column="pwd" property="passWord" jdbcType="VARCHAR" />

        <result column="gender" property="gender" jdbcType="VARCHAR"/>

        <result column="email" property="email" jdbcType="VARCHAR" />

        <result column="mobile" property="mobile" jdbcType="VARCHAR" />

        <result column="identity" property="identity" jdbcType="VARCHAR" />

        <result column="nationality" property="nationality" jdbcType="VARCHAR" />

        <result column="description" property="description" jdbcType="VARCHAR" />

        <result column="address" property="address" jdbcType="VARCHAR" />

    </resultMap>

    <sql id="Base_Column_List">

        id, username, pwd, gender, email,mobile,identity,address

    </sql>

    <select id="getAll" resultMap="BaseResultMap">

        SELECT

        <include refid="Base_Column_List"/>

        FROM c_tbl_users

    </select>

    <select id="getOne" parameterType="java.lang.Long" resultMap="BaseResultMap" >

        SELECT

        <include refid="Base_Column_List"/>

        FROM c_tbl_users

        WHERE id = #{id}

    </select>

    <insert id="insertUser" parameterType="com.example.demo.biz.dto.User">

       insert into c_tbl_users (username,pwd,gender,email,mobile,identity,address)

       values(#{userName},#{passWord},#{gender},#{email},#{mobile},#{identity},#{address})

    </insert>

    <delete id="deleteUserById" parameterType="Integer">

        delete t from c_tbl_users t where t.id=#{id}

    </delete>

    <select id="queyrUserList" parameterType="java.lang.String" resultMap="BaseResultMap">

        ${value1}

    </select>

    <select id="queyrUserList2" parameterType="java.lang.String" resultMap="BaseResultMap">

        ${querySql}

    </select>

</mapper>

@SpringBootApplication

//@EnableScheduling

@MapperScan("com.example.demo.biz.dao")

public class DemoApplication {

    public static void main(String[] args) {

        SpringApplication.run(DemoApplication.class, args);

    }

}

package com.example.demo.biz;

import com.example.demo.biz.dao.UserMapper;

import org.junit.Test;

import org.junit.runner.RunWith;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.boot.test.context.SpringBootTest;

import org.springframework.test.context.junit4.SpringRunner;

import javax.sql.DataSource;

@RunWith(SpringRunner.class)

@SpringBootTest

public class UserTest {

    @Autowired

    protected UserMapper userMapper;

    @Autowired

    DataSource dataSource;

    @Test

    public void test1(){

        System.out.println("dataSource = "+dataSource);

    }

    @Test

    public void test2(){

        System.out.println(userMapper.getAll());

    }

}