redis 缓存数据库 spring-data-redis 在set中批量插入数pipline

 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;
        
    }