1.springboot整合mybatis

1.先看下目录结构，sql映射文件放在mapper 文件夹中

2.配置一下yml文件

spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/mybatis?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
    driver-class-name: com.mysql.cj.jdbc.Driver
mybatis:
#  config-location: classpath:/mybatis/mybatis-config.xml
  mapper-locations: classpath:/mapper/*.xml

3.主配置类上面加扫描注解，扫描dao层mapper接口

@MapperScan("com.example.mybatis.mybatis2.dao")

4.配置sql映射文件，注意自己的namespace

<?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.mybatis.mybatis2.dao.StudentMapper">

    <resultMap id="BaseResultMap" type="com.example.mybatis.mybatis2.bean.Student">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="name" jdbcType="VARCHAR" property="name" />
  </resultMap>
  
    <!--根据id查询-->
    <select id="selectById" resultMap="BaseResultMap">
        select * from student where id=#{id};
    </select>

</mapper>

5.编写mapper接口,然后写service、controller等。

public interface StudentMapper {
    //根据id查询
    public Student selectById(Integer id);
}