SpringBoot 整合Mybatis的流程

1. pom 文件添加依赖

<!--使用mysql-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.45</version>
    </dependency>
    <!-- mybatis -->
    <dependency>
      <groupId>org.mybatis.spring.boot</groupId>
      <artifactId>mybatis-spring-boot-starter</artifactId>
      <version>1.1.1</version>
    </dependency>

2. applicationContext.properties 文件添加mysql的简单配置

#数据库
spring.datasource.url=jdbc:mysql://47.95.219.28:3306/test?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

#公共配置与profiles选择无关
mybatis.mapperLocations=classpath:mybatis/api/login/*.xml

3.编写Mapper接口

package com.mutou.jwt.dao.mybatis.api.login;

import com.mutou.jwt.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Component;

/**
 * @author 杨喜存
 * @since 2019/3/6 10:42 PM
 */
public interface LoginMapper {
  User getUserByUserName(String userName);
}

4.编写XML文件

<?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.mutou.jwt.dao.mybatis.api.login.LoginMapper">

  <select id="getUserByUserName" resultType="com.mutou.jwt.entity.User">
    select
      id Id,
      user_name userName,
      password password
    from
      user
    where user_name = #{userName}
  </select>
</mapper>

完成