SpringBoot集成mybatis、redis和Junit框架案例

案例目录结构

1.坐标（pom）

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.0.1.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>edu.xiao</groupId>
    <artifactId>springboot_mybatis</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>springboot_mybatis</name>
    <description>Demo project for Spring Boot</description>

    <properties>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.2</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--mybatis的spring起步依赖-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
        <!--添加数据库坐标-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!--springBoot集成Junit-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <!--配置redis启动器-->
        <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-redis</artifactId>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

2.写sql语句（UserMapper.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="edu.xiao.springboot_mybatis.mapper.IUserMapper">
    <select id="findAllUser" resultType="user">
        select * from user
    </select>
</mapper>

3.配置数据库、mybatis以及redis(application.properties)

#配置数据库
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql:///ssm?useUnicode=true&characterEncoding=UTF-8&useSSL=false
spring.datasource.username=root
spring.datasource.password=y426759813.

#配2,置mybatis的信息
#spring集成Mybatis环境
#pojo别名扫描包
mybatis.type-aliases-package=edu.xiao.springboot_mybatis.pojo
#加载Mybatis映射文件
mybatis.mapper-locations=classpath:mapper/*Mapper.xml

#redis配置
spring.redis.host=127.0.0.1
spring.redis.port=6379

4.编写mapper类（IUserMapper.java）

package edu.xiao.springboot_mybatis.mapper;

import edu.xiao.springboot_mybatis.pojo.User;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface IUserMapper {
   
    List<User> findAllUser();

}

5. 编写service类

package edu.xiao.springboot_mybatis.service;

import edu.xiao.springboot_mybatis.pojo.User;

import java.util.List;

public interface IUserService {
   
    List<User> findAllUser();
}

package edu.xiao.springboot_mybatis.service.impl;

import edu.xiao.springboot_mybatis.mapper.IUserMapper;
import edu.xiao.springboot_mybatis.pojo.User;
import edu.xiao.springboot_mybatis.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserService implements IUserService {
   
    @Autowired
    private IUserMapper mapper;
    @Override
    public List<User> findAllUser() {
   
        return mapper.findAllUser();
    }
}

6.controller类（UserController）

暂时没用到,因为案例使用Junit测试

package edu.xiao.springboot_mybatis.controller;

import edu.xiao.springboot_mybatis.mapper.IUserMapper;
import edu.xiao.springboot_mybatis.pojo.User;
import edu.xiao.springboot_mybatis.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.List;

@Controller
@RequestMapping("/user")
public class UserController {
   
    @Autowired
    private IUserService service;

    @RequestMapping("/findAllUser")
    @ResponseBody
    public List<User> findAllUser(){
   
        List<User> allUser = service.findAllUser();
        System.out.println(allUser);
        return allUser;
    }
}

7.启动类（SpringbootMybatisApplication）

package edu.xiao.springboot_mybatis;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class SpringbootMybatisApplication {
   

    public static void main(String[] args) {
   
        SpringApplication.run(SpringbootMybatisApplication.class, args);
    }

}

8.测试代码（SpringbootMybatisApplicationTests）

package edu.xiao.springboot_mybatis;

import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.ObjectMapper;
import edu.xiao.springboot_mybatis.pojo.User;
import edu.xiao.springboot_mybatis.service.IUserService;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.test.context.junit4.SpringRunner;

import java.util.List;

@RunWith(SpringRunner.class)
@SpringBootTest(classes = SpringbootMybatisApplication.class)/*加入引导类*/
public class SpringbootMybatisApplicationTests {
   
    @Autowired
    private IUserService service;
    @Autowired
    private RedisTemplate<String,String> redisTemplate;
    @Test
    public void test() throws JsonProcessingException {
   
        String s = redisTemplate.boundValueOps("user.findAll").get();
        if (null==s){
   
            List<User> allUser = service.findAllUser();
            ObjectMapper mapper = new ObjectMapper();
            String string = mapper.writeValueAsString(allUser);
            redisTemplate.boundValueOps("user.findAll").set(string);
            System.out.println("数据库查询···");
            System.out.println(allUser);
        }else {
   
            System.out.println("redis查询···");
            System.out.println(s);
        }
    }

}

9.下载redis服务器

window下redis服务器

https://download.csdn.net/download/Android_Cob/12334344
启动redis-server

10.测试代码

首次查询

第二次查询