Redis整合

Redis

redis有5种数据类型

1.String-字符串

2.list-列表

3.set-集合

4.zset-

5.hash -有序集合

在Redis命令行中增删改查数据

1.String-字符串

语法 key是字段名 values是需要存的值

存值:set key value

取值:get key

存定时值:setex k 有效时(秒) v

删值:del key

127.0.0.1:6379> set name 123                --给值        
OK
127.0.0.1:6379> set password 321
OK
127.0.0.1:6379> get name                    --获取值
"123"
127.0.0.1:6379> setex yzm 20 435213         --定时值
OK
127.0.0.1:6379> del name                    --删除值
(integer) 1
127.0.0.1:6379> del password                --删除值
(integer) 1
127.0.0.1:6379> setex yzm 20 41454154       --定时值
OK                                                                                                     

2.list-列表

从左边存储:lpush k v 可以多个一起存,用空格隔开

从右边存储:rpush k v 可以多个一起存,用空格隔开

取:lrange k start stop(-1代表所有元素) --查询所有

从左边删:lpop k --删除左的第一个

从右边删:rpop k --删除右的第一个

(integer) 2
127.0.0.1:6379> lpush password 1 2 3 4 5                --从左边开始添加
(integer) 5
127.0.0.1:6379> lrange name 0 -1                        --查询所有  0 到-1就是所有
1) "123"
2) "123"
127.0.0.1:6379> lrange password 0 -1                    --查询所有  0 到-1就是所有
1) "5"
2) "4"
3) "3"
4) "2"
5) "1"
127.0.0.1:6379> lpop name                               -- 左删除
"123"
127.0.0.1:6379> rpush name 1 2 3 4 5                    -- 右添加
(integer) 6
127.0.0.1:6379> lrange name 0 -1                        --查询所有  0 到-1就是所有
1) "123"
2) "1"
3) "2"
4) "3"
5) "4"
6) "5"
127.0.0.1:6379>
127.0.0.1:6379> lpop name                               --  左删除
"123"
127.0.0.1:6379> rpop name                               --右删除
"5"
127.0.0.1:6379>
​
​

3.set-集合

Redis 的 Set 是 string 类型的无序集合。

集合是通过哈希表实现的,所以添加,删除,查找的复杂度都是 O(1)。

sadd key member-添加

smembers s1查询

127.0.0.1:6379> sadd s1 1 2 3 4
(integer) 4
127.0.0.1:6379> smebers s1
(error) ERR unknown command `smebers`, with args beginning with: `s1`,
127.0.0.1:6379> smembers s1
1) "1"
2) "2"
3) "3"
4) "4"
127.0.0.1:6379>
​
​
​
​
​

4.zset-有序集合

Redis zset 和 set 一样也是string类型元素的集合,且不允许重复的成员。

不同的是每个元素都会关联一个double类型的分数。redis正是通过分数来为集合中的成员进行从小到大的排序。

zset的成员是唯一的,但分数(score)却可以重复。

添加 zadd s2 0 1

查询 zrange s2 0 -1 withscores

127.0.0.1:6379> zadd s2 0 1
(integer) 1
127.0.0.1:6379> zadd s3 1 1
(integer) 1
127.0.0.1:6379> zrangebyscore s2 0 -1
(empty list or set)
127.0.0.1:6379> zadd s2 1 1
(integer) 0
127.0.0.1:6379> zadd s2 5 1
(integer) 0
127.0.0.1:6379> zadd s2 4 123
(integer) 1
127.0.0.1:6379> zrange s2 0 -1 withscore
(error) ERR syntax error
127.0.0.1:6379>  zrange s2 0 -1 withscores
1) "123"
2) "4"
3) "1"
4) "5"
127.0.0.1:6379>  zrange s2 0 -1 withscore [WITHSCORES]                                                                  

5.hash

Redis hash 是一个键值(key=>value)对集合。

Redis hash 是一个 string 类型的 field 和 value 的映射表,hash 特别适合用于存储对象。

添加 HMSET runoob field1 "Hello" field2 "World"

查询 HGET runoob field1

127.0.0.1:6379> hmset run1 aaa run2 bbb
(error) ERR wrong number of arguments for HMSET
127.0.0.1:6379>  hmset  run1 aaa run2 bbb
(error) ERR wrong number of arguments for HMSET
127.0.0.1:6379> hmset run1 "aaa"
(error) ERR wrong number of arguments for 'hmset' command
127.0.0.1:6379> HMSET runoob field1 "Hello" field2 "World"
OK
127.0.0.1:6379>  HMSET runoob field1 "Hello"
OK
127.0.0.1:6379>  HMSET runoob field3 "Hello"
OK
127.0.0.1:6379> HGET runoob field1
"Hello"
127.0.0.1:6379> HGET runoob field2
"World"
127.0.0.1:6379> HGET runoob field3
"Hello"
127.0.0.1:6379>
​
​

SSMR

1.pom

<?xml version="1.0" encoding="UTF-8"?>
​
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
​
  <groupId>org.example</groupId>
  <artifactId>Demo_11.29</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>
​
  <name>Demo_11.29 Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>
  <!--统一管理所有jar包版本号-->
  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.8</maven.compiler.source>
    <maven.compiler.target>1.8</maven.compiler.target>
​
    <spring.version>5.2.5.RELEASE</spring.version>
    <aopalliance.version>1.0</aopalliance.version>
    <aspectj.weaver>1.9.2</aspectj.weaver>
​
    <jstl.version>1.2</jstl.version>
    <jsp-api.version>2.0</jsp-api.version>
    <servlet-api.version>3.1.0</servlet-api.version>
    <mybatis.version>3.4.6</mybatis.version>
    <mybatis.spring.version>1.3.2</mybatis.spring.version>
    <mysql.version>5.1.3</mysql.version>
    <c3p0.version>0.9.5.2</c3p0.version>
    <log4j.version>1.7.2</log4j.version>
    <commons-logging.version>1.2</commons-logging.version>
    <commons-fileupload.version>1.3.1</commons-fileupload.version>
    <commons-io.version>2.4</commons-io.version>
​
    <pagehelper.version>5.1.2</pagehelper.version>
    <jsqlparser.version>0.9.1</jsqlparser.version>
  </properties>
​
  <dependencies>
    <!-- spring -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>${spring.version}</version>
    </dependency>
​
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-beans</artifactId>
      <version>${spring.version}</version>
    </dependency>
​
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>${spring.version}</version>
    </dependency>
​
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-expression</artifactId>
      <version>${spring.version}</version>
    </dependency>
​
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>${spring.version}</version>
    </dependency>
​
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <!--spring mvc-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${spring.version}</version>
    </dependency>
​
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${spring.version}</version>
    </dependency>
​
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>${spring.version}</version>
      <scope>test</scope>
    </dependency>
​
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aspects</artifactId>
      <version>${spring.version}</version>
    </dependency>
​
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aop</artifactId>
      <version>${spring.version}</version>
    </dependency>
​
    <!-- AOP联盟的API包 -->
    <dependency>
      <groupId>aopalliance</groupId>
      <artifactId>aopalliance</artifactId>
      <version>${aopalliance.version}</version>
    </dependency>
​
    <!-- AspectJ Weaver -->
    <dependency>
      <groupId>org.aspectj</groupId>
      <artifactId>aspectjweaver</artifactId>
      <version>${aspectj.weaver}</version>
    </dependency>
​
    <!-- Jackson Json处理工具包 -->
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-core</artifactId>
      <version>2.9.9</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-databind</artifactId>
      <version>2.9.9</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-annotations</artifactId>
      <version>2.9.9</version>
    </dependency>
​
    <!-- Excel工具包 -->
    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi-ooxml</artifactId>
      <version>3.17</version>
    </dependency>
    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi-ooxml-schemas</artifactId>
      <version>3.17</version>
    </dependency>
    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi</artifactId>
      <version>3.17</version>
    </dependency>
    <dependency>
      <groupId>org.apache.httpcomponents</groupId>
      <artifactId>httpclient</artifactId>
      <version>4.5.2</version>
    </dependency>
    <!-- 富文本编辑器 -->
    <dependency>
      <groupId>com.gitee.qdbp.thirdparty</groupId>
      <artifactId>ueditor</artifactId>
      <version>1.4.3.3</version>
    </dependency>
​
    <!-- JSP相关 -->
    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>${jstl.version}</version>
    </dependency>
​
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>jsp-api</artifactId>
      <version>${jsp-api.version}</version>
      <scope>provided</scope>
    </dependency>
​
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>${servlet-api.version}</version>
      <scope>provided</scope>
    </dependency>
​
    <!-- mybatis -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>${mybatis.version}</version>
    </dependency>
​
    <!--mybatis spring 插件 -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>${mybatis.spring.version}</version>
    </dependency>
​
    <!-- mysql连接 -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>${mysql.version}</version>
    </dependency>
​
    <!-- c3p0数据库连接池 -->
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>c3p0</artifactId>
      <version>${c3p0.version}</version>
    </dependency>
​
    <!--阿里连接池-->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.22</version>
    </dependency>
​
​
    <!-- log4j日志 -->
    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-log4j12</artifactId>
      <version>${log4j.version}</version>
    </dependency>
    <dependency>
      <groupId>commons-logging</groupId>
      <artifactId>commons-logging</artifactId>
      <version>${commons-logging.version}</version>
    </dependency>
​
    <!-- 文件上传 -->
    <dependency>
      <groupId>commons-fileupload</groupId>
      <artifactId>commons-fileupload</artifactId>
      <version>${commons-fileupload.version}</version>
    </dependency>
    <dependency>
      <groupId>commons-io</groupId>
      <artifactId>commons-io</artifactId>
      <version>${commons-io.version}</version>
    </dependency>
​
    <!-- 分页 -->
    <dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper</artifactId>
      <version>${pagehelper.version}</version>
    </dependency>
    <dependency>
      <groupId>com.github.jsqlparser</groupId>
      <artifactId>jsqlparser</artifactId>
      <version>${jsqlparser.version}</version>
    </dependency>
​
    <!--配置redis-->
    <dependency>
      <groupId>redis.clients</groupId>
      <artifactId>jedis</artifactId>
      <version>2.10.2</version>
    </dependency>
    <!--<dependency>
      <groupId>org.springframework.data</groupId>
      <artifactId>spring-data-redis</artifactId>
      <version>2.3.0.RELEASE</version>
    </dependency>-->
    <!-- config redis data and client jar-->
    <dependency>
      <groupId>org.springframework.data</groupId>
      <artifactId>spring-data-redis</artifactId>
      <version>2.1.0.RELEASE</version>
    </dependency>
    <!--commons-pool2-->
    <dependency>
      <groupId>org.apache.commons</groupId>
      <artifactId>commons-pool2</artifactId>
      <version>2.6.2</version>
    </dependency>
    <!--单元测试-->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
      <scope>test</scope>
    </dependency>
​
  </dependencies>
​
  <build>
    <!--配置内部tomcat插件-->
    <plugins>
      <plugin>
        <groupId>org.apache.tomcat.maven</groupId>
        <artifactId>tomcat7-maven-plugin</artifactId>
        <version>2.2</version>
        <configuration>
          <!--http://localhost:8080/-->
          <path>/</path>
          <port>9999</port>
          <uriEncoding>UTF-8</uriEncoding>
        </configuration>
      </plugin>
    </plugins>
​
    <!--配置资源打包方式
    解决maven 找不到mapper映射文件:放在resources里面不用配置-->
    <resources>
      <resource>
        <directory>src/main/java</directory>
        <includes>
          <include>**/*.properties</include>
          <include>**/*.xml</include>
        </includes>
        <filtering>false</filtering>
      </resource>
      <resource>
        <directory>src/main/resources</directory>
        <includes>
          <include>**/*.properties</include>
          <include>**/*.xml</include>
        </includes>
        <filtering>false</filtering>
      </resource>
    </resources>
  </build>
</project>
​

2.spring

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
     http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd
     http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.2.xsd">
    <!--1.开启扫描-->
    <context:component-scan base-package="com.wjx">
        <!--不读取Controller 控制层 读取其他所有层 Controller给springmvc管理 -->
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
    <!--2.读取配置文件-->
    <context:property-placeholder location="classpath:application.properties" />
​
    <!--3.配置数据源-->
    <!--init-method开始,estroy-method结束-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driver}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
    </bean>
    <!--Mybatis-->
    <!--4.配置sqlsessionFactory 工厂类-->
    <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--配置数据库-->
        <property name="dataSource" ref="dataSource" />
        <!--配置分页管理 -->
        <property name="plugins">
            <array>
                <!--插件类型 -->
                <bean class="com.github.pagehelper.PageInterceptor">
                    <!--指定方言 就是指定使用数据库 -->
                    <property name="properties">
                        <props>
                            <!--指定具体数据库 方言 -->
                            <prop key="helperDialect">mysql</prop>
                        </props>
                    </property>
                </bean>
            </array>
        </property>
        <!--配置别名-->
        <property name="typeAliasesPackage" value="com.wjx.bean" />
        <!--配置映射文件-->
        <property name="mapperLocations"  value="classpath:com/wjx/mapper/*.xml" />
    </bean>
    <!--5.配置事务管理-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource" />
    </bean>
    <!--6.配置声明式事务,开启注解事务-->
    <tx:annotation-driven transaction-manager="transactionManager" />
    <!--7.配置扫描所有的mapper接口类-->
    <bean id="configurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer" >
        <!--扫描包下面的所有mapper接口-->
        <!--mapper接口-->
        <property name="basePackage" value="com.wjx.mapper"/>
        <!--给sessionFactory-->
        <property name="sqlSessionFactoryBeanName" value="sessionFactory" />
    </bean>
​
​
    <!--配置redis数据库 -->
    <bean id="jedisConnectionFactory" class="org.springframework.data.redis.connection.jedis.JedisConnectionFactory">
        <!--配置数据库连接池 -->
        <property name="usePool" value="true" />
        <!-- ip-->
        <property name="hostName" value="${redis.host}" />
        <!-- 端口号-->
        <property name="port" value="${redis.port}" />
        <!-- 超时时间-->
        <property name="timeout" value="${redis.timeout}" />
        <!-- 那个数据库-->
        <property name="database" value="${redis.default.db}" />
        <constructor-arg  ref="jedisPoolConfig"/>
    </bean>
    <!--数据库连接池 -->
    <bean id="jedisPoolConfig" class="redis.clients.jedis.JedisPoolConfig">
        <!--最大连接数 -->
        <property name="maxTotal" value="${redis.maxActive}" />
        <!--最大空闲数-->
        <property name="maxIdle" value="${redis.maxIdle}" />
        <!--最大建立连接等待时间 -->
        <property name="maxWaitMillis" value="${redis.maxWait}" />
    </bean>
    <!--配置Redis模板-->
    <bean id="redisTemplate" class="org.springframework.data.redis.core.RedisTemplate">
        <property name="connectionFactory" ref="jedisConnectionFactory" />
    </bean>
</beans>

3.springmvc

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
    xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:task="http://www.springframework.org/schema/task"
    xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.2.xsd
        http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-3.2.xsd">
​
    <!-- 配置扫描包 -->
    <context:component-scan base-package="com.wjx.controller">
    <!-- 配置扫描 包含Controller 注解的类,相当于是配置了扫描的白名单-->
    <context:include-filter type="annotation"
        expression="org.springframework.stereotype.Controller" />
        
    </context:component-scan>
​
    <!-- 启动 mvc 注解驱动 -->
    <!--  设置对字符串的消息转换器 -->
    <bean id="stringHttpMessageConverter" class="org.springframework.http.converter.StringHttpMessageConverter">
        <property
                name="supportedMediaTypes">
            <list>
                <value>text/plain;charset=UTF-8</value>
                <value>application/json;charset=UTF-8</value>
            </list>
        </property>
    </bean>
​
    <!-- Jackson 是Spring自带的功能 -->
    <bean id="mappingJackson2HttpMessageConverter"
          class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
        <property name="supportedMediaTypes">
            <list>
                <value>application/json;charset=UTF-8</value>
                <value>application/xml;charset=UTF-8</value>
                <value>text/html;charset=UTF-8</value>
                <value>text/plain;charset=UTF-8</value>
                <value>text/xml;charset=UTF-8</value>
                <value>text/javascript;charset=UTF-8</value>
            </list>
        </property>
    </bean>
​
    <mvc:annotation-driven>
        <mvc:message-converters>
            <ref bean="stringHttpMessageConverter"/>
            <ref bean="mappingJackson2HttpMessageConverter"/>
        </mvc:message-converters>
    </mvc:annotation-driven>
​
​
    <!-- 静态资源处理 -->
    <mvc:default-servlet-handler/>
    
​
    <!-- 文件上传 -->
    <bean id="multipartResolver" 
        class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
        <!-- 上传文件大小限制10M -->
        <property name="maxUploadSize">  
            <value>10485760</value>  
        </property>  
        <!-- 请求的编码格式, 和 jsp 页面一致 -->
        <property name="defaultEncoding">
            <value>UTF-8</value>
        </property>
    </bean>
​
​
​
​
    
</beans>

4.mybatis

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
		PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
		"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
	<!-- 暂时不需做任何配置 -->


</configuration>

5.test

import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.test.context.junit4.SpringRunner;
import redis.clients.jedis.Jedis;

@RunWith(SpringRunner.class)
@ContextConfiguration("classpath:/spring/applicationContext.xml")
public class RedisTest {

/*    @Before
    public void before() throws Exception {

    }*/
    @Test
    public void test() {
        //String类型测试
        Jedis jedis = new Jedis("127.0.0.1",6379);
        jedis.set("s10","哈哈");
        System.out.println(jedis.get("s10"));
        jedis.setex("验证码",20,"123456");
        System.out.println(jedis.get("验证码"));
        jedis.del("s1");
    }
    //List 集合
    @Test
    public void test2() {
        System.out.println();
        //左存储
        Jedis jedis = new Jedis("127.0.0.1",6379);
        jedis.lpush("list1","1","2","3","4","5");
        System.out.println(jedis.lrange("list1",0,-1));
        //右存储
        jedis.rpush("list2","1","2","3","4","5");
        System.out.println(jedis.lrange("list2",0,-1));
        //左删除
        jedis.lpop("list1");
        //右删除
        jedis.rpop("list2");
        System.out.println(jedis.lrange("list1",0,-1));
        System.out.println(jedis.lrange("list2",0,-1));
    }
    //set
    @Test
    public void test3() {
        Jedis jedis = new Jedis();
        //存
        jedis.sadd("set1","1","2","3","4","5");
        //查
        System.out.println(jedis.smembers("set1"));
    }
    //zset
    @Test
    public void test4() {
        Jedis jedis = new Jedis();
        jedis.zadd("zset",1,"5");
        jedis.zadd("zset",2,"4");
        jedis.zadd("zset",3,"3");
        jedis.zadd("zset",4,"2");
        jedis.zadd("zset",5,"1");
        System.out.println(jedis.zrange("zset",0,-1));
    }
    //hash
    @Test
    public void test5() {
        Jedis jedis=new Jedis();
        jedis.hset("hash1","id","1");
        jedis.hset("hash1","name","天天");
        jedis.hset("hash1","age","18");
        System.out.println(jedis.hget("hash1","id"));
        System.out.println(jedis.hget("hash1","name"));
        System.out.println(jedis.hget("hash1","age"));
    }
}

使用工具类

import com.wjx.util.RedisUtil;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.stereotype.Component;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringRunner;
import redis.clients.jedis.Jedis;

import javax.annotation.Resource;
import java.util.HashMap;
import java.util.Map;


/**
 * 使用封装工具添加查询值
 */
@RunWith(SpringRunner.class)
@ContextConfiguration("classpath:/spring/applicationContext.xml")
public class RedisTest2 {
    @Resource
    RedisUtil redis;
    //    String
    @Test
    public void test() {
        //String类型测试
        redis.set("s10","哈哈");
        System.out.println(redis.get("s10"));
        redis.set("验证码","123456",20);
        System.out.println(redis.get("验证码"));
        redis.del("s1");
    }
        //List 集合
        @Test
        public void test2() {
            //右存储
            Jedis jedis = new Jedis("127.0.0.1",6379);
            redis.lSet("list1","1","2","3","4","5");
            System.out.println(redis.lGet("list1",0,-1));
        }
        //set
        @Test
        public void test3() {
            Jedis jedis = new Jedis();
            //存
            redis.sSet("set1","1","2","3","4","5");
            //删除
            redis.setRemove("set1","1","2");
            //查
            System.out.println(redis.sGet("set1"));
        }
        //zset
        @Test
        public void test4() {
            Jedis jedis = new Jedis();
            jedis.zadd("zset",1,"5");
            jedis.zadd("zset",2,"4");
            jedis.zadd("zset",3,"3");
            jedis.zadd("zset",4,"2");
            jedis.zadd("zset",5,"1");
            System.out.println(jedis.zrange("zset",0,-1));
        }
        //hash
        @Test
        public void test5() {
            redis.hset("hash1","id","1");
            redis.hset("hash1","name","天天");
            redis.hset("hash1","age","18");
            System.out.println(redis.hget("hash1","id"));
            System.out.println(redis.hget("hash1","name"));
            System.out.println(redis.hget("hash1","age"));

            Map<String, Object> map = new HashMap<String, Object>();
            map.put("mapKey2", "1");
            map.put("mapKey4", "2");
            map.put("mapKey3", "3");
            map.put("mapKey5", "4");
            redis.hmset("hash1",map);
            System.out.println(redis.hmget("hash1"));

        }
    }

6数据库配置文件

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc\:mysql\:///hp?useUnicode=true&characterEncoding=UTF-8
jdbc.username=root
jdbc.password=root

#定义初始连接数
jdbc.initialSize=0
#定义最大连接数
jdbc.maxActive=20
#定义最大空闲
jdbc.maxIdle=20
#定义最小空闲
jdbc.minIdle=1
#定义最长等待时间
jdbc.maxWait=60000

dbcp.initialSize=15
dbcp.maxActive=5000
dbcp.maxIdle=0
dbcp.maxWait=900000
dbcp.defaultAutoCommit=true
dbcp.removeAbandoned=true
dbcp.removeAbandonedTimeout=30
dbcp.whenExhaustedAction=1
dbcp.validationQuery=select 1
dbcp.testOnBorrow=fasle
dbcp.testOnReturn=false


#redis的服务器地址
redis.host=127.0.0.1
#redis的服务端口
redis.port=6379
#密码
redis.pass=
#链接数据库
redis.default.db=0
#客户端超时时间单位是毫秒
redis.timeout=100000
#最大连接数
redis.maxActive=300
#最大空闲数
redis.maxIdle=100
#最大建立连接等待时间
redis.maxWait=1000
#指明是否在从池中取出连接前进行检验,如果检验失败,则从池中去除连接并尝试取出另一个
#DBSync.testOnBorrow=true
redis.clientName=requirepass
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
要将Redis整合到MyBatis-Plus中,你可以按照以下步骤进行操作: 1. 首先,确保你已经在项目中引入了Redis的相关依赖,比如`spring-boot-starter-data-redis`。 2. 在Spring Boot的配置文件中,配置Redis的连接信息,包括主机、端口、密码等。 ```yaml spring: redis: host: localhost port: 6379 password: your_password ``` 3. 在MyBatis-Plus的配置文件中,配置Redis作为缓存的实现。 ```java @Configuration public class MyBatisPlusConfig { @Autowired private RedisConnectionFactory redisConnectionFactory; @Bean public CacheManager cacheManager() { RedisCacheConfiguration redisCacheConfiguration = RedisCacheConfiguration.defaultCacheConfig() .entryTtl(Duration.ofMinutes(10)) // 设置缓存过期时间 .disableCachingNullValues() // 禁止缓存null值 .serializeKeysWith(RedisSerializationContext.SerializationPair.fromSerializer(new StringRedisSerializer())) .serializeValuesWith(RedisSerializationContext.SerializationPair.fromSerializer(new GenericJackson2JsonRedisSerializer())); RedisCacheManager.RedisCacheManagerBuilder builder = RedisCacheManager.RedisCacheManagerBuilder .fromConnectionFactory(redisConnectionFactory) .cacheDefaults(redisCacheConfiguration); return builder.build(); } } ``` 4. 在需要缓存的Mapper接口上添加`@CacheNamespace`注解,指定使用Redis作为缓存。 ```java @CacheNamespace(implementation = RedisCache.class) public interface UserMapper extends BaseMapper<User> { // ... } ``` 这样,MyBatis-Plus就会将查询结果缓存Redis中,提高数据查询的效率。 请注意,以上仅是一个简单的示例,实际应用中可能还需要根据具体需求进行调整。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值