spring-status-hibernate

web.xml配置 增加过滤器开启struts控制器和开启延迟加载并指定spring容器对象

<?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">

    <!-- opensessioninviewfilter,放在struts2 filter之前  开启延迟加载 -->
    <filter>
        <filter-name>opensession</filter-name>
        <filter-class>
        org.springframework.orm.hibernate4.support.OpenSessionInViewFilter
        </filter-class>
    </filter>



    <!-- 使用过滤加载strtus2控制器 -->
    <filter-mapping>
        <filter-name>opensession</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    <filter>
        <filter-name>strutsmvc</filter-name>
        <filter-class>
    org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
        </filter-class>
        <!-- 默认找src/struts.xml配置文件,找action和result配置 -->
        <!-- 默认只有.action或没有扩展名请求会找action处理 -->
    </filter>
    <filter-mapping>
        <filter-name>strutsmvc</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>



    <!-- 指定Spring容器配置文件 -->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>
    <!-- 创建Spring容器对象 -->
    <listener>
        <listener-class>
        org.springframework.web.context.ContextLoaderListener
        </listener-class>
    </listener>

    <distributable/>

</web-app>

maven pom.xml配置

• 自动加载jar包

<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>cn.xdl</groupId>

  <artifactId>ssh_01</artifactId>

  <version>0.0.1-SNAPSHOT</version>

  <packaging>war</packaging>

  <!-- java源文件编码 -->

    <properties>

        <project.build.sourceEncoding>

              UTF-8
        </project.build.sourceEncoding>
    </properties>

  <!-- jar -->

  <!-- http://maven.aliyun.com/nexus/ -->

  <dependencies>

  <dependency>

      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>

  </dependency>

  <dependency>

      <groupId>Javax.servlet</groupId>
      <artifactId>servlet-api</artifactId>
      <version>3.0-alpha-1</version>

  </dependency>

  <dependency>

      <groupId>org.apache.struts</groupId>
      <artifactId>struts2-core</artifactId>
      <version>2.3.31</version>
      <exclusions>
        <exclusion>
            <groupId>javassist</groupId>
            <artifactId>javassist</artifactId>
        </exclusion>
      </exclusions>

  </dependency>

  <dependency>

  <groupId>org.apache.struts</groupId>

  <artifactId>struts2-json-plugin</artifactId>

  <version>2.3.31</version>

  </dependency>

    <dependency>
      <groupId>org.apache.struts</groupId>
      <artifactId>struts2-convention-plugin</artifactId>
      <version>2.3.31</version>
    </dependency>

  <dependency>

  <groupId>jstl</groupId>

  <artifactId>jstl</artifactId>

  <version>1.2</version>

</dependency>

  <!-- spring环境 -->

  <dependency>

  <groupId>org.springframework</groupId>

  <artifactId>spring-orm</artifactId>

  <version>4.1.6.RELEASE</version>

</dependency>

  <dependency>

  <groupId>org.springframework</groupId>

  <artifactId>spring-jdbc</artifactId>

  <version>4.1.6.RELEASE</version>

</dependency>

  <dependency>

  <groupId>org.springframework</groupId>

  <artifactId>spring-aop</artifactId>

  <version>4.1.6.RELEASE</version>

</dependency>

<dependency>

  <groupId>org.springframework</groupId>

  <artifactId>spring-web</artifactId>

  <version>4.1.6.RELEASE</version>

</dependency>

<dependency>

  <groupId>org.springframework</groupId>

  <artifactId>spring-test</artifactId>

  <version>4.1.6.RELEASE</version>

</dependency>

  <!-- struts2-spring-plugin.jar -->

  <dependency>

  <groupId>org.apache.struts</groupId>

  <artifactId>struts2-spring-plugin</artifactId>

  <version>2.3.31</version>

</dependency>

<!-- hibernate -->

<dependency>

  <groupId>org.hibernate</groupId>

  <artifactId>hibernate-core</artifactId>

  <version>4.2.21.Final</version>

</dependency>

<dependency>

  <groupId>org.hibernate</groupId>

  <artifactId>hibernate-ehcache</artifactId>

  <version>4.2.21.Final</version>

</dependency>

<!-- c3p0 -->

<dependency>

  <groupId>c3p0</groupId>

  <artifactId>c3p0</artifactId>

  <version>0.9.1.2</version>

</dependency>

<dependency>

  <groupId>mysql</groupId>

  <artifactId>mysql-connector-java</artifactId>

  <version>5.1.8</version>

</dependency>

  </dependencies>

    <!-- 指定编译版本和编码 -->

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>2.3.2</version>
                <configuration>
                    <source>1.7</source>
                    <target>1.7</target>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>
        </plugins>

        <defaultGoal>compile</defaultGoal>
    </build>

</project>

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:jdbc="http://www.springframework.org/schema/jdbc"  
    xmlns:jee="http://www.springframework.org/schema/jee" 
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:aop="http://www.springframework.org/schema/aop" 
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:util="http://www.springframework.org/schema/util"
    xmlns:jpa="http://www.springframework.org/schema/data/jpa"
    xsi:schemaLocation="
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd
        http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.1.xsd
        http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-4.1.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsd
        http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.1.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd
        http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.1.xsd">

    <!-- 扫描Action -->
    <context:component-scan base-package="cn.xdl.action"/>
    <!-- 扫描Dao -->
    <context:component-scan base-package="cn.xdl.dao"/>

    <!-- JdbcTemplate对象 -->
    <bean id="template" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="c3p0"></property>
    </bean>

    <!-- c3p0 -->
    <bean id="c3p0" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="user" value="root"></property>
        <property name="password" value="root"></property>
        <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
        <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/studyonline?useUnicode=true&amp;characterEncoding=utf8"></property>
    </bean>

    <!-- HibernateTemplate -->
    <bean id="hibernateTemplate" class="org.springframework.orm.hibernate4.HibernateTemplate">
        <property name="sessionFactory" ref="sessionFactory"></property>
    </bean>

    <!-- SessionFactory -->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <!-- 指定连接池 -->
        <property name="dataSource" ref="c3p0">
        </property>
        <!-- 指定hibernate.cfg.xml -->
        <property name="configLocations" value="classpath:hibernate.cfg.xml">
        </property>
    </bean>

    <!-- Hibernate事务处理 -->
    <bean id="txManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory"></property>
    </bean>
    <!-- 支持@Transactional -->
    <tx:annotation-driven transaction-manager="txManager" 
        proxy-target-class="true"/>

</beans>

hibernate配置

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

    <session-factory>
        <property name="dialect">
            org.hibernate.dialect.MySQLDialect
        </property>



        <!-- 显示底层sql语句 -->
        <property name="show_sql">true</property>
        <property name="format_sql">true</property>


        <!-- 开启二级缓存 -->
        <property name="hibernate.cache.use_sencond_level_cache">true</property>
        <property name="hibernate.cache.region.factory_class">
        org.hibernate.cache.ehcache.EhCacheRegionFactory
        </property>
        <!-- 开启查询缓存 -->
        <property name="hibernate.cache.use_query_cache">true</property>



        <!--关联映射的实体类-->
         <mapping class="cn.xdl.entity.Note"/>
         <mapping class="cn.xdl.entity.User"/>

    </session-factory>

</hibernate-configuration>

实体类配置

//定义为映射组件
@Entity
//映射数据库的哪个表
@Table(name="NOTE")
//开启二级缓存的只读
@Cache(usage=CacheConcurrencyStrategy.READ_ONLY)
public class Note {

    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    @Column(name="ID")
    private Integer id;

    @Column(name="CONTEXT")
    private String context;

    @Column(name="PUBLISH_TIME")
    private Date publishTime;

    @Column(name="LIKE_COUNT")
    private Integer likeCount;

//  @Column(name="USER_ID")
//    private Integer userId;

    @Column(name="VIDEO_ID")
    private Integer videoId;

    //追加关联属性 一级缓存
    //在user属性前追加下面标记 表示多对一
    //FetchType.LAZY：懒加载，加载一个实体时，定义懒加载的属性不会马上从数据库中加载。页面需要时再执行查询
    //FetchType.EAGER：急加载，加载一个实体时，定义急加载的属性会立即从数据库中加载。
    @ManyToOne(fetch=FetchType.LAZY)
    //建立User和Note的单表映射
    //在Note类中加user属性，删除原有的userId属性
    @JoinColumn(name="USER_ID")
    //设置只读属性，只可以对数据库进行读取
    //CacheConcurrencyStrategy.NONE
    //CacheConcurrencyStrategy.READ_ONLY，只读模式，在此模式下，如果对数据进行更新操作，会有异常；
    //CacheConcurrencyStrategy.READ_WRITE，读写模式在更新缓存的时候会把缓存里面的数据换成一个锁，其它事务如果去取相应的缓存数据，发现被锁了，直接就去数据库查询；
    //CacheConcurrencyStrategy.NONSTRICT_READ_WRITE，不严格的读写模式则不会的缓存数据加锁；
    //CacheConcurrencyStrategy.TRANSACTIONAL，事务模式指缓存支持事务，当事务回滚时，缓存也能回滚，只支持JTA环境。
    @Cache(usage=CacheConcurrencyStrategy.READ_ONLY)
    private User user;

二级缓存的配置

<ehcache>

    <diskStore path="java.io.tmpdir"/>
    //默认缓存
    <defaultCache
        maxElementsInMemory="1000"＜!-- 缓存最大数目 --＞  
        eternal="false"＜!-- 缓存是否持久 --＞ 
        timeToIdleSeconds="10"＜!-- 当缓存闲置n秒后销毁 --＞  
        timeToLiveSeconds="120"＜!-- 当缓存存活n秒后销毁--＞ 
        overflowToDisk="true"＜!-- 是否保存到磁盘，当系统当机时 查询出来的缓存数据超过了最大数目--＞
        />

    <cache name="sampleCache1"
        maxElementsInMemory="10000"
        eternal="false"
        timeToIdleSeconds="300"
        timeToLiveSeconds="600"
        overflowToDisk="true"
        />

    <cache name="sampleCache2"
    maxElementsInMemory="1000"
    eternal="true"
    timeToIdleSeconds="0"
    timeToLiveSeconds="0"
    overflowToDisk="false"
    /> 



</ehcache>

DAO接口实现类和查询缓存的开启

package cn.xdl.dao.impl;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.orm.hibernate4.HibernateTemplate;
import org.springframework.stereotype.Repository;

import cn.xdl.dao.NoteDao;
import cn.xdl.entity.Note;

@Repository("noteDao1")
public class HibernateNoteDao implements NoteDao{

    @Resource
    private HibernateTemplate hibernateTemplate;

    @Override
    public List<Note> selectByUserId(int userId) {
        String hql = "from Note where user.id=?";

        //启用缓存，查询缓存的开启，在执行查询语句之前调用该方法执行查询缓存
        hibernateTemplate.setCacheQueries(true);
        List list = hibernateTemplate.find(hql, userId);
        return list;
    }

    @Override
    public int deleteById(int id) {
        Note note = hibernateTemplate.get(Note.class, id);
        if(note==null){
            return 0;
        }else{
            hibernateTemplate.delete(note);
            return 1;
        }
    }

    @Override
    public Note selectById(int id) {
        try{
            Note note = hibernateTemplate.load(Note.class, id);
            return note;
        }catch(Exception e){
            return null;
        }
    }

}