hibernate

比如Hibernate连2个数据库 的方式！
今天没事看了一下面试题，其中就有一个说的是创建两个数据源 （本地的mysql），一个链接的数据库A,另一个链接数据库b.
一：两个dataSource1,和datasource2 ，
二：两个sessionFactory1和sessionFactory2。
三：事务管理用的是spring的事务dao,org.springframework.orm.hibernate3.HibernateTransactionManager.这个也得两个来处理。一个管理sessionFactory1别一个来管理sessionFactory2.
四：最后，我们要写两套dao，都是继承HibernateDaoSupport.
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.user}" />
<property name="password" value="${jdbc.pwd}" />
</bean>


<bean id="dataSource1"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${jdbc.driver1}" />
<property name="url" value="${jdbc.url1}" />
<property name="username" value="${jdbc.user1}" />
<property name="password" value="${jdbc.pwd1}" />
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="configLocations">
<list>
<value>classpath:hibernate.cfg.xml</value>
<value>classpath:hibernate-webapp.cfg.xml</value>
</list>
</property>
</bean>


<bean id="sessionFactory1"
class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource" ref="dataSource1" />
<property name="configLocations">
<list>
<value>classpath:hibernate.cfg.xml</value>
<value>classpath:hibernate-webapp.cfg.xml</value>
</list>
</property>
</bean>

<!-- Transaction manager for a single Hibernate SessionFactory (alternative to JTA) -->
<bean id="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
<bean id="transactionManager1"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory1" />
</bean>

<bean id="commonAnnotationBeanPostProcessor"
class="org.springframework.context.annotation.CommonAnnotationBeanPostProcessor" />

<bean id="autowiredAnnotationBeanPostProcessor"
class="org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor" />


<context:annotation-config />

<!-- 扫描自动装载配置目录 -->
<context:component-scan base-package="com.twl" />

<!-- =================================================================== -->
<!-- AOP: Configuration and Aspects -->
<!-- =================================================================== -->
<aop:config proxy-target-class="true">
<aop:advisor pointcut="execution(* com.twl..*CtrlImpl.*(..))"
advice-ref="txAdvice" />
<aop:advisor pointcut="execution(* com.twl..*AjaxImpl.*(..))"
advice-ref="txAdvice" />
</aop:config>

<!-- Enable @Transactional support -->
<tx:annotation-driven />

<!-- Enable @AspectJ support -->
<aop:aspectj-autoproxy />

<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="get*" read-only="true" />
<tx:method name="find*" read-only="true" />
<tx:method name="set" propagation="NEVER" />
<tx:method name="*" propagation="REQUIRED" />
</tx:attributes>
</tx:advice>

<tx:advice id="txRollbackAdvice">
<tx:attributes>
<tx:method name="get*" rollback-for="java.lang.Exception" />
<tx:method name="set*"
no-rollback-for="java.lang.RuntimeException" />
</tx:attributes>
</tx:advice>

<bean id="genericDao"
class="com.company.framework.dao.impl.GenericDaoImpl">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>

<bean id="genericOtherDao"
class=" com.company.other.otherdao.dao.GenericOtherDaoImpl">
<property name="sessionFactory">
<ref bean="sessionFactory1" />
</property>
</bean>


完成以上的代码后，我们只需要在我们需要的地方注入我们要的dao就行了。