在web開發(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ì)本站的支持!
新聞熱點(diǎn)
疑難解答
圖片精選