springboot整合mybatis

1.创建springboot项目，需要导入的主要包有mysql、mybatis-springboot-stater、lombok

2.配置文件

server.port=8003

#数据库配置相关
spring.datasource.url=jdbc:mysql://localhost:3306/mytest01?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
spring.datasource.username=root
spring.datasource.password=system
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

#mybatis配置相关
#mapper文件的位置
mybatis.mapper-locations=classpath:mapper/*.xml
#可以不用指定全类名
mybatis.type-aliases-package=com.boot.entity

#日志相关
logging.config=classpath:logback-spring.xml

3.logback-spring.xml

<configuration debug="true" scanPeriod="30 seconds">

    <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
        <encoder>
            <pattern>[%d{YYYY-MM-dd HH:mm:ss.SSS}] [%X{RequestID}] [%-5level] [%thread] [%logger{36}:%line] - %msg%n</pattern>
        </encoder>
    </appender>

    <appender name="FILE" class="ch.qos.logback.core.rolling.RollingFileAppender">
        <file>logs/easyview-api.log</file>
        <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
            <fileNamePattern>easyview-api.%d{yyyy-MM-dd}.log</fileNamePattern>
            <maxHistory>30</maxHistory>
            <totalSizeCap>3GB</totalSizeCap>
        </rollingPolicy>
        <encoder>
            <pattern>[%d{YYYY-MM-dd HH:mm:ss.SSS}] [%X{RequestID}] [%-5level] [%thread] [%logger{36}:%line] - %msg%n</pattern>
        </encoder>
    </appender>

    <logger name="org.springframework.web" level="DEBUG">
        <appender-ref ref="STDOUT" />
    </logger>

    <logger name="com.boot.mapper" level="DEBUG">
        <appender-ref ref="STDOUT" />
    </logger>

    <root level="INFO">
        <appender-ref ref="STDOUT" />
        <!--<appender-ref ref="FILE"/>-->
    </root>
</configuration>

4.编写entity

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Student {

    private Integer id;

    private String name;

    private String subject;

    private int score;
}

5.编写mapper

public interface StudentMapper {

    public List<Student> findAll();
}

6.编写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.boot.mapper.StudentMapper">

   <resultMap type="com.boot.entity.Student" id="BaseStudent">
      <id column="id" property="id"></id>
      <result column="name" property="name"/>
      <result column="subject" property="subject"/>
      <result column="score" property="score"/>
   </resultMap>

   <select id="findAll" resultMap="BaseStudent">
      select * from user
   </select>
   
</mapper>

7.启动类上加入包扫描@MapperScan("com.boot.mapper")

8.注入类，测试