Redis 整合实现 Mybatis 二级缓存

最新推荐文章于 2024-07-16 18:30:27 发布

杜莱

最新推荐文章于 2024-07-16 18:30:27 发布

阅读量155

点赞数

分类专栏： Redis 文章标签： redis

本文链接：https://blog.csdn.net/LaneDu/article/details/119710882

版权

Redis 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

Redis 和 MySQL 启动

初始化数据

➜  bin mysql -uroot -proot
mysql> create database test
    -> ;
Query OK, 1 row affected (0.00 sec)
mysql> use test
Database changed
mysql> create table user (
    ->     id int primary key,
    ->     name varchar(200),
    ->     address varchar(200))engine=innodb charset=utf8mb4;
Query OK, 0 rows affected (0.01 sec)
mysql> insert into user(id,name,address)valuues(1,'zahngsan','beijing');
Query OK, 1 row affected (0.02 sec)

创建 Springboot 项目

项目整体图

新建 springboot 项目

添加 druid 依赖之后

<?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.5.3</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.galaxy</groupId>
    <artifactId>redis-mybatis-cache</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>redis-mybatis-cache</name>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>11</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-redis</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.0</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.16</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <configuration>
                    <excludes>
                        <exclude>
                            <groupId>org.projectlombok</groupId>
                            <artifactId>lombok</artifactId>
                        </exclude>
                    </excludes>
                </configuration>
            </plugin>
        </plugins>
    </build>

</project>

添加配置文件 application.yaml

spring:
  datasource:
    url: jdbc:mysql://172.16.94.13:3306/test?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
    username: root
    password: root
    driver-class-name: com.mysql.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource
  redis:
    host: 172.16.94.13
    port: 6379
    jedis:
      pool:
        min-idle: 0
        max-idle: 8
        max-active: 8
        max-wait: -1ms
mybatis:
  type-aliases-package: com.galaxy.rcache.entity
  mapper-locations: classpath:mapper/*.xml

添加数据库 resources/mapper/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="com.galaxy.rcache.dao.UserDao" >

    <cache type="com.galaxy.rcache.utils.RedisCache" />

    <resultMap id="BaseResultMap" type="com.galaxy.rcache.entity.User" >

        <id column="id" property="id" jdbcType="INTEGER" />

        <result column="name" property="name" jdbcType="VARCHAR" />

        <result column="address" property="address" jdbcType="VARCHAR" />

    </resultMap>

    <sql id="Base_Column_List" >

id, name, address

</sql>

    <select id="selectUser" resultMap="BaseResultMap">

        select

        <include refid="Base_Column_List" />

        from user

    </select>

</mapper>

User

package com.galaxy.rcache.entity;

import lombok.Data;

import java.io.Serializable;

/**
 * @author lane
 * @date 2021年08月01日 下午7:26
 */
@Data
public class User implements Serializable {

    private Integer id;
    private String name;
    private String address;
}

UserDao

package com.galaxy.rcache.dao;

import com.galaxy.rcache.entity.User;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author lane
 * @date 2021年08月01日 下午7:25
 */
@Repository
public interface UserDao  {

   List<User> selectUser();

}

ApplicationContextHolder

package com.galaxy.rcache.utils;

import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import org.springframework.stereotype.Component;

/**
 * @author lane
 * @date 2021年08月01日 下午7:15
 */
@Component
public class ApplicationContextHolder implements ApplicationContextAware {
    private static ApplicationContext ctx;

    @Override
//向工具类注入 applicationContext
    public void setApplicationContext(ApplicationContext applicationContext) throws BeansException {
        ctx = applicationContext; //ctx 就是注入的 applicationContext

    }

//外部调用 ctx
    public static ApplicationContext getCtx() {

        return ctx;

    }

    public static <T> T getBean(Class<T> tClass) {

        return ctx.getBean(tClass);

    }

    @SuppressWarnings("unchecked")

    public static <T> T getBean(String name) {

        return (T) ctx.getBean(name);

    }

}

RedisCache

package com.galaxy.rcache.utils;

import org.apache.ibatis.cache.Cache;
import org.springframework.data.redis.core.RedisCallback;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.data.redis.core.ValueOperations;

import java.util.concurrent.TimeUnit;
import java.util.concurrent.locks.ReadWriteLock;
import java.util.concurrent.locks.ReentrantReadWriteLock;

/**
 * @author lane
 * @date 2021年08月01日 下午7:18
 */
public class RedisCache implements Cache {

    //缓存对象唯一标识

    private final String id; //orm 的框架都是按对象的方式缓存，而每个对象都需要一个唯一标识.

//用于事务性缓存操作的读写锁

    private static ReadWriteLock readWriteLock = new ReentrantReadWriteLock();

//处理事务性缓存中做的

//操作数据缓存的--跟着线程走的

    private RedisTemplate redisTemplate; //Redis 的模板负责将缓存对象写到 redis 服务器里面去

//缓存对象的是失效时间，30 分钟

    private static final long EXPRIRE_TIME_IN_MINUT = 30;

//构造方法---把对象唯一标识传进来

    public RedisCache(String id) {

        if (id == null) {

            throw new IllegalArgumentException("缓存对象 id 是不能为空的");

        }

        this.id = id;

    }

    @Override

    public String getId() {

        return this.id;

    }

//给模板对象 RedisTemplate 赋值，并传出去

    private RedisTemplate getRedisTemplate() {

        if (redisTemplate == null) { //每个连接池的连接都要获得 RedisTemplate

            redisTemplate = ApplicationContextHolder.getBean("redisTemplate");

        }

        return redisTemplate;

    }

/*

保存缓存对象的方法

*/

    @Override

    public void putObject(Object key, Object value) {

        try {

            RedisTemplate redisTemplate = getRedisTemplate();

//使用 redisTemplate 得到值操作对象

            ValueOperations operation = redisTemplate.opsForValue();

//使用值操作对象 operation 设置缓存对象

            operation.set(key, value, EXPRIRE_TIME_IN_MINUT, TimeUnit.MINUTES);

//TimeUnit.MINUTES 系统当前时间的分钟数

            System.out.println("缓存对象保存成功");

        } catch (Throwable t) {

            System.out.println("缓存对象保存失败" + t);

        }

    }

/*

获取缓存对象的方法

*/

    @Override

    public Object getObject(Object key) {

        try {

            RedisTemplate redisTemplate = getRedisTemplate();

            ValueOperations operations = redisTemplate.opsForValue();

            Object result = operations.get(key);

            System.out.println("获取缓存对象");

            return result;

        } catch (Throwable t) {

            System.out.println("缓存对象获取失败" + t);

            return null;

        }

    }

    @Override
    public Object removeObject(Object key) {
        try {

            RedisTemplate redisTemplate = getRedisTemplate();

            redisTemplate.delete(key);

            System.out.println("删除缓存对象成功！");

        } catch (Throwable t) {

            System.out.println("删除缓存对象失败！" + t);

        }

        return null;

    }


/*

删除缓存对象

*/
/*
    @Override
    public Object del(Object key) {

        try {

            RedisTemplate redisTemplate = getRedisTemplate();

            redisTemplate.delete(key);

            System.out.println("删除缓存对象成功！");

        } catch (Throwable t) {

            System.out.println("删除缓存对象失败！" + t);

        }

        return null;

    }
*/

/*

清空缓存对象

当缓存的对象更新了的化，就执行此方法

*/

    @Override

    public void clear() {

        RedisTemplate redisTemplate = getRedisTemplate();

//回调函数

        redisTemplate.execute((RedisCallback) collection -> {

            collection.flushDb();

            return null;

        });

        System.out.println("清空缓存对象成功！");

    }

//可选实现的方法

    @Override

    public int getSize() {

        return 0;

    }

    @Override

    public ReadWriteLock getReadWriteLock() {

        return readWriteLock;

    }

}

启动类

package com.galaxy;

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

@MapperScan("com.galaxy.rcache.dao")
@EnableCaching
@SpringBootApplication
public class RedisMybatisCacheApplication {

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

}

UserController

package com.galaxy.rcache.controller;

import com.galaxy.rcache.dao.UserDao;
import com.galaxy.rcache.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * @author lane
 * @date 2021年08月01日 下午7:37
 */
@RestController
@RequestMapping("/user")
public class UserController {

    @Autowired
    UserDao userDao;
    @GetMapping("/test")
    public List<User> test(){
        List<User> userList = userDao.selectUser();
        return  userList;
    }

}

访问测试地址

redis 查看缓存内容

杜莱

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
1
评论
Redis 整合实现 Mybatis 二级缓存

Redis 和 MySQL 启动初始化数据➜ bin mysql -uroot -prootmysql> create database test -> ;Query OK, 1 row affected (0.00 sec)mysql> use testDatabase changedmysql> create table user ( -> id int primary key, -> name varchar(
复制链接

扫一扫