SpringBoot+Mybatis+Redis整合

1.起步依赖配置

1.1 添加Mybatis的起步依赖

<!--mybatis起步依赖-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>

1.2添加数据库驱动坐标

<!-- MySQL连接驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>

1.3添加redis的起步依赖

<!-- 配置使用redis启动器 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId

2.application.properties配置文件配置

2.1添加数据库连接信息

#DB Configuration:
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/sboot_test?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&useSSL=true
spring.datasource.username=root
spring.datasource.password=root

#spring集成Mybatis环境
#pojo别名扫描包
mybatis.type-aliases-package=com.qyf.domain
#加载Mybatis映射文件
mybatis.mapper-locations=classpath:mapper/*.xml

2.2添加Redis的连接配置

#Redis
spring.redis.host=127.0.0.1
spring.redis.port=6379

3.编写实体类

4.编写Mapper接口

@Mapper
public interface StudentMapper {

    /**
     * 查询所有学生信息
     * @return
     */
    public List<Student> findAll();
}

5.配置Mapper映射文件

<?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.qyf.mapper.StudentMapper">
    <select id="findAll" resultType="student">
        select * from student
    </select>
</mapper>

6.编写测试Controller类

@RestController
public class StudentController {
    @Autowired
    private StudentMapper studentMapper;

    @RequestMapping("/findAll")
    public List<Student> findAll(){
        List<Student> list = studentMapper.findAll();
        System.out.println(list);
        return list;
    }
}