Spring整合Hibernate

 

 1.首先导入Spring和Hibernate的核心包,然后在分别导入commons-dbsp-1.4.jar和commons-pool-1-6.jar包

 2.Spring提供DAO支持Spring提供了多种数据库访问技术的DAO支持，包括Hibernate,JDO,TopLink,iBatis,OJB等。Spring可以使用相同的访问模式，不同的数据库访问技术就Hibernate的持久层访问技术而言。Spring提供了如下3个工具类（或接口）来支持DAO组件的实现。

 3.数据访问层继承Spring框架里面模板HibernateTemplete提供的HibernateDaoSupport抽象类

 4.配置数据源连接和定义SessionFactory bean【注意我这里用的是oracle数据库】 

 

4.1Spring的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:aop="http://www.springframework.org/schema/aop"
     xmlns:context="http://www.springframework.org/schema/context"
     xmlns:p="http://www.springframework.org/schema/p"  
     xsi:schemaLocation="
       http://www.springframework.org/schema/beans 
       http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
       http://www.springframework.org/schema/aop 
       http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context-3.0.xsd
   ">
   
<!-- 配置基础数据源bean -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
    <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl"></property>
    <property name="username" value="system"></property>
    <property name="password" value="orcl"></property>
</bean>
<!-- 配置Session会话工厂bean-->
<bean id="sessionFactory"  class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
     <property name="dataSource" ref="dataSource"/>
    <!--第一种方式:添加指定的对象关系映射文件-->
    <!-- <property name="mappingResources">
        <list>
            <value>com/myCinema/entity/Category.hbm.xml</value>
            <value>com/myCinema/entity/Movie.hbm.xml</value>
            <value>com/myCinema/entity/User.hbm.xml</value>
        </list>
    </property> -->
    <!--第二种方式：添加对象关系映射文件的所在路径-->
    <property name="mappingDirectoryLocations">
        <list>
            <value>classpath:com/musicstore/entity/</value>
        </list>
    </property> 
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>
            <prop key="hibernate.show_sql">true</prop>
        </props>
</property>
</bean>

    <!--配置日志切面-->
   <bean id="logAdvice"  class="com.musicstore.aop.logAdvice"></bean>
   
   <bean id="iAlbum"  class="com.musicstore.daoimpl.AlbumDaoImpl" >
          <property name="sessionFactory"  ref="sessionFactory"></property>
    </bean>
   <bean id="iGenre"  class="com.musicstore.daoimpl.GenreDaoImpl">
         <property name="sessionFactory"  ref="sessionFactory"></property>
   </bean>
   <bean id="iOrder"  class="com.musicstore.daoimpl.OrderDaoImpl">
           <property name="sessionFactory"  ref="sessionFactory"></property>
   </bean>
   <bean id="iOrderDetail"  class="com.musicstore.daoimpl.OrderDetailDaoImpl">
        <property name="sessionFactory"  ref="sessionFactory"></property>
   </bean>
   <bean id="iUser"  class="com.musicstore.daoimpl.UserDaoImpl">
        <property name="sessionFactory"  ref="sessionFactory"></property>
   </bean>
   <bean id="iUserRole"  class="com.musicstore.daoimpl.UserRoleDaoImpl">
         <property name="sessionFactory"  ref="sessionFactory"></property>
   </bean>     
</beans>

5.数据访问层的示例代码

package com.musicstore.daoimpl;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.musicstore.dao.IAlbum;
import com.musicstore.entity.Album;

public class AlbumDaoImpl extends HibernateDaoSupport implements IAlbum {

    //获取全部信息
    @Override
    public List<Album> getAll(){
         String hql="from Album";
         return getHibernateTemplate().find(hql);
    }

    //使用持久化类的导航关系进行查询
    @Override
    public List<Album> findByGenreId(int gid) {
        
        String hql="from Album as a where a.genre.id=?";
         Object[] params=new Object[]{gid};
         return getHibernateTemplate().find(hql,params);
    
        
    }

    //根据名称模糊查询，返回一个集合
    @Override
    public List<Album> findByTitle(String title) {
        String hql=" from Album as a where a.title like ?";
        return getHibernateTemplate().find(hql, ("%"+title+"%"));
    }

    //查询单个对象
    @Override
    public Album getById(long id) {
         String hql="from Album as a where a.id=? ";
         List<Album> list=getHibernateTemplate().find(hql,id);
         return list.size()>0?list.get(0):null;
    }

    //添加
    @Override
    public Album insert(Album album) throws Exception {
          Album album2=null;
          try {
                getHibernateTemplate().save(album);
                album2=album;
            } catch (Exception e) {
                return null;
            } 
          return album2;
          
    }

     //修改
    @Override
    public Album update(Album album) throws Exception {
          Album album2=null;
          try {
                getHibernateTemplate().update(album);
                album2=album;
            } catch (Exception e) {
                return null;
            } 
          return album2;
    }

    //根据名称模糊查询并进行分页
    @Override
    public List<Album> findByIdAndTitlePaging(final int gid, final String title, final int pageIndex, final int pageSize) {
        return getHibernateTemplate().execute(new HibernateCallback<List<Album>>() {
            @Override
            public List<Album> doInHibernate(Session session) throws HibernateException,
                    SQLException {
                String hql="from Album as a where 1=1 ";
                Map<String,Object> params=new HashMap<String, Object>();
                List<Album> list=new ArrayList<Album>();
                if(gid>0){
                    hql+=" and a.genre.id=:gid";
                    params.put("gid",gid);
                }
                if(title!=null){
                    hql+=" and a.title like :title ";
                    params.put("title","%" +title+"%");
                } 
             Query query=session.createQuery(hql);
             query.setProperties(params);
             query.setFirstResult((pageIndex-1)*pageSize);
             query.setMaxResults(pageSize);
             list=query.list();
            return list;
            }
        });
    }



}

6.使用HibernateTemplate

　　HibernateTemplate提供持久层访问模板，使用HibernateTemplate无须实现特定接口，它只需要提供一个SessionFactory的引用就可以执行持久化操作。SessionFactory　　对象既可通过构造函数传入，也可以通过设值传入。
　　HibernateTemplate()
　　HibernateTemplate(org.hibernates.SessionFactory sessionFactory) (这个用得较多一点)
　　HibernateTemplate(org.hibernates.SessionFactory sessionFactory,boolean allowCreate)

     常用方法:

           void delete(Object entity)：删除指定持久化实例
           deleteAll(Collection entities)：删除集合内全部持久化类实例

  　　    find(String queryString)：根据HQL查询字符串来返回实例集合

           findByNamedQuery(String queryName)：根据命名查询返回实例集合

           get(Class entityClass, Serializable id)：根据主键加载特定持久化类的实例
           save(Object entity)：保存新的实例
           saveOrUpdate(Object entity)：根据实例状态，选择保存或者更新
           update(Object entity)：更新实例的状态，要求entity是持久状态
           setMaxResults(int maxResults)：设置分页的大小