SSM框架整合Redis详解

短命女 2022-03-26 08:08 678阅读 0赞

### 开发环境 ###

*  开发工具：Eclipse
 *  JDK：JDK-9.0.4
 *  数据库：MySQL-8.0.12
 *  服务器：apache-tomcat-9.0.12
 *  Maven：apache-maven-3.6.0
 *  Redis：redis-5.0.3
 *  SSM：Spring-4.3.16.RELEASE + MyBatis-3.4.6

### 1、创建动态web工程 ###

####  （1）工程目录结构 ####

![20190116125615785.jpg][] ![20190116130050238.png][]

####  （2）导入所需jar包 ####

##### pom.xml： #####

<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>com.ming</groupId>
      <artifactId>ssm_redis_maven_new</artifactId>
      <version>0.0.1-SNAPSHOT</version>
      <packaging>war</packaging>
      <properties>
      	<spring.version>4.3.16.RELEASE</spring.version>
      	<aop.version>1.9.1</aop.version>
      	<mybatis.version>3.4.6</mybatis.version>
      </properties>
      <dependencies>
      	
      	<dependency>
    	    <groupId>org.springframework</groupId>
    	    <artifactId>spring-core</artifactId>
    	    <version>${spring.version}</version>
    	 </dependency>
    	 <dependency>
        	<groupId>org.springframework</groupId>
        	<artifactId>spring-aop</artifactId>
        	<version>${spring.version}</version>
    	 </dependency>
    	 <dependency>
    	    <groupId>org.springframework</groupId>
    	    <artifactId>spring-web</artifactId>
    	    <version>${spring.version}</version>
    	 </dependency>
    	 <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-tx</artifactId>
    	    <version>${spring.version}</version>
    	 </dependency>
    	 
    	 <dependency>
    	    <groupId>aopalliance</groupId>
    	    <artifactId>aopalliance</artifactId>
    	    <version>1.0</version>
    	 </dependency>
    	 <dependency>
    	    <groupId>org.aspectj</groupId>
    	    <artifactId>aspectjweaver</artifactId>
    	    <version>${aop.version}</version>
    	 </dependency>
         <dependency>
    	    <groupId>org.aspectj</groupId>
    	    <artifactId>aspectjrt</artifactId>
    	    <version>${aop.version}</version>
    	 </dependency>
    	 
    	 <dependency>
    	    <groupId>org.mybatis</groupId>
    	    <artifactId>mybatis</artifactId>
    	    <version>${mybatis.version}</version>
    	 </dependency>
    	 
    	 <dependency>
    	    <groupId>mysql</groupId>
    	    <artifactId>mysql-connector-java</artifactId>
    	    <version>8.0.13</version>
    	    <scope>runtime</scope>
    	</dependency>
    	
    	<dependency>
    	    <groupId>commons-dbcp</groupId>
    	    <artifactId>commons-dbcp</artifactId>
    	    <version>1.4</version>
    	</dependency>
    	
    	<dependency>
    	    <groupId>org.mybatis</groupId>
    	    <artifactId>mybatis-spring</artifactId>
    	    <version>1.3.2</version>
    	</dependency>
    	
    	<dependency>
    	    <groupId>javax.servlet</groupId>
    	    <artifactId>jstl</artifactId>
    	    <version>1.2</version>
    	</dependency>
    	
    	<dependency>
    	    <groupId>org.slf4j</groupId>
    	    <artifactId>slf4j-api</artifactId>
    	    <version>1.7.25</version>
    	</dependency>
    	<dependency>
    	    <groupId>log4j</groupId>
    	    <artifactId>log4j</artifactId>
    	    <version>1.2.17</version>
    	</dependency>
    	
    	<dependency>
    	    <groupId>redis.clients</groupId>
    	    <artifactId>jedis</artifactId>
    	    <version>2.9.0</version>
    	</dependency>
    	
    	<dependency>
    	    <groupId>org.springframework.data</groupId>
    	    <artifactId>spring-data-redis</artifactId>
    	    <version>1.8.11.RELEASE</version>
    	</dependency>
      </dependencies>
    </project>

### 2、持久层实现 ###

#### customer\_manager数据库中customer表的构建： ####

![20190105125330763.jpg][]

##### Customer： #####

package com.ming.ssm.pojo;
    import java.io.Serializable;
    /** * 数据库(customer_manager)中表(customer)所对应的实体类(Customer) * @author Mr.F * */
    public class Customer implements Serializable{ 
    	private static final long serialVersionUID = 1L;
    	private Long c_id;
    	private String c_name;
    	private String c_password;
    	private String c_address;
    	private String c_phone;
    	private String c_email;
    	public Long getC_id() { 
    		return c_id;
    	}
    	public void setC_id(Long c_id) { 
    		this.c_id = c_id;
    	}
    	public String getC_name() { 
    		return c_name;
    	}
    	public void setC_name(String c_name) { 
    		this.c_name = c_name;
    	}
    	public String getC_password() { 
    		return c_password;
    	}
    	public void setC_password(String c_password) { 
    		this.c_password = c_password;
    	}
    	public String getC_address() { 
    		return c_address;
    	}
    	public void setC_address(String c_address) { 
    		this.c_address = c_address;
    	}
    	public String getC_phone() { 
    		return c_phone;
    	}
    	public void setC_phone(String c_phone) { 
    		this.c_phone = c_phone;
    	}
    	public String getC_email() { 
    		return c_email;
    	}
    	public void setC_email(String c_email) { 
    		this.c_email = c_email;
    	}
    }

##### CustomerMapper： #####

package com.ming.ssm.mapper;
    import com.ming.ssm.pojo.Customer;
    /** * 持久层实现Mybatis框架中的Mapper接口，声名对数据库的操作方法 * @author Mr.F * */
    public interface CustomerMapper { 
    	Customer findCustomerById(Long id); //根据ID查询客户信息
    }

##### CustomerMapper.xml： #####

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    
    
    <mapper namespace="com.ming.ssm.mapper.CustomerMapper">
    		
    	
    	<select id="findCustomerById" parameterType="long" resultType="Customer">
    		SELECT * FROM `customer` WHERE `c_id`= #{id}
    	</select>
    </mapper>

##### applicationContext-dao.xml： #####

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd 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 http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
    	
    	<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">    
       		<property name="locations">
       			<list>
       				<value>classpath:jdbc.properties</value>
       				<value>classpath:jedis.properties</value>
       			</list>
       		</property>   
    	</bean>
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    		<property name="driverClassName" value="${jdbc.driver}"></property>
    		<property name="url" value="${jdbc.url}"></property>
    		<property name="username" value="${jdbc.username}"></property>
    		<property name="password" value="${jdbc.password}"></property>
    	</bean>
    	
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		
    		<property name="dataSource" ref="dataSource" />
    		
    		<property name="configLocation" value="classpath:SqlMapConfig.xml" />
    		
    		<property name="typeAliasesPackage" value="com.ming.ssm.pojo" />
    	</bean>
    	
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        	<property name="basePackage" value="com.ming.ssm.mapper" />
        </bean>
    </beans>

##### SqlMapConfig.xml： #####

<?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>
    	
    	<settings>
            <setting name="logImpl" value="STDOUT_LOGGING" />
        </settings>
    </configuration>

##### jdbc.properties： #####

jdbc.driver=com.mysql.cj.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost/customer_manager?serverTimezone=CTT
    jdbc.username=root
    jdbc.password=1314

#### log4j.properties： ####

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=%d{ ABSOLUTE} %5p %c{ 1}:%L - %m%n
    log4j.rootLogger= debug, stdout

### 3、Redis配置 ###

##### applicationContext-jedis.xml #####

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:cache="http://www.springframework.org/schema/cache" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd 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 http://www.springframework.org/schema/cache http://www.springframework.org/schema/cache/spring-cache-4.0.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
    	
    	<cache:annotation-driven cache-manager="cacheManager"/>
    	
    	<bean id="jedisPoolConfig" class="redis.clients.jedis.JedisPoolConfig"> 
    		<property name="maxIdle" value="${jedis.maxIdle}"></property>
    		<property name="minIdle" value="${jedis.minIdle}"></property>
    	 	<property name="maxTotal" value="${jedis.maxTotal}"></property>  	
    	</bean> 
    	
        <bean id="jedisConnectionFactory" class="org.springframework.data.redis.connection.jedis.JedisConnectionFactory"> 
    	    <property name="hostName" value="${jedis.url}"></property>
    	 	<property name="port" value="${jedis.port}"></property> 
    	 	<property name="poolConfig" ref="jedisPoolConfig"></property> 
    	</bean>
    	
    	<bean id="jedisTemplate" class="org.springframework.data.redis.core.RedisTemplate"> 
    		<property name="connectionFactory" ref="jedisConnectionFactory"></property>
    	 	<property name="keySerializer">
    	 		<bean class="org.springframework.data.redis.serializer.StringRedisSerializer"/> 
    	    </property> 
    	  	<property name="hashKeySerializer"> 
    	  		<bean class="org.springframework.data.redis.serializer.StringRedisSerializer"/>
    	    </property> 
    	    <property name="valueSerializer"> 
    	   		<bean class="org.springframework.data.redis.serializer.JdkSerializationRedisSerializer"/> 
    	    </property> 
    	    <property name="hashValueSerializer">
    	    	<bean class="org.springframework.data.redis.serializer.JdkSerializationRedisSerializer"/>
    	    </property> 
    	    <property name="enableTransactionSupport" value="true"></property> 
    	</bean>
    	<bean id="cacheManager" class="org.springframework.data.redis.cache.RedisCacheManager">
        	<constructor-arg ref="jedisTemplate" />
    	</bean>
    </beans>

##### jedis.properties #####

jedis.maxIdle=30
    jedis.minIdle=10
    jedis.maxTotal=50
    jedis.url=192.168.230.128
    jedis.port=6379

### 4、业务层实现 ###

##### CustomerService： #####

package com.ming.ssm.service;
    import com.ming.ssm.pojo.Customer;
    /** * 定义服务层接口 * @author Mr.F * */
    public interface CustomerService { 
    	Customer findCustomerById(Long id); //根据ID查询客户信息
    }

##### CustomerServiceImpl： #####

package com.ming.ssm.service.impl;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.cache.annotation.Cacheable;
    import org.springframework.stereotype.Service;
    import com.ming.ssm.mapper.CustomerMapper;
    import com.ming.ssm.pojo.Customer;
    import com.ming.ssm.service.CustomerService;
    /** * 实现服务层的CustomerService接口 * @author Mr.F * */
    @Service
    public class CustomerServiceImpl implements CustomerService{ 	
    	@Autowired
    	private CustomerMapper customerMapper;
    	@Override
    	@Cacheable(value="cacheManager", key="'customer_id_'+#id")
    	public Customer findCustomerById(Long id) { 
    		return customerMapper.findCustomerById(id);
    	}		
    }

##### applicationContext-service.xml： #####

##### applicationContext-trans.xml： #####

### 5、控制层实现 ###

##### CustomerController： #####

package com.ming.ssm.controller;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    import com.ming.ssm.pojo.Customer;
    import com.ming.ssm.service.CustomerService;
    /** * 定义控制层实现类 * @author Mr.F * */
    @Controller
    public class CustomerController { 	
    	@Autowired
    	private CustomerService customerService;	
    	/** * 根据ID查询客户 * @param customer * @param model * @return */
    	@RequestMapping("findOne")
    	public String findOne(Customer cus, Model model) { 		
    	    Customer customer = customerService.findCustomerById(cus.getC_id());
    		model.addAttribute("c", customer);
    		return "index";
    	}
    }

##### springmvc.xml： #####

<?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:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">      
    	
    	<context:component-scan base-package="com.ming.ssm.controller" />	
    	
    	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    		<property name="prefix" value="/"></property>
    		<property name="suffix" value=".jsp"></property>
    	</bean>
    </beans>

##### web.xml： #####

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5">
      <display-name>ssm_redis_maven_new</display-name>
      <welcome-file-list>
        <welcome-file>index.html</welcome-file>
        <welcome-file>index.htm</welcome-file>
        <welcome-file>index.jsp</welcome-file>
        <welcome-file>default.html</welcome-file>
        <welcome-file>default.htm</welcome-file>
        <welcome-file>default.jsp</welcome-file>
      </welcome-file-list>
       
      <context-param>  
    	<param-name>spring.profiles.active</param-name>  
    	<param-value>dev</param-value>  
      </context-param>  
      <context-param>  
    	<param-name>spring.profiles.default</param-name>  
    	<param-value>dev</param-value>  
      </context-param>
      <context-param>  
    	<param-name>spring.liveBeansView.mbeanDomain</param-name>  
    	<param-value>dev</param-value>  
      </context-param>  
      
      <context-param>
    	<param-name>contextConfigLocation</param-name>
    	<param-value>classpath:spring/applicationContext-*.xml</param-value>
      </context-param>
      
      <listener>
    	<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      </listener>
      
      <filter>
    	<filter-name>encoding</filter-name>
    	<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    	
    	<init-param>
    		<param-name>encoding</param-name>
    		<param-value>UTF-8</param-value>
    	</init-param>
      </filter>
      <filter-mapping>
    	<filter-name>encoding</filter-name>
    	<url-pattern>/*</url-pattern>
      </filter-mapping>
      
      <servlet>
    	<servlet-name>springmvc-web</servlet-name>
    	<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    	
    	<init-param>
    		<param-name>contextConfigLocation</param-name>
    		<param-value>classpath:spring/springmvc.xml</param-value>
    	</init-param>
      </servlet>
      <servlet-mapping>
    	<servlet-name>springmvc-web</servlet-name>
    	<url-pattern>*.action</url-pattern>
      </servlet-mapping>
    </web-app>

##### index.jsp： #####

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
    <title>客户管理页面</title>
    </head>
    <body>
    	<h2 align="center">客户管理系统</h2>
    	<form action="${pageContext.request.contextPath }/findOne.action" method="post">
    		<table border="1px" align="center" width="700px">
    			<tr>
    				<td colspan="6" align="right">
    					请输入客户ID：<input type="text" name="c_id"/>
    					<input type="submit" value="查询"/>
    				</td>
    			</tr>
    			<tr align="center">
    				<td>客户ID</td>
    				<td>客户姓名</td>
    				<td>客户密码</td>
    				<td>客户地址</td>
    				<td>客户手机</td>
    				<td>客户邮箱</td>
    			</tr>
    			<tr align="center">
    				<td>${c.c_id}</td>
    	            <td>${c.c_name}</td>
    	            <td>${c.c_password}</td>
    		        <td>${c.c_address }</td>
    		        <td>${c.c_phone }</td>
    		        <td>${c.c_email }</td>
    			</tr>	
    		</table>
    	</form>
    </body>
    </html>

### 6、工程测试 ###

将ssm\_customer项目工程发布到本地tomcat服务器上，在浏览器地址栏访问http://localhost:8080/ssm\_redis\_maven\_new/index.jsp，其结果如下：

![20190116133701613.jpg][]

然后输入客户ID：3，点击 “查询” 按钮，其结果如下：

![20190116133847357.jpg][]

由于首次查询，Redis中没有缓存数据，可以在Console控制台看到客户端发送查询语句到MySQL数据库，数据返回显示并存储到Redis缓存中:

![20190116134806558.jpg][] ![20190116134837949.jpg][]

再次输入客户ID:3，点击 “查询” 按钮，可以看到所查询的客户信息，并且可以在控制台看到没有MySQL数据库查询信息，这是由于Redis缓存中保存着首次查的数据。

[20190116125615785.jpg]: https://img-blog.csdnimg.cn/20190116125615785.jpg
[20190116130050238.png]: /images/20220326/a659313905f64d7fbee1efdf7dad7295.png
[20190105125330763.jpg]: /images/20220326/84cfe18586c54553b4d731123cfd987b.png
[20190116133701613.jpg]: /images/20220326/26072d7c10b54b66a85841235fc278f6.png
[20190116133847357.jpg]: /images/20220326/160caf5e967d47f49a2c4defec23f2a4.png
[20190116134806558.jpg]: https://img-blog.csdnimg.cn/20190116134806558.jpg
[20190116134837949.jpg]: /images/20220326/903e2189d085476eaace959e66f70647.png