Spring与Hibernate两种组合方式 (转)

Spring与Hibernate大致有两种组合方式，主要区别是一种是在Hibernate中的hibernate.cfg.xml中配置数据源，一种 是借助Spring的jdbc方式在Spring的applicationContext.xml文件中配置数据源,然后在Spring配置 sessionFactory的bean有些区别

 

下面大致的说明一下

第一种

1.hibernate.cfg.xml文件

 

  <xml version='1.0' encoding='utf-8'?> 
  <!DOCTYPE hibernate-configuration SYSTEM  
  "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> 
  
  <hibernate-configuration>   
	<session-factory>           
		<property name="connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriverproperty> 
		<property name="connection.url">jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=acegi;SelectMethod=cursorproperty> 
		<property name="connection.username">saproperty> 
		<property name="connection.password">serverproperty> 
		<property name="show_sql">trueproperty>   
		<mapping resource=""/> 
	</session-factory>   
  <hibernate-configuration> 

2.在spring配置sessionFactory

 

   <bean id="sessionFactory"    class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> 
		<property name="configLocation" value="classpath:hibernate.cfg.xml"></property> 
   </bean> 
   <bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> 
		<property name="sessionFactory" ref="sessionFactory"></property> 
   </bean> 
   <tx:annotation-driven transaction-manager="txManager"/>

 或者实现hibernate零配置

 

   <bean id="sessionFactory"    class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> 
		<property name="configLocation" value="classpath:hibernate.cfg.xml"></property> 

                <property name="packagesToScan" value="com/wch/entity/"></property>
   </bean> 
   <bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> 
		<property name="sessionFactory" ref="sessionFactory"></property> 
   </bean> 
   <tx:annotation-driven transaction-manager="txManager"/> 

 

第二种

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"> 
	<property name="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/> 
    <property name="url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=acegi;SelectMethod=cursor"/> 
    <property name="username" value="sa"/> 
    <property name="password" value="server"/>  
</bean> 

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"> 
	<property name="dataSource" value="dataSource"></property> 
	<property name="mappingResources"> 
        <list> 
            <value>user.hbm.xml</value> 
        </list> 
    </property> 
    <property name="hibernateProperties"> 
        <props> 
           <prop key="hibernate.show_sql">true</prop> 
		</props> 
     </property> 
</bean>    
    
<bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> 
	<property name="sessionFactory" ref="sessionFactory"></property> 
</bean> 
<tx:annotation-driven transaction-manager="txManager"/> 

 

 或者实现hibernate的零配置

 

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"> 
	<property name="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/> 
    <property name="url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=acegi;SelectMethod=cursor"/> 
    <property name="username" value="sa"/> 
    <property name="password" value="server"/>  
</bean> 

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"> 
	<property name="dataSource" value="dataSource"></property>
	<property name="packagesToScan" value="com/wch/entity/"></property> 
</bean>    
    
<bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> 
	<property name="sessionFactory" ref="sessionFactory"></property> 
</bean> 
<tx:annotation-driven transaction-manager="txManager"/> 

 

 

下面是一些配置例子

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">

<beans>
    <!-- dataSource -->
    <bean id="dataSource"
        class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName"
            value="com.microsoft.jdbc.sqlserver.SQLServerDriver">
        </property>
        <property name="url"
            value="jdbc:microsoft:sqlserver://192.168.0.9:1433;databaseName=dbxx;">
        </property>
        <property name="username" value="sa"></property>
        <property name="password" value="11111111"></property>
    </bean>
    <!--hibernate事务-->
    <bean id="transactionManager"
        class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory">
            <ref local="sessionFactory" />
        </property>
    </bean>
    <!-- 基础事务代理 -->
    <bean id="baseTxProxy" abstract="true"
        class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
        <property name="transactionManager">
            <ref local="transactionManager" />
        </property>
        <property name="transactionAttributes">
            <props>
                <prop key="save*">PROPAGATION_REQUIRED,-Throwable</prop>
                <prop key="remove*">
                    PROPAGATION_REQUIRED,-Throwable
                </prop>
                <prop key="merge">PROPAGATION_REQUIRED,-Throwable</prop>
                <prop key="update">PROPAGATION_REQUIRED,-Throwable</prop>
                <prop key="do*">PROPAGATION_REQUIRED,-Throwable</prop>
            </props>
        </property>
    </bean>
    <!-- sqlMapClient -->
    <bean id="sqlMapClient"
        class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
        <property name="configLocation">
            <value>WEB-INF/classes/sql-map-config-sqlserver.xml</value>
        </property>
    </bean>
    <!-- Hibernate的sessionFactory工厂 -->
    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        <property name="dataSource">
            <ref bean="dataSource" />
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
                <prop key="hibernate.show_sql">false</prop>
                <prop key="hibernate.format_sql">false</prop>
                <prop key="hibernate.use_sql_comments">false</prop>
                <!-- 为单向关联(一对一, 多对一)的外连接抓取（outer join fetch）树设置最大深度. 值为0意味着将关闭默认的外连接抓取 -->
                <prop key="hibernate.max_fetch_depth">3</prop>
                <!-- 为Hibernate关联的批量抓取设置默认数量 -->
                <prop key="hibernate.default_batch_fetch_size">8</prop>
                <!-- 强制Hibernate按照被更新数据的主键，为SQL更新排序。这么做将减少在高并发系统中事务的死锁。 -->
                <prop key="hibernate.order_updates">true</prop>
                <!-- session在事务完成后将被自动清洗(flush) -->
                <prop key="hibernate.transaction.flush_before_completion">true</prop>
                <!-- Oracle限制那些通过JDBC驱动传输的字节数组的数目. 如果你希望使用二进值 (binary)或 可序列化的 (serializable)类型的大对象, 你应该开启 hibernate.jdbc.use_streams_for_binary属性.  -->
                <prop key="hibernate.bytecode.use_reflection_optimizer">true</prop>
            </props>
        </property>
        <property name="mappingResources">
            <list>
                <value>com/xxx/cqry/domain/Client.hbm.xml</value>
            </list>
        </property>
    </bean>
    <!-- locator -->
    <bean name="cqry.locator"
        class="com.xxx.cqry.server.ServerLocator">
        <property name="clientServer">
            <ref local="clientServer" />
        </property>
    </bean>
    <!-- daoFacade -->
    <bean id="daoFacade" class="com.xxx.cqry.dao.DaoFacade">
        <property name="clientDao">
            <ref local="clientDao" />
        </property>
    </bean>
    <bean id="baseDao" class="com.xxx.cqry.dao.BaseDAO">
        <property name="sessionFactory">
            <ref local="sessionFactory" />
        </property>
        <property name="dataSource">
            <ref bean="dataSource" />
        </property>
        <property name="sqlMapClient">
            <ref local="sqlMapClient" />
        </property>
    </bean>
    <bean id="clientDao" class="com.xxx.cqry.dao.ClientDAO" parent="baseDao"></bean>
    <!-- baseServer -->
    <bean id="baseServer"
        class="com.xxx.cqry.server.impl.BaseServerImpl">
        <property name="daoFacade">
            <ref local="daoFacade" />
        </property>
    </bean>
    <bean id="clientServer" parent="baseTxProxy">
        <property name="target">
            <bean class="com.xxx.cqry.server.impl.ClientServerImpl"
                parent="baseServer" />
        </property>
    </bean>
</beans>

 

 

 

下面是PostgresSQL and MySQL hibernate.cfg.xml examples

 

 

PostgreSQL Version:

<?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">
<hibernate-configuration>
<session-factory>
	<property name="connection.url">jdbc:postgresql://localhost/firsthibernate</property>
	<property name="connection.username">postgres</property>
	<property name="connection.driver_class">org.postgresql.Driver</property>
	<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
	<property name="connection.password">p</property>
 <property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
    <!--  thread is the short name for
      org.hibernate.context.ThreadLocalSessionContext
      and let Hibernate bind the session automatically to the thread
    -->
    <property name="current_session_context_class">thread</property>
    <!-- this will show us all sql statements -->
    <property name="hibernate.show_sql">true</property>
	<!-- mapping files -->
	<mapping resource="de/laliluna/example/Honey.hbm.xml" />
</session-factory>
</hibernate-configuration>


MySQL Version:


<?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">
<hibernate-configuration>
<session-factory>
	<property name="connection.url">jdbc:mysql://localhost/firsthibernate</property>
	<property name="connection.username">root</property>
	<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
	<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
	<property name="connection.password">r</property>
 <property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
    <!--  thread is the short name for
      org.hibernate.context.ThreadLocalSessionContext
      and let Hibernate bind the session automatically to the thread
    -->
    <property name="current_session_context_class">thread</property>
    <!-- this will show us all sql statements -->
    <property name="hibernate.show_sql">true</property>

	<!-- mapping files -->
	<mapping resource="de/laliluna/example/Honey.hbm.xml" />

</session-factory>
</hibernate-configuration>