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