https://www.cnblogs.com/huanglei2010/articles/9597523.html
查询最近两个月的数据
<![CDATA[SELECT accountval from 表名 WHERE failcode='code' and DATE_SUB(CURDATE(), INTERVAL 2 MONTH) <= date(timestart)]]>
查询最近两天的数据
<![CDATA[SELECT accountval from 表名 WHERE failcode='code' and DATE_SUB(CURDATE(), INTERVAL 2 DAY) <= date(timestart)]]>
//封装为方法
public Object sSet(String key, final List<String> list) {
// 获取key编码方式
final StringRedisSerializer stringRedisSerializer = (StringRedisSerializer) redisTemplate.getKeySerializer();
//获取值编码方式
final RedisSerializer<String> valueSerializer = (RedisSerializer<String>) redisTemplate.getValueSerializer();
//获取key对应的byte[]
final byte[] rawKey = stringRedisSerializer.serialize(key);
redisTemplate.executePipelined(new RedisCallback() {
@Override
public Object doInRedis(RedisConnection connection)
throws DataAccessException {
for (String str : list) {
byte[] rawStr =valueSerializer.serialize(str);
//在set中添加数据
connection.sAdd(rawKey,rawStr);
}
connection.closePipeline();
return null;
}
});
return null;
//封装为方法
public Object sSet(String key, final List<String> list) {
// 获取key编码方式
final StringRedisSerializer stringRedisSerializer = (StringRedisSerializer) redisTemplate.getKeySerializer();
//获取值编码方式
final RedisSerializer<String> valueSerializer = (RedisSerializer<String>) redisTemplate.getValueSerializer();
//获取key对应的byte[]
final byte[] rawKey = stringRedisSerializer.serialize(key);
redisTemplate.executePipelined(new RedisCallback() {
@Override
public Object doInRedis(RedisConnection connection)
throws DataAccessException {
for (String str : list) {
byte[] rawStr =valueSerializer.serialize(str);
//在set中添加数据
connection.sAdd(rawKey,rawStr);
}
connection.closePipeline();
return null;
}
});
return null;
}