spring,springmvc,mybatis整合redis，redis作为缓存使用

最新推荐文章于 2021-06-19 13:37:29 发布
最新推荐文章于 2021-06-19 13:37:29 发布
阅读量196 收藏 1
点赞数
文章标签： java 数据库 测试
原文链接：http://www.cnblogs.com/huangtao1927/p/8267193.html
版权

环境

1，windows7

2，mysql

3，eclipse

4，redis

5，tomcat7

注意：启动redis的方式，已经把redis做成windows服务，以windows服务的方式启动

把redis做成windows服务的命令行

redis-server --service-install redis.windows.conf

可自行百度其他命令行

项目整合经过测试，可以正常启动，redis缓存和mysql操作均没有问题

================================分割线========================================

情景：使用spring,springmvc,mybatis整合redis

目录结构如下：

报错是因为eclipse抽风，不用管。

================================分割线========================================

pom文件

<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/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com</groupId>
<artifactId>web.ssm</artifactId>
<packaging>war</packaging>
<version>0.0.1-SNAPSHOT</version>
<name>web.ssm Maven Webapp</name>
<url>http://maven.apache.org</url>
<properties>
<servlet.version>3.0.1</servlet.version>
<spring.version>4.2.5.RELEASE</spring.version>
<mybatis.version>3.4.1</mybatis.version>
<mybatis.spring.version>1.3.0</mybatis.spring.version>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<ssm-maven-compiler-plugin.version>3.1</ssm-maven-compiler-plugin.version>
<ssm-maven-javadoc-plugin.version>2.7</ssm-maven-javadoc-plugin.version>
<ssm-maven-shade-plugin.version>2.3</ssm-maven-shade-plugin.version>
<ssm-maven-war-plugin.version>2.6</ssm-maven-war-plugin.version>
<ssm-encoding.version>UTF-8</ssm-encoding.version>
<ssm-jdk.version>1.8</ssm-jdk.version>
</properties>
<dependencies>
<!-- servletAPI begin-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>${servlet.version}</version>
</dependency>
<!-- servletAPI end-->
<!-- for Spring begin -->
<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-context-support</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>org.springframework</groupId>
<artifactId>spring-test</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>
<!-- for Spring end -->
<!--springAOP begin -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjrt</artifactId>
<version>1.7.4</version>
</dependency>
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.7.4</version>
</dependency>
<!--springAOP end -->
<!-- for mybatis begin -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>${mybatis.spring.version}</version>
</dependency>
<!-- for mybatis end -->
<!-- begin with below line configured for log4j -->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.7</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.16</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>1.7.12</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>jcl-over-slf4j</artifactId>
<version>1.5.8</version>
</dependency>
<!-- end with above line configured for log4j -->
<!--junit begin -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.9</version>
<!-- <scope>test</scope> -->
</dependency>
<!--junit end -->
<!--druid begin -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.24</version>
</dependency>
<!--druid end -->
<!--MySql begin-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.30</version>
</dependency>
<!--MySql end-->
<!--redis begin -->
<dependency>
<groupId>redis.clients</groupId>
<artifactId>jedis</artifactId>
<version>2.8.1</version>
</dependency>
<dependency>
<groupId>org.springframework.data</groupId>
<artifactId>spring-data-redis</artifactId>
<version>1.7.2.RELEASE</version>
</dependency>
<!--redis end -->
<!-- JSON转换工具 begin-->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.5.4</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>2.5.4</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>2.5.4</version>
</dependency>
<!-- JSON转换工具 end-->
</dependencies>
<build>
<finalName>web.ssm</finalName>
<plugins>
<!-- 全局项目构建过程 -->
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<configuration>
<source>${ssm-jdk.version}</source>
<target>${ssm-jdk.version}</target>
<encoding>${ssm-encoding.version}</encoding>
</configuration>
</plugin>
</plugins>
<pluginManagement>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>${ssm-maven-compiler-plugin.version}</version>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-shade-plugin</artifactId>
<version>${ssm-maven-shade-plugin.version}</version>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-war-plugin</artifactId>
<version>${ssm-maven-war-plugin.version}</version>
</plugin>
</plugins>
</pluginManagement>
</build>
</project>

============================分割线======================================

jdbc.properties文件

#Enbrands DB
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm
jdbc.username=admin
jdbc.password=admin


#druid datasource
druid.initialSize=10
druid.minIdle=10
druid.maxActive=50
druid.maxWait=60000
druid.timeBetweenEvictionRunsMillis=60000
druid.minEvictableIdleTimeMillis=300000
druid.validationQuery=SELECT 'x'
druid.testWhileIdle=true
druid.testOnBorrow=false
druid.testOnReturn=false
druid.poolPreparedStatements=true
druid.maxPoolPreparedStatementPerConnectionSize=20
#druid.filters=wall,stat
druid.filters=stat

==========================分割线========================================

redis-config.properties文件

# Redis settings
# server IP
redis.host=127.0.0.1
# server port
redis.port=6379
# server pass
redis.pass=admin
# use dbIndex
redis.database=0
# \u63A7\u5236\u4E00\u4E2Apool\u6700\u591A\u6709\u591A\u5C11\u4E2A\u72B6\u6001\u4E3Aidle(\u7A7A\u95F2\u7684)\u7684jedis\u5B9E\u4F8B
redis.maxIdle=300
# \u8868\u793A\u5F53borrow(\u5F15\u5165)\u4E00\u4E2Ajedis\u5B9E\u4F8B\u65F6\uFF0C\u6700\u5927\u7684\u7B49\u5F85\u65F6\u95F4\uFF0C\u5982\u679C\u8D85\u8FC7\u7B49\u5F85\u65F6\u95F4(\u6BEB\u79D2)\uFF0C\u5219\u76F4\u63A5\u629B\u51FAJedisConnectionException\uFF1B
redis.maxWait=3000
# \u5728borrow\u4E00\u4E2Ajedis\u5B9E\u4F8B\u65F6\uFF0C\u662F\u5426\u63D0\u524D\u8FDB\u884Cvalidate\u64CD\u4F5C\uFF1B\u5982\u679C\u4E3Atrue\uFF0C\u5219\u5F97\u5230\u7684jedis\u5B9E\u4F8B\u5747\u662F\u53EF\u7528\u7684
redis.testOnBorrow=false

乱码部分是注释，不用管

==========================分割线======================================

applicationContext.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.2.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.2.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd">

<!--扫描包 -->
<context:component-scan base-package="web.ssm.service" />
<context:component-scan base-package="web.ssm.service.impl" />
<context:component-scan base-package="web.ssm.dao" />

<!-- 引入同文件夹下的redis属性配置文件 -->
<import resource="classpath:spring/spring-mybatis.xml"/>

<import resource="classpath:spring/spring-redis.xml"/>

</beans>

===============================分割线=================================================

spring-mvc.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:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:util="http://www.springframework.org/schema/util"
xsi:schemaLocation="
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.2.xsd
http://www.springframework.org/schema/util
http://www.springframework.org/schema/util/spring-util-3.2.xsd">
<!-- 扫描控制器包 -->
<mvc:default-servlet-handler />
<!-- <mvc:annotation-driven></mvc:annotation-driven> -->
<context:component-scan base-package="web.ssm.controller" />

<mvc:annotation-driven>
<mvc:message-converters>
<ref bean="stringHttpMessageConverter" />
<ref bean="mappingJacksonHttpMessageConverter" /> <!-- JSON转换器 -->
</mvc:message-converters>
</mvc:annotation-driven>


<bean id="mappingJacksonHttpMessageConverter" class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
<property name="supportedMediaTypes">
<list>
<value>application/json;charset=UTF-8</value>
<value>text/html;charset=UTF-8</value>
<value>text/plain;charset=UTF-8</value>
</list>
</property>
</bean>

<!-- - StringHttpMessageConverter bean -->
<bean id = "stringHttpMessageConverter" class = "org.springframework.http.converter.StringHttpMessageConverter">
<property name="supportedMediaTypes">
<list>
<value>application/json;charset=UTF-8</value>
<value>text/html;charset=UTF-8</value>
<value>text/plain;charset=UTF-8</value>
</list>
</property>
</bean>
<!-- 注解POJO的映射 -->
<bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
<property name="messageConverters">
<list>
<ref bean="mappingJacksonHttpMessageConverter" /> <!-- JSON转换器 -->
<ref bean="stringHttpMessageConverter" />
</list>
</property>
</bean>

<!-- 视图配置-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/views/" />
<property name="suffix" value=".jsp" />
</bean>


</beans>

==================================分割线===========================================

spring-mybatis文件

<?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:tx="http://www.springframework.org/schema/tx"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
">

<context:property-placeholder location="classpath:database/jdbc.properties" ignore-unresolvable="true"/>

<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<!-- 基本属性 url、user、password -->
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="driverClassName" value="${jdbc.driver}" />

<!-- 配置初始化大小、最小、最大 -->
<property name="initialSize" value="1" />
<property name="minIdle" value="1" />
<property name="maxActive" value="20" />

<!-- 配置获取连接等待超时的时间 -->
<property name="maxWait" value="60000" />

<!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
<property name="timeBetweenEvictionRunsMillis" value="60000" />

<!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
<property name="minEvictableIdleTimeMillis" value="300000" />

<!-- <property name="validationQuery" value="SELECT 'x' from test " /> -->
<property name="testWhileIdle" value="false" />
<property name="testOnBorrow" value="false" />
<property name="testOnReturn" value="false" />

<!-- 打开PSCache，并且指定每个连接上PSCache的大小 -->
<property name="poolPreparedStatements" value="true" />
<property name="maxPoolPreparedStatementPerConnectionSize" value="20" />

<!-- 配置监控统计拦截的filters -->
<property name="filters" value="stat" />
</bean>

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 自动扫描mapping.xml文件 -->
<property name="mapperLocations" value="classpath:mapping/*.xml"></property>
</bean>

<!-- DAO接口所在包名，Spring会自动查找其下的类 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="web.ssm.dao" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>

<!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<!-- enables scanning for @Transactional annotations -->
<tx:annotation-driven transaction-manager="transactionManager" />
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="get*" propagation="REQUIRED" read-only="true"/>
<tx:method name="search*" propagation="REQUIRED" read-only="true"/>
<tx:method name="find*" propagation="REQUIRED" read-only="true"/>
<tx:method name="save*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
<tx:method name="add*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
<tx:method name="insert*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
<tx:method name="update*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
<tx:method name="create*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
<tx:method name="delete*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
<tx:method name="run*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
<tx:method name="batch*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
<tx:method name="execute*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
<!-- <tx:method name="*" propagation="REQUIRED"/> -->
</tx:attributes>
</tx:advice>

<!-- AOP 设置那些类的哪些方法参与事务 -->
<aop:config proxy-target-class="true">
<aop:pointcut id="webssmService" expression="execution(* web.ssm.service..*.*(..))" />
<aop:advisor pointcut-ref="webssmService" advice-ref="txAdvice" />
</aop:config>
</beans>

===============================分割线=================================================

spring-redis.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"
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.2.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.2.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd
http://www.springframework.org/schema/cache
http://www.springframework.org/schema/cache/spring-cache-4.2.xsd">

<context:property-placeholder location="classpath:redis/redis-config.properties" ignore-unresolvable="true"/>

<!-- 启用缓存注解功能，这个是必须的，否则注解不会生效，另外，该注解一定要声明在spring主配置文件中才会生效 -->
<cache:annotation-driven cache-manager="cacheManager" />

<!-- redis 相关配置 -->
<bean id="poolConfig" class="redis.clients.jedis.JedisPoolConfig">
<property name="maxIdle" value="${redis.maxIdle}" />
<property name="maxWaitMillis" value="${redis.maxWait}" />
<property name="testOnBorrow" value="${redis.testOnBorrow}" />
</bean>

<bean id="JedisConnectionFactory" class="org.springframework.data.redis.connection.jedis.JedisConnectionFactory"
p:host-name="${redis.host}" p:port="${redis.port}" p:password="${redis.pass}" p:pool-config-ref="poolConfig"/>

<bean id="redisTemplate" class="org.springframework.data.redis.core.RedisTemplate">
<property name="connectionFactory" ref="JedisConnectionFactory" />
</bean>

<!-- spring自己的缓存管理器，这里定义了缓存位置名称 ，即注解中的value -->
<bean id="cacheManager" class="org.springframework.cache.support.SimpleCacheManager">
<property name="caches">
<set>
<!-- 这里可以配置多个redis -->
<!-- <bean class="com.cn.util.RedisCache">
<property name="redisTemplate" ref="redisTemplate" />
<property name="name" value="default"/>
</bean> -->
<bean class="web.ssm.utils.RedisCache">
<property name="redisTemplate" ref="redisTemplate" />
<property name="name" value="common"/>
<!-- common名称要在类或方法的注解中使用 -->
</bean>
</set>
</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_3_0.xsd"
version="3.0">
<display-name>webssm</display-name>
<context-param>
<param-name>webAppRootKey</param-name>
<param-value>webssm</param-value>
</context-param>
<!-- log4j begin -->
<context-param>
<param-name>log4jConfigLocation</param-name>
<param-value>/WEB-INF/log4j.properties</param-value>
</context-param>
<context-param>
<param-name>log4jRefreshInterval</param-name>
<param-value>6000</param-value>
</context-param>
<listener>
<listener-class>
org.springframework.web.util.Log4jConfigListener
</listener-class>
</listener>
<!-- log4j end -->
<!-- 编码过滤器 -->
<filter>
<filter-name>encodingFilter</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>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- spring config-->
<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>

<servlet>
<servlet-name>spring</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring/spring-mvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
<async-supported>true</async-supported>
</servlet>
<servlet-mapping>
<servlet-name>spring</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>

<!-- Spring刷新Interceptor防止内存泄漏 -->
<listener>
<listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
</listener>

<!-- 设置session 超时时间为20分钟 -->
<session-config>
<session-timeout>20</session-timeout>
</session-config>
</web-app>

==============================分割线==============================================

log4j配置

log4j.rootLogger=debug,debug,info,warn,error,stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{yyy-MM-dd HH:mm:ss } [%t] [%c] [%p] - %m%n

log4j.logger.debug=debug
log4j.appender.debug=org.apache.log4j.DailyRollingFileAppender
#log4j.appender.debug.MaxFileSize=20MB
log4j.appender.debug.layout=org.apache.log4j.PatternLayout
log4j.appender.debug.layout.ConversionPattern=%d{yyy-MM-dd HH:mm:ss } [%t] [%c] [%p] - %m%n
log4j.appender.debug.datePattern='.'yyyy-MM-dd
log4j.appender.debug.Threshold = debug
log4j.appender.debug.append=true
#log4j.appender.debug.File=${webapp.root}/logs/debug.log
log4j.appender.debug.File=E:/webssmLogs/logs/debug.log

log4j.logger.info=info
log4j.appender.info=org.apache.log4j.DailyRollingFileAppender
#log4j.appender.info.MaxFileSize=20MB
log4j.appender.info.layout=org.apache.log4j.PatternLayout
log4j.appender.info.layout.ConversionPattern=%d{yyy-MM-dd HH:mm:ss } [%t] [%c] [%p] - %m%n
log4j.appender.info.datePattern='.'yyyy-MM-dd
log4j.appender.info.Threshold = info
log4j.appender.info.append=true
#log4j.appender.info.File=${webapp.root}/logs/info.log
log4j.appender.info.File=E:/webssmLogs/logs/info.log

log4j.logger.warn=warn
log4j.appender.warn=org.apache.log4j.DailyRollingFileAppender
log4j.appender.warn.layout=org.apache.log4j.PatternLayout
#log4j.appender.warn.MaxFileSize=20MB
log4j.appender.warn.layout.ConversionPattern=%d{yyy-MM-dd HH:mm:ss } [%t] [%c] [%p] - %m%n
log4j.appender.warn.datePattern='.'yyyy-MM-dd
log4j.appender.warn.Threshold = warn
log4j.appender.warn.append=true
#log4j.appender.warn.File=${webapp.root}/logs/warn.log
log4j.appender.warn.File=E:/webssmLogs/logs/warn.log

log4j.logger.error=error
log4j.appender.error=org.apache.log4j.DailyRollingFileAppender
#log4j.appender.error.MaxFileSize=20MB
log4j.appender.error.layout=org.apache.log4j.PatternLayout
log4j.appender.error.layout.ConversionPattern=%d{yyy-MM-dd HH:mm:ss } [%t] [%c] [%p] - %m%n
log4j.appender.error.datePattern='.'yyyy-MM-dd
log4j.appender.error.Threshold = error
log4j.appender.error.append=true
#log4j.appender.error.File=${webapp.root}/logs/error.log
log4j.appender.error.File=E:/webssmLogs/logs/error.log

注意：配置中有log4j.appender.error=org.apache.log4j.DailyRollingFileAppender，

也可以使用代码中的log4j包下的类来实现，效果是一样的。

===============================分割线==================================================== 

java代码部分结构图

================================分割图=====================================================

UserController类

package web.ssm.controller;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import web.ssm.entity.User;
import web.ssm.service.UserService;

@Controller
@RequestMapping("/user")
public class UserController {
private static final String DEBUG_PREFIX = "[UserController]";

private static final String INFO_PREFIX = "<UserController>";

private static final String ERROR_PREFIX = "UserController->";

//日志
private static Logger logger = Logger.getLogger(UserController.class);

@Autowired
private UserService userService;

@RequestMapping(method={RequestMethod.GET}, value="/selectUser")
@ResponseBody
public User selectUser(HttpServletRequest request, HttpServletResponse response){
String sid = request.getParameter("id");
int id = Integer.valueOf(sid);
User user = userService.selectByPrimaryKey(id);
return user;
}

@RequestMapping(method={RequestMethod.GET}, value="/insertUser")
@ResponseBody
public int insertUser(HttpServletRequest request, HttpServletResponse response){
String name = request.getParameter("name");
User user = new User();
user.setName(name);
userService.insertSelective(user);
return 1;
}

@RequestMapping(method={RequestMethod.GET}, value="/deleteUser")
@ResponseBody
public int deleteUser(HttpServletRequest request, HttpServletResponse response){
String sid = request.getParameter("id");
int id = Integer.valueOf(sid);
userService.deleteByPrimaryKey(id);
return 1;
}
}

=======================================分割线=====================================

UserDao类

package web.ssm.dao;

import org.springframework.stereotype.Repository;

import web.ssm.entity.User;

@Repository
public interface UserDao {
public User selectByPrimaryKey(Integer id);
public void insertSelective(User user);
public void deleteByPrimaryKey(Integer id);
}

================================分割线======================================

User类

package web.ssm.entity;

import java.io.Serializable;


public class User implements Serializable {

private static final long serialVersionUID = 5533446196251002012L;

private Integer id;
private String name;

public User() {}

public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}

public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@Override
public String toString() {
return "User [id=" + id + ", name=" + name + "]";
}
}

=================================分割线=============================================

log4j类

package web.ssm.log4j;
import org.apache.log4j.DailyRollingFileAppender;
import org.apache.log4j.Priority;
/**
* 自定义文件输出destination
*/
public class BackUpAppender extends DailyRollingFileAppender {
@Override
public boolean isAsSevereAsThreshold(Priority priority) {
//只判断是否相等，而不判断优先级
return this.getThreshold().equals(priority);
}
}

================================分割线===============================================

UserService类

package web.ssm.service;

import web.ssm.entity.User;

public interface UserService {
/**
* @方法描述: 根据id查询对象
* @作者： 1603254
* @日期： 2016-12-2-上午11:09:58
* @param id
* @return
* @返回类型： User
*/
public User selectByPrimaryKey(Integer id);

/**
* @方法描述: 插入对象
* @作者： 1603254
* @日期： 2016-12-2-上午11:10:01
* @param user
* @返回类型： void
*/
public void insertSelective(User user);

/**
* @方法描述: 根据id删除对象
* @作者： 1603254
* @日期： 2016-12-2-上午11:10:04
* @param id
* @返回类型： void
*/
public void deleteByPrimaryKey(Integer id);
}

=================================分割线============================================

UserServiceImple类

package web.ssm.service.impl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.cache.annotation.CacheEvict;
import org.springframework.cache.annotation.CachePut;
import org.springframework.cache.annotation.Cacheable;
import org.springframework.stereotype.Service;

import web.ssm.dao.UserDao;
import web.ssm.entity.User;
import web.ssm.service.UserService;


@Service
public class UserServiceImpl implements UserService{

@Autowired
private UserDao userDao;

@Cacheable(value="common",key="'id_'+#id")
public User selectByPrimaryKey(Integer id) {
System.out.println("======================");
System.out.println("======================");
System.out.println("======================");
return userDao.selectByPrimaryKey(id);
}

@CachePut(value="common",key="#user.getName()")
public void insertSelective(User user) {
userDao.insertSelective(user);
System.out.println("########################");
System.out.println("########################");
System.out.println("########################");
}

@CacheEvict(value="common",key="'id_'+#id")
public void deleteByPrimaryKey(Integer id) {
userDao.deleteByPrimaryKey(id);
System.out.println("******************************");
System.out.println("******************************");
System.out.println("******************************");
}
}

注意：各个注解的作用请自行百度

=================================分割线=============================================

RedisCache类

package web.ssm.utils;

import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.ObjectInputStream;
import java.io.ObjectOutputStream;

import org.springframework.cache.Cache;
import org.springframework.cache.support.SimpleValueWrapper;
import org.springframework.dao.DataAccessException;
import org.springframework.data.redis.connection.RedisConnection;
import org.springframework.data.redis.core.RedisCallback;
import org.springframework.data.redis.core.RedisTemplate;

public class RedisCache implements Cache{

private RedisTemplate<String, Object> redisTemplate;
private String name;
public RedisTemplate<String, Object> getRedisTemplate() {
return redisTemplate;
}

public void setRedisTemplate(RedisTemplate<String, Object> redisTemplate) {
this.redisTemplate = redisTemplate;
}

public void setName(String name) {
this.name = name;
}

@Override
public String getName() {
// TODO Auto-generated method stub
return this.name;
}

@Override
public Object getNativeCache() {
// TODO Auto-generated method stub
return this.redisTemplate;
}

@Override
public ValueWrapper get(Object key) {
// TODO Auto-generated method stub
System.out.println("get key");
final String keyf = key.toString();
Object object = null;
object = redisTemplate.execute(new RedisCallback<Object>() {
public Object doInRedis(RedisConnection connection)
throws DataAccessException {
byte[] key = keyf.getBytes();
byte[] value = connection.get(key);
if (value == null) {
return null;
}
return toObject(value);
}
});
return (object != null ? new SimpleValueWrapper(object) : null);
}

@Override
public void put(Object key, Object value) {
// TODO Auto-generated method stub
System.out.println("put key");
final String keyf = key.toString();
final Object valuef = value;
final long liveTime = 86400;
redisTemplate.execute(new RedisCallback<Long>() {
public Long doInRedis(RedisConnection connection)
throws DataAccessException {
byte[] keyb = keyf.getBytes();
byte[] valueb = toByteArray(valuef);
connection.set(keyb, valueb);
if (liveTime > 0) {
connection.expire(keyb, liveTime);
}
return 1L;
}
});
}

private byte[] toByteArray(Object obj) {
byte[] bytes = null;
ByteArrayOutputStream bos = new ByteArrayOutputStream();
try {
ObjectOutputStream oos = new ObjectOutputStream(bos);
oos.writeObject(obj);
oos.flush();
bytes = bos.toByteArray();
oos.close();
bos.close();
}catch (IOException ex) {
ex.printStackTrace();
}
return bytes;
}

private Object toObject(byte[] bytes) {
Object obj = null;
try {
ByteArrayInputStream bis = new ByteArrayInputStream(bytes);
ObjectInputStream ois = new ObjectInputStream(bis);
obj = ois.readObject();
ois.close();
bis.close();
} catch (IOException ex) {
ex.printStackTrace();
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
return obj;
}

@Override
public void evict(Object key) {
// TODO Auto-generated method stub
System.out.println("del key");
final String keyf = key.toString();
redisTemplate.execute(new RedisCallback<Long>() {
public Long doInRedis(RedisConnection connection)
throws DataAccessException {
return connection.del(keyf.getBytes());
}
});
}

@Override
public void clear() {
// TODO Auto-generated method stub
System.out.println("clear key");
redisTemplate.execute(new RedisCallback<String>() {
public String doInRedis(RedisConnection connection)
throws DataAccessException {
connection.flushDb();
return "ok";
}
});
}

@Override
public <T> T get(Object key, Class<T> type) {
// TODO Auto-generated method stub
return null;
}

@Override
public ValueWrapper putIfAbsent(Object key, Object value) {
// TODO Auto-generated method stub
return null;
}

}

=======================================分割线==================================================

 

转载于:https://www.cnblogs.com/huangtao1927/p/8267193.html

weixin_30263277
关注
springMVC+spring+mybatis+redis整合
12-29
springMVC+spring+mybatis+redis整合的maven demo，redis作为二级缓存
Spring SpringMVC Mybatis 整合 Redis
02-02
Spring SpringMVC Mybatis 整合 Redis .........................................................................................
spring整合redis缓存，以注解(@Cacheable、@CachePut、@CacheEvict)形式使用
xwnxwn的专栏
12-02 4041
maven项目中在pom.xml中依赖2个jar包，其他的spring的jar包省略： [html] view plain copy  print? dependency>      groupId>redis.clientsgroupId>      artifactId>jedisartifactId>      version>2.8.1ver
Spring+SpringMVC+MyBatis整合Redis
weixin_40690763的博客
01-15 190
Spring+SpringMVC+MyBatis整合 项目目录结构如下 代码如下： pom.xml <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w...
Spring SpringMVC配置Mybatis及Redis
持续学习中
12-12 1103
 作者：谭东 这里是基于上个文章的配置继续增加的Mybatis配置。 文件目录结构如图：   pom.xml增加如下库（mybatis和redis），一起配置了： &lt;!-- mybatis-spring --&gt; &lt;dependency&gt; &lt;groupId&gt;org.mybatis&lt;/groupId&...
spring+springmvc+mybatis+redis框架
12-14
1. Spring作为基础框架，负责管理所有组件的生命周期，提供事务管理和其他服务。 2. SpringMVC处理HTTP请求，通过DispatcherServlet分发到相应的控制器方法，控制器与业务逻辑交互，返回视图。 3. MyBatis作为数据...
maven+springmvc+redis+mybatis整合
05-25
本项目以“maven+springmvc+redis+mybatis整合”为主题，旨在提供一个基于这些技术的集成框架，特别强调了利用Redis作为缓存来提升应用性能。下面将详细阐述这个框架中的各个组成部分以及它们之间的协作。 首先，...
校社联社团管理系统（Spring MVC+Spring+Mybatis+Redis）.zip
05-01
校社联社团管理系统（Spring MVC+Spring+Mybatis+Redis），用来记录进度，和保存文件，完成一定阶段都上传到小组仓库中。 校社联社团管理系统（Spring MVC+Spring+Mybatis+Redis），用来记录进度，和保存文件，完成...
springmvc+mybatis+redis
08-01
总结来说，"springmvc+mybatis+redis"的整合是现代Web开发中常见的技术栈组合，它利用SpringMVC提供灵活的控制层，MyBatis简化数据库操作，而Redis则通过高效的缓存机制优化了数据访问性能。这种组合能够帮助开发者...
springmvc+redis+mysql（数据库连接简单实现）数据缓存
08-09
实现redis与springmvc配置，数据库连接简单实现，待完善实现连接池
原创SpringMvc+Mybatis+Redis框架
刘岗强的专栏
11-07 9270
声明： 本人提供这个 SpringMvc + Mybatis + Redis 的Demo 本着学习的态度，如果有欠缺和不足的地方，给予指正，并且多多包涵 框架运行环境： Maven版本：3.3.9 Eclipse版本：MARS.2 JDK版本：1.8 Tocat版本：8.0.36 框架结构：框架全采用maven管理 所以源码只有180KB左右要是不会Maven就请自行补习 in
SpringMVC + MyBatis + MySQL + Redis(作为二级缓存) 配置
超越无限_
06-19 481
前言 Mybatis 有二级缓存，为什么还要用Redis？ mybais一级缓存作用域是session，session commit之后缓存就失效了。 mybais二级缓存作用域是sessionfactory，该缓存是以namespace为单位的（也就是Mapper.xml文件），不同namespace下的操作互不影响。 所有对数据表的改变操作都会刷新缓存，但是一般不要用二级缓存，例如在UserMapper.xml中有大多数针对user表的操作，但是在另一个xxxMapepr.xml中，还有针对user单
SpringMvc+Mybatis+Redis框架
CookSjg的博客
03-13 574
原创SpringMvc+Mybatis+Redis框架 标签： MybatisSpringMVCredis邮件shiro 2016-11-07 11:02 3857人阅读 评论(18) 收藏 举报  分类： Spring（1）  版权声明：本文为博主原创文章，未经博主允许不得转载。 声明： 本人提供这个 SpringMVC + My
SpringMVC中使用Redis缓存
weixin_41419401的博客
09-08 893
下面案例为SpringMVC中使用redis做缓存，案例主要缓存项目中的菜单选项，具体过程为配置缓存池，其他业务类似。对于springBoot中使用Redis可具体参考：我的另外一篇博客，深入实践SpringBoot 一、xml配置 <!-- redis配置 --> <bean id="jedisPoolConfig" class="redis.clients.jedis....
SpringMVC + redis缓存
Lizo_Is_Me的专栏
07-27 1411
相关依赖包就不在赘述xml配置 使用JedisConnectionFactory可以很方便的创建和使用Jedis来对Redis进行操作，这里没有对权限进行控制。对Jedis进行封装import org.apache.log4j.Logger; import org.springframework.data.redis.connection.jedis.JedisConnection; import
Spring mybatis SpringMVC Redis整合！
三思微糖的博客
11-17 166
随着数据量的增大，数据库压力会越来越大，这时候我们就会想到了使用缓存来缓解数据库的压力，所有这篇文章我们就来学习一下怎么使用redis。 第一步 导入jar包 <!-- https://mvnrepository.com/artifact/org.springframework.data/spring-data-redis --> <dependency> <groupId>org.springframework.data</groupId>
springmvc+mybatis框架集成redis
fannie_yang
05-15 315
1、redis存数据(注册时将数据同时存入redis) //存入redis缓存 redisService.initializationAccount(pd); 2、redisService中的写法 public UserAccount initializationAccount(PageData pd){ UserAccount account = new U...
springmvc+mybatis+redis综合配置
夏未眠秋风起的博客
10-31 298
原文章https://blog.csdn.net/u010627840/article/details/50593659 最近在学习redis的使用方法，它的本地使用方法比较简单，只需要先启动Redis服务器，然后运行测试代码即可。但是现在我想要在网站上访问数据库的时候采用Redis缓存，问题就出来了。要么是缓存直接失效，每次都是直接访问数...
springmvc+mybatis+redis整合
yuyeqianhen的博客
05-06 402
https://www.cnblogs.com/smfx1314/archive/2018/04/26/8955289.html https://blog.csdn.net/a123demi/article/details/78284555
SpringMVC+Mybatis整合Redis实现二级缓存
"mybatis+redis缓存配置，springmvc整合Mybatis与Redis，实现二级缓存功能" 在Mybatis框架中，缓存是提高系统性能的关键组件，它允许我们在数据库查询后将结果暂存，避免频繁地进行相同查询，从而减少数据库负载。...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值