1、对jedis连接池进行配置。使用jedis连接池初衷:jedis每次获取都要创建,不如创建池化的然后每次从连接池获取,用完再放回去,省去创建销毁的工序,也是比较省时的。
2、对于客户端经常访问不常变化的数据列表,可以使用redis来降低服务器频繁被访问带给数据库的压力。
下面是结合上面描述编写的样例:
1)在项目中引入jar包
<dependency>
<groupId>commons-beanutils</groupId>
<artifactId>commons-beanutils</artifactId>
<version>1.8.3</version>
</dependency>
<dependency>
<groupId>commons-logging</groupId>
<artifactId>commons-logging</artifactId>
<version>1.1.1</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.9</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>2.2.3</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>2.2.3</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.2.3</version>
</dependency>
<dependency>
<groupId>org.glassfish.web</groupId>
<artifactId>javax.servlet.jsp.jstl</artifactId>
<version>1.2.5</version>
</dependency>
<dependency>
<groupId>org.glassfish.web</groupId>
<artifactId>jstl-impl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.18</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>4.2.4.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>4.2.4.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.2.4.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>4.2.4.RELEASE</version>
</dependency>
2 )、新建JedisPoolUtil.java
package com.stu.jedis.util;
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;
import redis.clients.jedis.Jedis;
import redis.clients.jedis.JedisPool;
import redis.clients.jedis.JedisPoolConfig;
public class jedisPoolUtils { //把jedis连接池配置信息用文件加载形式
static JedisPool jedisPool;
static {
//加载jedis连接池配置文件信息,也可以直接放在src下面,直接取属性文件名称+后缀即可
InputStream inStream = jedisPoolUtils.class.getClassLoader()
.getResourceAsStream("com/stu/jedis/jedis.properties");
Properties properties = new Properties();
try {
//加载属性文件获取常量值
properties.load(inStream);
//设置jedis连接池配置信息
JedisPoolConfig poolConfig = new JedisPoolConfig();
poolConfig.setMaxIdle(Integer.parseInt(properties.getProperty("maxIdle")));
poolConfig.setMaxTotal(Integer.parseInt(properties.getProperty("maxTotal")));
//创建jedis连接池
jedisPool = new JedisPool(poolConfig, properties.getProperty("host"),
Integer.parseInt(properties.getProperty("port")));
} catch (IOException e) {
e.printStackTrace();
}
}
public static Jedis getJedis() {
return jedisPool.getResource();
}
}
3 )、在类路径下增加属性文件,或者直接在com/stu/jedis/ 路径下增加属性文件 jedis.properties
host=127.0.0.1
port=6379
maxTotal=50
maxIdle=10
4 ) 在service实现类里添加方法
/**
使用redis缓存前端经常访问或者数据较多的列表数据,且不经常变动的,可以第一次查询就存入redis缓存,之后可以从缓存直接获取数据。
*/
public String findAllJson() {
//获取redis客户端连接
Jedis jedis = jedisPoolUtils.getJedis();
String province_json = jedis.get("province");
//2从redis中查数据,判断否为null
if (province_json == null || province_json.length() == 0) {
//redis中没有数据
System.out.println("redis无数据,执行查库操作");
//查询数据并且存入redis
List<Province> ps = dao.findAll();
//将list序列化为json
ObjectMapper mapper = new ObjectMapper();
try {
province_json = mapper.writeValueAsString(ps);
} catch (JsonProcessingException e) {
e.printStackTrace();
}
//将json数据存入redis
jedis.set("province", province_json);
//归还jedis连接
jedis.close();
} else {
System.out.println("redis中有数据,走缓存查询");
}
return province_json;
}
5)如果数据会有修改,删除,新增的可能,则在修改该数据方法里,删除之前缓存的键值。