当我们需要经常调用数据库,然而数据库内数据较少时,可以将数据放到缓存当中,能有效的降低调用数据库的次数,并提高查询速度。这种方法常用于字典表。
配置redis
package com.allqj.gad_financial_expenditure_java.config;
import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.PropertyAccessor;
import com.fasterxml.jackson.databind.ObjectMapper;
import org.springframework.cache.CacheManager;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.data.redis.cache.RedisCacheManager;
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;
/**
* @Author WF
* @DesCription
* @Date 2019/5/10 11:25
**/
@Configuration
public class RedisConfig {
@Bean
public RedisTemplate<String,Object> redisTemplate(RedisConnectionFactory factory) {
RedisTemplate<String,Object> template=new RedisTemplate<>();
template.setConnectionFactory(factory);
Jackson2JsonRedisSerializer<Object> 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 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;
}
/**
* 采用RedisCacheManager作为缓存管理器
* @param connectionFactory
*/
@Bean
public CacheManager cacheManager(RedisConnectionFactory connectionFactory) {
return RedisCacheManager.create(connectionFactory);
}
}
具体的实现方法
@Override
@Cacheable(value = "typeName", key = "#code")
public String getBillTypeName(String code) {
if (null == code)
return "";
//查询数据库的方法,根据code获得一个名称
ExpenditureDicBillTypeEntity billTypeEntity = billTypeRepository.findByBillCodeAndIsdeleteFalse(code);
if (StringUtils.isEmpty(billTypeEntity))
return "";
return billTypeRepository.findByBillCodeAndIsdeleteFalse(code).getBillName();
}
这样获取,只有当缓存内没有key为code的数据时,才走方法内的实现,有key时,直接从缓存获取数据,不走方法内。
走第一遍的时候,缓存内存了这两条,此时像数据库内加一个0003,查询时,由于缓存内没有0003的key,会走里边的具体实现,从而向缓存内存0003的key
对了 不要忘了加pom
<!-- redis -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-redis</artifactId>
<version>1.4.7.RELEASE</version>
</dependency>
启动类要加@EnableCaching注解