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中的函数名对应上。