配置文件
spring.datasource.druid.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false
spring.datasource.druid.username=root
spring.datasource.druid.password=sunyue
spring.datasource.druid.initial-size=1
spring.datasource.druid.min-idle=1
spring.datasource.druid.max-active=20
spring.datasource.druid.test-on-borrow=true
spring.datasource.druid.driver-class-name=com.mysql.jdbc.Driver
mybatis.type-aliases-package=com.sunyue.test.entity
mybatis.mapper-locations=classpath:mapper/*.xml
#打印数据库的操作
logging.level.com.sunyue.test.dao=debug
#redis缓存
### 配置Redis
mybatis.configuration.cache-enabled=true
# Redis数据库索引(默认为0)
spring.redis.database=0
# Redis服务器地址
spring.redis.host=152.136.30.116
# Redis服务器连接端口
spring.redis.port=6379
# Redis服务器连接密码(默认为空)
spring.redis.password=sunyue
# 连接池最大连接数(使用负值表示没有限制)
spring.redis.jedis.pool.max-idle=200
# 连接池最大阻塞等待时间(使用负值表示没有限制)
spring.redis.jedis.pool.max-wait=-1
# 连接池中的最小空闲连接
spring.redis.jedis.pool.min-idle=0
# 连接超时时间(毫秒)
spring.redis.timeout=1000
缓存实体类
这是我们要向Redis中缓存的对象
package com.sunyue.test.entity;
import lombok.Data;
import lombok.experimental.Accessors;
import java.io.Serializable;
import java.util.Date;
@Data
@Accessors(chain = true)
public class TestUser implements Serializable {
private String id;
private String name;
private Integer age;
private Date bir;
}
Mybatis Dao & Mapper
package com.sunyue.test.dao;
import com.sunyue.test.entity.TestUser;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
@Mapper
public interface TestUserMapper {
List<TestUser> findAll();
TestUser selectOne(String id);
void insert(TestUser testUser);
void update(TestUser testUser);
void delete(String id);
}
Mapper:
直接启用Mybatis的<-cache>标签,缓存是本机缓存,所以我们需要实现自定义Redis缓存
<?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.sunyue.test.dao.TestUserMapper">
<!-- 开启二级缓存 需要entity开启序列化 type指定自定义缓存策略 -->
<cache type="com.sunyue.test.redis.RedisCache"/>
<!-- 关联查询时,需要保证各方缓存的数据都是最新的,采用共享缓存方案 -->
<!-- <cache-ref namespace="com.junsir.dao.PersonDao"/>-->
<select id="findAll" resultType="TestUser">
select * from test_user
</select>
<select id="selectOne" resultType="TestUser">
select * from test_user where id=#{id}
</select>
<insert id="insert">
insert into test_user (id,name,age,bir) value (#{id},#{name},#{age},#{bir})
</insert>
<update id="update" parameterType="com.sunyue.test.entity.TestUser">
update test_user set name = #{name},age=#{age},bir=#{bir} where id = #{id}
</update>
<delete id="delete">
delete from test_user where id = #{id}
</delete>
</mapper>
RedisCache.java:
此类需要实现org.apache.ibatis.cache.Cache接口,才可以在Mapper中进行指定
package com.sunyue.test.redis;
import com.sunyue.test.utils.ApplicationContextUtils;
import org.apache.ibatis.cache.Cache;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.data.redis.serializer.StringRedisSerializer;
import org.springframework.util.DigestUtils;
import java.util.concurrent.locks.ReadWriteLock;
/**
* 本类由mybatis初始化 启动时并无法由spring容器管理(盲猜参数无法传递id),故无法注入拿到RedisTemplate
* 要拿到RedisTemplate 需要动下工厂 在工厂启动时拿到RedisTemplate
*
* 实现细节:
* 多表关联查询下的内容保持最新 - 由于DB增删改只会使Redis清空对应key的缓存 所以目的就是让有关联的缓存数据同时进同时出
*
* 实现完毕之后的优化问题:
* 1.key过长会影响redis性能,采用MD5算法对key进行处理,这里利用的是MD5加密算法的唯一性
* */
public class RedisCache implements Cache {
//自定义Cache必要条件
private final String id;
//根据断点 : id:mapper的namespace
public RedisCache(String id) {
this.id = id;
}
//返回cache的唯一标识
@Override
public String getId() {
return this.id;
}
//重点实现 加入缓存
@Override
public void putObject(Object key, Object value) {
System.out.println("加入缓存:key================》" + key + "值:value ===================》" + value);
RedisTemplate redisTemplate = getRedisTemplate();
redisTemplate.opsForHash().put(id.toString(),keyToMd5(key.toString()),value);
}
//重点实现 查询缓存
@Override
public Object getObject(Object key) {
System.out.println("查询缓存:key================》" + key );
RedisTemplate redisTemplate = getRedisTemplate();
return redisTemplate.opsForHash().get(id.toString(),keyToMd5(key.toString()));
}
//根据指定的key删除缓存 目前没有实现
@Override
public Object removeObject(Object o) {
return null;
}
//清空缓存 执行增删改的时候都会进行clear
@Override
public void clear() {
System.out.println("清空缓存");
RedisTemplate redisTemplate = getRedisTemplate();
//清空缓存
redisTemplate.delete(id.toString());
}
//计算缓存数量
@Override
public int getSize() {
RedisTemplate redisTemplate = getRedisTemplate();
//获取哈希中的键值对数量
return redisTemplate.opsForHash().size(id.toString()).intValue();
}
@Override
public ReadWriteLock getReadWriteLock() {
return null;
}
//统一加工redisTemplate 并返回
private RedisTemplate getRedisTemplate(){
//获取redisTemplate
RedisTemplate redisTemplate = (RedisTemplate) ApplicationContextUtils.getBean("redisTemplate");
//设置序列化策略,因为设置了RedisConfig实例
/* redisTemplate.setKeySerializer(new StringRedisSerializer());
redisTemplate.setHashKeySerializer(new StringRedisSerializer());*/
return redisTemplate;
}
//优化: 对key做MD5处理
private String keyToMd5(String key){
return DigestUtils.md5DigestAsHex(key.getBytes());
}
}
redis序列化
package com.sunyue.test.redis;
import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.PropertyAccessor;
import com.fasterxml.jackson.databind.ObjectMapper;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.data.redis.connection.RedisConnectionFactory;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.data.redis.serializer.Jackson2JsonRedisSerializer;
import org.springframework.data.redis.serializer.StringRedisSerializer;
@Configuration
public class RedisConfig {
/**
* 由于原生的redis自动装配,在存储key和value时,没有设置序列化方式,故自己创建redisTemplate实例
* redis的默认方式是JdkSerializationRedisSerializer,key和value都是JdkSerializationRedisSerializer方式的序列化,好处是可以直接支持Object
* 但是如果需要取值则需要序列化 1) "\xac\xed\x00\x05t\x00\"com.sunyue.test.dao.TestUserMapper"(没有序列化时)
* 2) "com.sunyue.test.dao.TestUserMapper"(序列化好的)
* RedisTemplate<Object, Object> ==> RedisTemplate<String, Object(通常需要key为String,则key设置为stringRedisSerializer这样,值不需要)
* @param factory
* @return
*/
@Bean
public RedisTemplate<String, Object> redisTemplate(RedisConnectionFactory factory) {
RedisTemplate<String, Object> template = new RedisTemplate<>();
template.setConnectionFactory(factory);
Jackson2JsonRedisSerializer jackson2JsonRedisSerializer = new Jackson2JsonRedisSerializer(Object.class);
ObjectMapper om = new ObjectMapper();
om.setVisibility(PropertyAccessor.ALL, JsonAutoDetect.Visibility.ANY);
om.enableDefaultTyping(ObjectMapper.DefaultTyping.NON_FINAL);
jackson2JsonRedisSerializer.setObjectMapper(om);
// 使用StringRedisSerializer来序列化/反序列化redis的key值
StringRedisSerializer stringRedisSerializer = new StringRedisSerializer();
// key采用String的序列化方式
template.setKeySerializer(stringRedisSerializer);
// hash的key也采用String的序列化方式
template.setHashKeySerializer(stringRedisSerializer);
// value序列化方式采用jackson
template.setValueSerializer(jackson2JsonRedisSerializer);
// hash的value序列化方式采用jackson
template.setHashValueSerializer(jackson2JsonRedisSerializer);
template.afterPropertiesSet();
return template;
}
}
业务层server实现
package com.sunyue.test.server.serverImpl;
import com.sunyue.test.dao.TestUserMapper;
import com.sunyue.test.entity.TestUser;
import com.sunyue.test.server.TestUserServer;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import java.util.List;
@Service
public class TestUserServerImpl implements TestUserServer {
@Autowired
private TestUserMapper testUserMapper;
@Override
@Transactional
public List<TestUser> selectAll() {
return testUserMapper.findAll();
}
@Override
@Transactional(rollbackFor = Exception.class)
public TestUser selectByOne(String id){
return testUserMapper.selectOne(id);
}
@Override
@Transactional(rollbackFor = Exception.class)
public void insert(TestUser testUser) {
testUserMapper.insert(testUser);
//推荐:在业务层将异常抛出
/* throw new RuntimeException("添加发生异常了..");*/
}
@Override
public void delete(String id) {
testUserMapper.delete(id);
}
@Override
public void update(TestUser testUser) {
testUserMapper.update(testUser);
}
}
测试类
import com.sunyue.test.TestApplication;
import com.sunyue.test.entity.TestUser;
import com.sunyue.test.server.TestUserServer;
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.test.context.junit4.SpringRunner;
import java.util.Date;
import java.util.List;
import java.util.UUID;
@SpringBootTest(classes = TestApplication.class)
@RunWith(SpringRunner.class)
public class RedisTest {
@Autowired
private TestUserServer testUserServer;
@Test
public void redisTest() {
TestUser testUser = new TestUser();
testUser.setId(UUID.randomUUID().toString());
testUser.setName("孙跃");
testUser.setBir(new Date());
testUser.setAge(24);
testUserServer.insert(testUser);
TestUser testUser1 = new TestUser();
testUser1.setId(UUID.randomUUID().toString());
testUser1.setName("孙越");
testUser1.setBir(new Date());
testUser1.setAge(22);
testUserServer.insert(testUser1);
}
@Test
public void delete(){
testUserServer.delete("93bc9818-a1fd-4012-9f75-f15d6653f912");
}
@Test
public void update(){
TestUser testUser = new TestUser();
testUser.setId("1a88f8dc-b9aa-45cf-af53-38e5a6d52b38");
testUser.setName("孙跃1w");
testUser.setBir(new Date());
testUser.setAge(18);
testUserServer.update(testUser);
}
@Test
public void select() {
List<TestUser> testUsers = testUserServer.selectAll();
testUsers.forEach(System.out::println);
System.out.println(testUserServer.selectByOne("1a88f8dc-b9aa-45cf-af53-38e5a6d52b38"));
}
}
log查看
insert方法:
2020-12-01 21:44:25.300 INFO 3424 --- [ main] RedisTest : Started RedisTest in 3.349 seconds (JVM running for 3.94)
2020-12-01 21:44:25.416 DEBUG 3424 --- [ main] c.sunyue.test.dao.TestUserMapper.insert : ==> Preparing: insert into test_user (id,name,age,bir) value (?,?,?,?)
2020-12-01 21:44:25.439 DEBUG 3424 --- [ main] c.sunyue.test.dao.TestUserMapper.insert : ==> Parameters: 5d7af197-a25e-418a-a087-7717bd5d4483(String), 孙跃(String), 24(Integer), 2020-12-01 21:44:25.379(Timestamp)
2020-12-01 21:44:25.446 DEBUG 3424 --- [ main] c.sunyue.test.dao.TestUserMapper.insert : <== Updates: 1
清空缓存
2020-12-01 21:44:25.510 INFO 3424 --- [ main] io.lettuce.core.EpollProvider : Starting without optional epoll library
2020-12-01 21:44:25.510 INFO 3424 --- [ main] io.lettuce.core.KqueueProvider : Starting without optional kqueue library
2020-12-01 21:44:25.794 DEBUG 3424 --- [ main] c.sunyue.test.dao.TestUserMapper.insert : ==> Preparing: insert into test_user (id,name,age,bir) value (?,?,?,?)
2020-12-01 21:44:25.794 DEBUG 3424 --- [ main] c.sunyue.test.dao.TestUserMapper.insert : ==> Parameters: 07222415-adc0-4117-8f85-4a19ea0633d2(String), 孙越(String), 22(Integer), 2020-12-01 21:44:25.792(Timestamp)
2020-12-01 21:44:25.794 DEBUG 3424 --- [ main] c.sunyue.test.dao.TestUserMapper.insert : <== Updates: 1
清空缓存
2020-12-01 21:44:25.843 INFO 3424 --- [ Thread-5] o.s.w.c.s.GenericWebApplicationContext : Closing org.springframework.web.context.support.GenericWebApplicationContext@1f760b47: startup date [Tue Dec 01 21:44:22 CST 2020]; root of context hierarchy
2020-12-01 21:44:26.976 INFO 3424 --- [ Thread-5] com.alibaba.druid.pool.DruidDataSource : {dataSource-1} closed
update方法:
2020-12-01 21:45:38.336 INFO 10076 --- [ main] RedisTest : Started RedisTest in 3.47 seconds (JVM running for 4.07)
2020-12-01 21:45:38.457 DEBUG 10076 --- [ main] c.sunyue.test.dao.TestUserMapper.update : ==> Preparing: update test_user set name = ?,age=?,bir=? where id = ?
2020-12-01 21:45:38.487 DEBUG 10076 --- [ main] c.sunyue.test.dao.TestUserMapper.update : ==> Parameters: 孙跃1w(String), 18(Integer), 2020-12-01 21:45:38.427(Timestamp), 1a88f8dc-b9aa-45cf-af53-38e5a6d52b38(String)
2020-12-01 21:45:38.497 DEBUG 10076 --- [ main] c.sunyue.test.dao.TestUserMapper.update : <== Updates: 1
清空缓存
2020-12-01 21:45:38.568 INFO 10076 --- [ main] io.lettuce.core.EpollProvider : Starting without optional epoll library
2020-12-01 21:45:38.568 INFO 10076 --- [ main] io.lettuce.core.KqueueProvider : Starting without optional kqueue library
2020-12-01 21:45:38.852 INFO 10076 --- [ Thread-5] o.s.w.c.s.GenericWebApplicationContext : Closing org.springframework.web.context.support.GenericWebApplicationContext@1f760b47: startup date [Tue Dec 01 21:45:35 CST 2020]; root of context hierarchy
2020-12-01 21:45:39.986 INFO 10076 --- [ Thread-5] com.alibaba.druid.pool.DruidDataSource : {dataSource-1} closed
delete方法:
2020-12-01 21:46:29.897 INFO 6072 --- [ main] RedisTest : Started RedisTest in 3.391 seconds (JVM running for 3.992)
2020-12-01 21:46:30.009 DEBUG 6072 --- [ main] c.sunyue.test.dao.TestUserMapper.delete : ==> Preparing: delete from test_user where id = ?
2020-12-01 21:46:30.029 DEBUG 6072 --- [ main] c.sunyue.test.dao.TestUserMapper.delete : ==> Parameters: 1a88f8dc-b9aa-45cf-af53-38e5a6d52b38(String)
2020-12-01 21:46:30.036 DEBUG 6072 --- [ main] c.sunyue.test.dao.TestUserMapper.delete : <== Updates: 1
清空缓存
2020-12-01 21:46:30.098 INFO 6072 --- [ main] io.lettuce.core.EpollProvider : Starting without optional epoll library
2020-12-01 21:46:30.098 INFO 6072 --- [ main] io.lettuce.core.KqueueProvider : Starting without optional kqueue library
2020-12-01 21:46:30.389 INFO 6072 --- [ Thread-5] o.s.w.c.s.GenericWebApplicationContext : Closing org.springframework.web.context.support.GenericWebApplicationContext@1f760b47: startup date [Tue Dec 01 21:46:26 CST 2020]; root of context hierarchy
2020-12-01 21:46:31.522 INFO 6072 --- [ Thread-5] com.alibaba.druid.pool.DruidDataSource : {dataSource-1} closed
select方法:
2020-12-01 21:48:13.949 INFO 2924 --- [ main] RedisTest : Started RedisTest in 3.355 seconds (JVM running for 3.974)
查询缓存:key================》448135888:3833733049:com.sunyue.test.dao.TestUserMapper.findAll:0:2147483647:select * from test_user:SqlSessionFactoryBean
2020-12-01 21:48:14.130 INFO 2924 --- [ main] io.lettuce.core.EpollProvider : Starting without optional epoll library
2020-12-01 21:48:14.132 INFO 2924 --- [ main] io.lettuce.core.KqueueProvider : Starting without optional kqueue library
2020-12-01 21:48:14.426 DEBUG 2924 --- [ main] com.sunyue.test.dao.TestUserMapper : Cache Hit Ratio [com.sunyue.test.dao.TestUserMapper]: 0.0
2020-12-01 21:48:14.434 DEBUG 2924 --- [ main] c.s.test.dao.TestUserMapper.findAll : ==> Preparing: select * from test_user
2020-12-01 21:48:14.452 DEBUG 2924 --- [ main] c.s.test.dao.TestUserMapper.findAll : ==> Parameters:
2020-12-01 21:48:14.466 DEBUG 2924 --- [ main] c.s.test.dao.TestUserMapper.findAll : <== Total: 5
加入缓存:key================》448135888:3833733049:com.sunyue.test.dao.TestUserMapper.findAll:0:2147483647:select * from test_user:SqlSessionFactoryBean值:value ===================》[TestUser(id=07222415-adc0-4117-8f85-4a19ea0633d2, name=孙越, age=22, bir=Tue Dec 01 00:00:00 CST 2020), TestUser(id=5d7af197-a25e-418a-a087-7717bd5d4483, name=孙跃, age=24, bir=Tue Dec 01 00:00:00 CST 2020), TestUser(id=695601aa-4ad4-449f-92a3-bbae5cc432b0, name=孙越, age=22, bir=Mon Nov 30 00:00:00 CST 2020), TestUser(id=8c2e2f28-d6f1-48e6-930b-0cf431667089, name=孙跃, age=24, bir=Mon Nov 30 00:00:00 CST 2020), TestUser(id=a2bf3c23-2024-43f1-a328-b09331606c56, name=孙跃, age=24, bir=Mon Nov 30 00:00:00 CST 2020)]
TestUser(id=07222415-adc0-4117-8f85-4a19ea0633d2, name=孙越, age=22, bir=Tue Dec 01 00:00:00 CST 2020)
TestUser(id=5d7af197-a25e-418a-a087-7717bd5d4483, name=孙跃, age=24, bir=Tue Dec 01 00:00:00 CST 2020)
TestUser(id=695601aa-4ad4-449f-92a3-bbae5cc432b0, name=孙越, age=22, bir=Mon Nov 30 00:00:00 CST 2020)
TestUser(id=8c2e2f28-d6f1-48e6-930b-0cf431667089, name=孙跃, age=24, bir=Mon Nov 30 00:00:00 CST 2020)
TestUser(id=a2bf3c23-2024-43f1-a328-b09331606c56, name=孙跃, age=24, bir=Mon Nov 30 00:00:00 CST 2020)
查询缓存:
key================》-1510582337:937263828:com.sunyue.test.dao.TestUserMapper.selectOne:0:2147483647:select * from test_user where id=?:1a88f8dc-b9aa-45cf-af53-38e5a6d52b38:SqlSessionFactoryBean
2020-12-01 21:48:14.596 DEBUG 2924 --- [ main] com.sunyue.test.dao.TestUserMapper : Cache Hit Ratio [com.sunyue.test.dao.TestUserMapper]: 0.0
2020-12-01 21:48:14.596 DEBUG 2924 --- [ main] c.s.test.dao.TestUserMapper.selectOne : ==> Preparing: select * from test_user where id=?
2020-12-01 21:48:14.596 DEBUG 2924 --- [ main] c.s.test.dao.TestUserMapper.selectOne : ==> Parameters: 1a88f8dc-b9aa-45cf-af53-38e5a6d52b38(String)
2020-12-01 21:48:14.596 DEBUG 2924 --- [ main] c.s.test.dao.TestUserMapper.selectOne : <== Total: 0
加入缓存:key================》-1510582337:937263828:com.sunyue.test.dao.TestUserMapper.selectOne:0:2147483647:select * from test_user where id=?:1a88f8dc-b9aa-45cf-af53-38e5a6d52b38:SqlSessionFactoryBean值:value ===================》[]
null
2020-12-01 21:48:14.645 INFO 2924 --- [ Thread-5] o.s.w.c.s.GenericWebApplicationContext : Closing org.springframework.web.context.support.GenericWebApplicationContext@1f760b47: startup date [Tue Dec 01 21:48:10 CST 2020]; root of context hierarchy
2020-12-01 21:48:15.766 INFO 2924 --- [ Thread-5] com.alibaba.druid.pool.DruidDataSource : {dataSource-1} closed
再次select方法:
2020-12-01 21:49:28.358 INFO 9744 --- [ main] RedisTest : Started RedisTest in 3.46 seconds (JVM running for 4.048)
查询缓存:key================》448135888:3833733049:com.sunyue.test.dao.TestUserMapper.findAll:0:2147483647:select * from test_user:SqlSessionFactoryBean
2020-12-01 21:49:28.548 INFO 9744 --- [ main] io.lettuce.core.EpollProvider : Starting without optional epoll library
2020-12-01 21:49:28.550 INFO 9744 --- [ main] io.lettuce.core.KqueueProvider : Starting without optional kqueue library
2020-12-01 21:49:28.887 DEBUG 9744 --- [ main] com.sunyue.test.dao.TestUserMapper : Cache Hit Ratio [com.sunyue.test.dao.TestUserMapper]: 1.0
TestUser(id=07222415-adc0-4117-8f85-4a19ea0633d2, name=孙越, age=22, bir=Tue Dec 01 00:00:00 CST 2020)
TestUser(id=5d7af197-a25e-418a-a087-7717bd5d4483, name=孙跃, age=24, bir=Tue Dec 01 00:00:00 CST 2020)
TestUser(id=695601aa-4ad4-449f-92a3-bbae5cc432b0, name=孙越, age=22, bir=Mon Nov 30 00:00:00 CST 2020)
TestUser(id=8c2e2f28-d6f1-48e6-930b-0cf431667089, name=孙跃, age=24, bir=Mon Nov 30 00:00:00 CST 2020)
TestUser(id=a2bf3c23-2024-43f1-a328-b09331606c56, name=孙跃, age=24, bir=Mon Nov 30 00:00:00 CST 2020)
查询缓存:key================》-1510582337:937263828:com.sunyue.test.dao.TestUserMapper.selectOne:0:2147483647:select * from test_user where id=?:1a88f8dc-b9aa-45cf-af53-38e5a6d52b38:SqlSessionFactoryBean
2020-12-01 21:49:28.933 DEBUG 9744 --- [ main] com.sunyue.test.dao.TestUserMapper : Cache Hit Ratio [com.sunyue.test.dao.TestUserMapper]: 1.0
null
2020-12-01 21:49:28.936 INFO 9744 --- [ Thread-5] o.s.w.c.s.GenericWebApplicationContext : Closing org.springframework.web.context.support.GenericWebApplicationContext@1f760b47: startup date [Tue Dec 01 21:49:25 CST 2020]; root of context hierarchy
2020-12-01 21:49:30.072 INFO 9744 --- [ Thread-5] com.alibaba.druid.pool.DruidDataSource : {dataSource-1} closed
总结一下
mybatis实现分布式缓存中增删改会直接清空缓存,查询会去查redis数据库,如果没有再去查数据库获取,如果redis缓存中存在则不需要查询数据库直接可以在缓存中获取值