Springboot2.2.5整合Mysql5.7.27和Mybatis

dependcy依赖

<!--spring boot-->
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.2.5.RELEASE</version>

<!-- mysql -->
<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>

<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>5.1.27</version>
</dependency>

<!-- Mybatis 依赖配置 -->
<dependency>
	<groupId>org.mybatis.spring.boot</groupId>
	<artifactId>mybatis-spring-boot-starter</artifactId>
	<version>2.2.0</version>
</dependency>

配置文件

server:
  port: 9000
spring:
  application:
    name: reportsso
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/nacos_config?useUnicode=true&characterEncoding=UTF-8&useSSL=false
    username: root
    password: root
mybatis:
  # 配置mapper的扫描，找到所有的mapper.xml映射文件
  mapperLocations: classpath:mapper/*.xml

其中要在resource目录下的mapper下放xml文件，对应于上面配置文件中的

mybatis.mapperLocations

Mapper接口

package com.zhhz.reportsso.mapper;


import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface UserMapper {
    String getPwdByUsername (@Param("username") String username);
}

注意需要加上@mapper注解
类中写需要实现的方法，一会会在xml文件当中实现

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.zhhz.reportsso.mapper.UserMapper">
    <select id="getPwdByUsername" resultType="java.lang.String">
        select password from `user` where username=#{username}
    </select>
</mapper>

其中namespace要和刚刚的mapper接口的路径对应上，下面的函数id要和mapper中的函数名对应上。