整合mybatis

1、导入依赖

        <!-- 集成mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>3.0.0</version>
        </dependency>
        <!-- 集成mysql连接 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.22</version>
        </dependency>

2、编写配置文件

spring.datasource.url=jdbc:mysql://localhost:3306/StudySpringBoot?characterEncoding=UTF8&autoReconnect=true&serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=密码
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

# mybatis xml路径
mybatis.mapper-locations=classpath:/mapper/**/*.xml
logging.level.com.yd.train.mapper=trace

3、编写Mapper.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.yd.textspringboot.Mapper.UserMapper">
    <select id="getUserByName" parameterType="string" resultType="com.yd.textspringboot.dao.User">
        select
        *
        from user
        where name = #{name}
    </select>
</mapper>

4、编写mapper接口

@Mapper
public interface UserMapper {
    User getUserByName(String name);
}

5、接下来就是controller调通service，service调用mapper来对数据库的操作。