在web開(kāi)發(fā)中,可以利用hibernate配置數(shù)據(jù)源,但在實(shí)際的應(yīng)用中,可能要連接多個(gè)數(shù)據(jù)源,
1.配置dataSource
bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
property name="driverClassName">
value>org.logicalcobwebs.proxool.ProxoolDriver/value>
/property>
property name="url">
value>proxool.db/value>
/property>
/bean>
2.配置sessionFactory
bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
property name="dataSource">
ref local="dataSource">/ref>
/property>
property name="hibernateProperties">
props>
prop key="hibernate.connection.provider_class"> org.hibernate.connection.C3P0ConnectionProvider/prop>
!-- 是否將運(yùn)行期生成的SQL輸出到日志以供調(diào)試 -->
prop key="hibernate.show_sql">true/prop>
!--指定連接的語(yǔ)言-->
prop key="dialect"> org.hibernate.dialect.MySQLDialect /prop>
!--是否收集有助于性能調(diào)節(jié)的統(tǒng)計(jì)數(shù)據(jù)-->
prop key="hibernate.generate_statistics">true/prop>
!--是否自動(dòng)重新連接-->
prop key="hibernate.autoReconnect">true/prop>
!--是否自動(dòng)釋放連接-->
prop key="hibernate.connection.release_mode">auto/prop>
!--緩存配置-->
prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider /prop>
prop key="hibernate.cache.use_second_level_cache"> false /prop>
prop key="hibernate.cache.use_query_cache">false/prop>
/props>
/property>
property name="mappingResources">
list>
value>映射表/value>
/list>
/property>
/bean>
3.添加jdbc支持
bean id="jdbcTemplatelr" class="org.springframework.jdbc.core.JdbcTemplate">
property name="dataSource">
ref bean="dataSourceLrsql"/>
/property>
/bean>
bean id="basePageDao" class="com.BasePageDaoHibernateImpl">
property name="jdbcTemplate">
ref bean="jdbcTemplatelr"/>
/property>
/bean>
感謝閱讀,希望能幫助到大家,謝謝大家對(duì)本站的支持!
您可能感興趣的文章:- Web設(shè)計(jì)中如何使用XML數(shù)據(jù)源對(duì)象