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:\IDEASpace\market\market-dao\src\main\resources\jdbc.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 }