基于SSM的单点登陆03

TbUser.java和TbUserExample.java,TbUserMapper.java,TbUserMapper.xml由mybatis框架生成。

generatorConfig.xml

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE generatorConfiguration
 3         PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
 4         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
 5 <generatorConfiguration>
 6     <!-- 引入配置文件 -->
 7     <!--<properties resource="jdbc.properties"/>-->
 8     <properties url="file:///D:IDEASpacemarketmarket-daosrcmain
esourcesjdbc.properties"/>
 9     <context id="marketTables" targetRuntime="MyBatis3">
10         <commentGenerator>
11             <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
12             <property name="suppressAllComments" value="true" />
13         </commentGenerator>
14         <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->
15         <jdbcConnection driverClass="${JDBC_DRIVER}"
16                         connectionURL="${JDBC_URL}"
17                         userId="${JDBC_USERNAME}" password="${JDBC_PASSWORD}">
18         </jdbcConnection>
19         <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL
20             和 NUMERIC 类型解析为java.math.BigDecimal -->
21         <javaTypeResolver>
22             <property name="forceBigDecimals" value="false" />
23         </javaTypeResolver>
24         <!-- targetProject:生成PO类的位置 -->
25         <javaModelGenerator targetPackage="io.guangsoft.market.bean"
26                             targetProject="src/main/java">
27             <!-- enableSubPackages:是否让schema作为包的后缀 -->
28             <property name="enableSubPackages" value="false" />
29             <!-- 从数据库返回的值被清理前后的空格 -->
30             <property name="trimStrings" value="true" />
31         </javaModelGenerator>
32         <!-- targetProject:mapper映射文件生成的位置 -->
33         <sqlMapGenerator targetPackage="io.guangsoft.market.mapper"
34                          targetProject="src/main/java">
35             <!-- enableSubPackages:是否让schema作为包的后缀 -->
36             <property name="enableSubPackages" value="false" />
37         </sqlMapGenerator>
38         <!-- targetPackage：mapper接口生成的位置 -->
39         <javaClientGenerator type="XMLMAPPER" targetPackage="io.guangsoft.market.dao"
40                              targetProject="src/main/java">
41             <!-- enableSubPackages:是否让schema作为包的后缀 -->
42             <property name="enableSubPackages" value="false" />
43         </javaClientGenerator>
44         <!-- 指定数据库表 -->
45         <table schema="" tableName="tb_content"></table>
46         <table schema="" tableName="tb_content_category"></table>
47         <table schema="" tableName="tb_item"></table>
48         <table schema="" tableName="tb_item_cat"></table>
49         <table schema="" tableName="tb_item_desc"></table>
50         <table schema="" tableName="tb_item_param"></table>
51         <table schema="" tableName="tb_item_param_item"></table>
52         <table schema="" tableName="tb_order"></table>
53         <table schema="" tableName="tb_order_item"></table>
54         <table schema="" tableName="tb_order_shipping"></table>
55         <table schema="" tableName="tb_user"></table>
56     </context>
57 </generatorConfiguration>

spring-jedis.xml

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <beans xmlns="http://www.springframework.org/schema/beans"
 3     xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
 4     xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
 5     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 6     xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
 7     http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
 8     http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
 9     http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
10     <!-- 解析properties文件的工具类 -->
11     <context:property-placeholder location="classpath:*.properties"/>
12     <!-- 连接池配置 -->
13     <bean id="jedisPoolConfig" class="redis.clients.jedis.JedisPoolConfig">
14         <!-- 最大连接数 -->
15         <property name="maxTotal" value="30" />
16         <!-- 最大空闲连接数 -->
17         <property name="maxIdle" value="10" />
18         <!-- 每次释放连接的最大数目 -->
19         <property name="numTestsPerEvictionRun" value="1024" />
20         <!-- 释放连接的扫描间隔（毫秒） -->
21         <property name="timeBetweenEvictionRunsMillis" value="30000" />
22         <!-- 连接最小空闲时间 -->
23         <property name="minEvictableIdleTimeMillis" value="1800000" />
24         <!-- 连接空闲多久后释放, 当空闲时间>该值 且 空闲连接>最大空闲连接数 时直接释放 -->
25         <property name="softMinEvictableIdleTimeMillis" value="10000" />
26         <!-- 获取连接时的最大等待毫秒数,小于零:阻塞不确定的时间,默认-1 -->
27         <property name="maxWaitMillis" value="1500" />
28         <!-- 在获取连接的时候检查有效性, 默认false -->
29         <property name="testOnBorrow" value="true" />
30         <!-- 在空闲时检查有效性, 默认false -->
31         <property name="testWhileIdle" value="true" />
32         <!-- 连接耗尽时是否阻塞, false报异常,ture阻塞直到超时, 默认true -->
33         <property name="blockWhenExhausted" value="false" />
34     </bean>
35     
36     <!-- 配置jedisPool对象 -->
37     <bean id="jedisPool" class="redis.clients.jedis.JedisPool">
38         <constructor-arg name="host" value="${JEDIS_URL}" />
39         <constructor-arg name="port" value="${JEDIS_PORT}" />
40         <constructor-arg name="poolConfig">
41             <ref bean="jedisPoolConfig"/>
42         </constructor-arg>
43     </bean>
44     
45     <bean id="jedisDaoPool" class="io.guangsoft.market.dao.jedis.JedisDaoImpl">
46         <property name="pool">
47             <ref bean="jedisPool"/>
48         </property>
49     </bean>
50 </beans>

jedis.properties

1 JEDIS_URL=127.0.0.1
2 JEDIS_PORT=6379

JedisDao.java

 1 package io.guangsoft.market.dao.jedis;
 2 
 3 public interface JedisDao {
 4     public String set(String key,String value);
 5     public String get(String key);
 6     public Long expire(String key, int seconds);
 7     public Long ttl(String key);
 8     public Long hset(String key,String hkey,String value);
 9     public String hgetI(String key,String hkey);
10     public Long del(String key);
11     public Long hdel(String key,String hkey);
12 }

JedisDaoImpl.java

 1 package io.guangsoft.market.dao.jedis;
 2 
 3 import redis.clients.jedis.Jedis;
 4 import redis.clients.jedis.JedisPool;
 5 
 6 public class JedisDaoImpl implements JedisDao {
 7 
 8     private JedisPool pool;
 9 
10     public JedisPool getPool() {
11         return pool;
12     }
13 
14     public void setPool(JedisPool pool) {
15         this.pool = pool;
16     }
17 
18     @Override
19     public String set(String key, String value) {
20         Jedis jedis = pool.getResource();
21         String val = jedis.set(key, value);
22         jedis.close();
23         return val;
24     }
25 
26     @Override
27     public String get(String key) {
28         Jedis jedis = pool.getResource();
29         String val = jedis.get(key);
30         jedis.close();
31         return val;
32     }
33 
34     @Override
35     public Long expire(String key, int seconds) {
36         Jedis jedis = pool.getResource();
37         Long val = jedis.expire(key, seconds);
38         jedis.close();
39         return val;
40     }
41 
42     @Override
43     public Long ttl(String key) {
44         Jedis jedis = pool.getResource();
45         Long val = jedis.ttl(key);
46         jedis.close();
47         return val;
48     }
49 
50     @Override
51     public Long hset(String key, String hkey, String value) {
52         Jedis jedis = pool.getResource();
53         Long val = jedis.hset(key, hkey, value);
54         jedis.close();
55         return val;
56     }
57 
58     @Override
59     public String hgetI(String key, String hkey) {
60         Jedis jedis = pool.getResource();
61         String val = jedis.hget(key, hkey);
62         jedis.close();
63         return val;
64     }
65 
66     @Override
67     public Long del(String key) {
68         Jedis jedis = pool.getResource();
69         Long val = jedis.del(key);
70         jedis.close();
71         return val;
72     }
73 
74     @Override
75     public Long hdel(String key, String hkey) {
76         Jedis jedis = pool.getResource();
77         Long val = jedis.hdel(key, hkey);
78         jedis.close();
79         return val;
80     }
81 }