Hibernate&Spring对多数据源、多Schema的支持

最新推荐文章于 2023-10-17 17:32:59 发布
最新推荐文章于 2023-10-17 17:32:59 发布
阅读量3.9k 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sTeVes/article/details/22878581
版权
Hibernate&Spring对多数据源、多Schema的支持
@author:WMsteve
@Email:weisteve@yeah.net
@Time:2011年12月30日17:02:55
@Modify Time:2012年1月1日13:17:35 v1.1
 
Hibernate是一个开源的对象映射框架。它实现了对JDBC的轻量级封装，使得java开发人员能够使用对象的概念来操作数据源。下面介绍Hibernate中重要的四个概念：
Session接口
Session接口负责执行被持久化对象的CRUD操作(CRUD的任务是完成与数据库的交流，包含了很多常见的SQL语句。)。但需要注意的是Session对象是非线程安全的。同时，Hibernate的session不同于JSP应用中的HttpSession。这里当使用session这个术语时，其实指的是Hibernate中的session，而以后会将HttpSession对象称为用户session。
SessionFactory接口
SessionFactory接口负责初始化Hibernate。它充当数据存储源的代理，并负责创建Session对象。这里用到了工厂模式。需要注意的是SessionFactory并不是轻量级的，因为一般情况下，一个项目通常只需要一个SessionFactory就够，当需要操作多个数据库时，可以为每个数据库指定一个SessionFactory。
Configuration接口
Configuration接口负责配置并启动Hibernate，创建SessionFactory对象。在Hibernate的启动的过程中，Configuration类的实例首先定位映射文档位置、读取配置，然后创建SessionFactory对象。
Transaction接口
Transaction接口负责事务相关的操作。它是可选的，开发人员也可以设计编写自己的底层事务处理代码。
Query和Criteria接口
Query和Criteria接口负责执行各种数据库查询。它可以使用HQL语言或SQL语句两种表达方式。
Spring框架
Spring是一个开源的控制反转的j2ee框架，它是为了解决企业应用开发的复杂性而创建的。Spring使用基本的JavaBean来完成以前只可能由EJB完成的事情。然而，Spring的用途不仅限于服务器端的开发。从简单性、可测试性和松耦合的角度而言，任何Java应用都可以从Spring中受益。
现在我们需要借助这两个框架来实现对多数据源和多数据表空间进行操作。
 
首先看Spring的配置文件：applicationContext.xml
<! - - 配置stu库的会话工厂 @author:Wmsteve weisteve@yeah.net 2011年 12月 29日 9: 02: 50 - - >
<bean id = "sessionFactoryStu"
class = "org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean" >
<property name = "configLocation"
value = "classpath:hibernate_stu.xml" >
< /property >
< /bean >
<! - - 配置common库的会话工厂 @author:Wmsteve weisteve@yeah.net 2011年 12月 29日 9: 02: 50 - - >
<bean id = "sessionFactoryCommon"
class = "org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean" >
<property name = "configLocation"
value = "classpath:hibernate_common.xml" >
< /property >
< /bean >
 
上述配置文件中，通过配置common和stu两个独立的sessionFactory，来达到初始化两个不同的hibernate会话工厂，其中hibernate中两个对应的不同的具体配置是通过
<property name = "configLocation"
value = "classpath:hibernate_stu.xml" >
<property name = "configLocation"
value = "classpath:hibernate_common.xml" >
 
将hibernate的具体配置转移到了hibernate_stu.xml和hibernate_common.xml两个文件中；
在这种模式下，控制权已经转交给了Spring托管，Hibernate框架帮助我们生成的HibernateSessionFactory已经不再需要。
 
下面详细看下这两个文件内容（Spring托管的多数据源的文件）：
<session -factory >
<property name = "dialect" >
org.hibernate.dialect.Oracle9Dialect
< /property >
<property name = "show_SQL" >true < /property >
<property name = "connection.url" >
jdbc:oracle:thin:@ 10. 4. 10. 92: 1521:DJoracle
< /property >
<property name = "connection.username" >DJUSER < /property >
<property name = "connection.password" >DongJiang2011 < /property >
<property name = "connection.driver_class" >
oracle.jdbc.driver.OracleDriver
< /property >
<property name = "myeclipse.connection.profile" >
Oracle 11 g_common
< /property >
<mapping resource = "com/dj/hibernate/DJDB_HI/StAddvcdD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StAstrotdF.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StDayevR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StEnnmcdD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StEstatR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StEuntlangD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StFfrarB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StFieldD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StForecastcF.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StForecastF.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StFraparB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StFsdrB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StGateR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StGrwavR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StGrwevsR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StGrwR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StHailR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StIcefrF.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StImginfoR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StInstcdB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StInstcdE.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StIovRGd.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StMfloodRGd.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPddmyavS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPdmmyavS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPdmmysqS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPmevsR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPptnR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPstatR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPumpqRGd.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPumpR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StQliceinfR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StQticeinfR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StReglatF.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRiverR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRsvravR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRsvrevsR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRsvrfcchB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRsvrfsrB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRsvrmyavS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRsvrR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRsvrstrlB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvavR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvdaymyavS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvdmevsqS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvdmmyavS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvdmmysqS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvevsR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvfcchB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvsectB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvyevsqS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StSaltRGd.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StSedfrF.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StSedR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StSedrfR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StSnowR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StSoilchB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StSoilR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StStbprpB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StStcdE.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StStormR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StStsmtaskB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTableD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTableE.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTdfrF.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTideavR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTideevsR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTideR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTmpavR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTmpevsR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTmpR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWasavR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWasevsR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWasR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWasrlB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWdpstatR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWdwvR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWgrwR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWgrwstatR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWspavsdR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StZqrlB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StZvarlB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqAaacpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqAbtpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqAcrpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqAdlrrB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqAdnmB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqAobiA.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqAowqmsrA.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqBcpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqGwsinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqHydroeD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqLreasA.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqLrinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqLrsrB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqMispD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqMooopD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqMsarA.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqNmispD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqOpcpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqPasA.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqPcpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqPhncpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqPlevD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqPrecordD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqPrsinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqSdwasD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqSmsinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqSwsinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWbhpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWbspD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWfrarA.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWfrinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWfrsrB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWqsinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWrcrinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWrcrsrB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWrrarA.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWrrinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWrrlrrB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrClctpotB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDfagB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDflicbcaM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDflicbcwM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDflicM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDflicycaM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDflicycwM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDstwsplM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDstwuM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDswqW.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrFtwrfC.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrMsdwasD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrMswqW.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrPcnctrtM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrRiverW.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrRldwC.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrRlmwC.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrRlywC.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrRsvrW.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrSmsinspD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrSmsstB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrSrchstB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrSrcinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrSrcqstB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrSwsplinfS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWfrinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWfrmngM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWmorgpM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWrcrinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWrflvM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWrrinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWsfsplS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWubcM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrYsdwasD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrYswqW.hbm.xml" / >
< /session -factory >
 
另外一个数据源配置文件如下：
<session -factory >
<property name = "dialect" >
org.hibernate.dialect.Oracle9Dialect
< /property >
<property name = "show_SQL" >true < /property >
<property name = "connection.url" >
jdbc:oracle:thin:@ 10. 4. 10. 92: 1521:DJoracle
< /property >
<property name = "connection.username" >DJUSER < /property >
<property name = "connection.password" >DongJiang2011 < /property >
<property name = "connection.driver_class" >
oracle.jdbc.driver.OracleDriver
< /property >
<property name = "myeclipse.connection.profile" >
Oracle 11 g_common
< /property >
<mapping resource = "com/dj/hibernate/DJDB_HI/StAddvcdD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StAstrotdF.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StDayevR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StEnnmcdD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StEstatR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StEuntlangD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StFfrarB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StFieldD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StForecastcF.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StForecastF.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StFraparB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StFsdrB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StGateR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StGrwavR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StGrwevsR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StGrwR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StHailR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StIcefrF.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StImginfoR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StInstcdB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StInstcdE.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StIovRGd.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StMfloodRGd.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPddmyavS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPdmmyavS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPdmmysqS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPmevsR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPptnR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPstatR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPumpqRGd.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StPumpR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StQliceinfR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StQticeinfR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StReglatF.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRiverR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRsvravR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRsvrevsR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRsvrfcchB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRsvrfsrB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRsvrmyavS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRsvrR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRsvrstrlB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvavR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvdaymyavS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvdmevsqS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvdmmyavS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvdmmysqS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvevsR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvfcchB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvsectB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StRvyevsqS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StSaltRGd.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StSedfrF.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StSedR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StSedrfR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StSnowR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StSoilchB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StSoilR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StStbprpB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StStcdE.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StStormR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StStsmtaskB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTableD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTableE.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTdfrF.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTideavR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTideevsR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTideR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTmpavR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTmpevsR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StTmpR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWasavR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWasevsR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWasR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWasrlB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWdpstatR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWdwvR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWgrwR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWgrwstatR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StWspavsdR.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StZqrlB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_HI/StZvarlB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqAaacpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqAbtpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqAcrpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqAdlrrB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqAdnmB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqAobiA.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqAowqmsrA.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqBcpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqGwsinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqHydroeD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqLreasA.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqLrinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqLrsrB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqMispD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqMooopD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqMsarA.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqNmispD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqOpcpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqPasA.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqPcpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqPhncpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqPlevD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqPrecordD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqPrsinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqSdwasD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqSmsinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqSwsinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWbhpD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWbspD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWfrarA.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWfrinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWfrsrB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWqsinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWrcrinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWrcrsrB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWrrarA.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWrrinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WQ/WqWrrlrrB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrClctpotB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDfagB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDflicbcaM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDflicbcwM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDflicM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDflicycaM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDflicycwM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDstwsplM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDstwuM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrDswqW.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrFtwrfC.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrMsdwasD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrMswqW.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrPcnctrtM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrRiverW.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrRldwC.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrRlmwC.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrRlywC.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrRsvrW.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrSmsinspD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrSmsstB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrSrchstB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrSrcinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrSrcqstB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrSwsplinfS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWfrinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWfrmngM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWmorgpM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWrcrinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWrflvM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWrrinfB.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWsfsplS.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrWubcM.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrYsdwasD.hbm.xml" / >
<mapping resource = "com/dj/hibernate/DJDB_WR/WrYswqW.hbm.xml" / >
< /session -factory >
 
看到上面两个hibernate配置文件，您可以发现，这两个配置中可以完全独立的配置信息，通过spring来完成了Session的管理。
下面看Spring的applicationContext.xml中bean的配置：
<! - - 配置stu库的DAO控制反转 @author:Wmsteve weisteve@yeah.net 2011年 12月 29日 9: 02: 50 - - >
<bean id = "StDayevRDAO" class = "com.dj.hibernate.stu.StDayevRDAO" >
    <property name = "sessionFactory" >
        <ref bean = "sessionFactoryStu" / >
< /property >
< /bean >
<bean id = "StGateFDAO" class = "com.dj.hibernate.stu.StGateFDAO" >
    <property name = "sessionFactory" >
        <ref bean = "sessionFactoryStu" / >
< /property >
< /bean >
<bean id = "StTmpRHisDAO" class = "com.dj.hibernate.stu.StTmpRHisDAO" >
    <property name = "sessionFactory" >
        <ref bean = "sessionFactoryStu" / >
    < /property >
< /bean > 
<bean id = "WrSrcinfBDAO"
    class = "com.dj.hibernate.DJDB_WR.WrSrcinfBDAO" >
    <property name = "sessionFactory" >
        <ref bean = "sessionFactoryCommon" / >
    < /property >
< /bean >
<bean id = "WrWrcrinfBDAO"
    class = "com.dj.hibernate.DJDB_WR.WrWrcrinfBDAO" >
    <property name = "sessionFactory" >
        <ref bean = "sessionFactoryCommon" / >
    < /property >
< /bean >
<bean id = "WrRiverWDAO"
    class = "com.dj.hibernate.DJDB_WR.WrRiverWDAO" >
    <property name = "sessionFactory" >
        <ref bean = "sessionFactoryCommon" / >
    < /property >
< /bean >
 
这样就可以实现了hiberante借助spring实现对对数据源和多数据表空间的托管；
 
上述多数据源是通过Spring进行托管不同数据源的访问；
同时如果项目中不引入Spring，还可以通过分别调用HibernateSessionFactory中的：
/**
* return session factory
*
* session factory will be rebuilded in the next call
*/
public static void setConfigFile(String configFile) {
    HibernateSessionFactory.configFile = configFile;
    sessionFactory = null;
}
切换不同的配置xml文件，完成不同数据源的切换；
完整的HibernateSessionFactory内容如下：
package com.dj.hibernate; 

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
import org.hibernate.cfg.AnnotationConfiguration;

/**
 * Configures and provides access to Hibernate sessions, tied to the
 * current thread of execution. Follows the Thread Local Session
 * pattern, see {@link http://hibernate.org/42.html }.
 */
public class HibernateSessionFactory {

     /** 
     * Location of hibernate.cfg.xml file.
     * Location should be on the classpath as Hibernate uses  
     * #resourceAsStream style lookup for its configuration file. 
     * The default classpath location of the hibernate config file is 
     * in the default package. Use #setConfigFile() to update 
     * the location of the configuration file for the current session.   
     */
     private static String CONFIG_FILE_LOCATION = "/hibernate_common.xml";
     private static final ThreadLocal <Session > threadLocal = new ThreadLocal <Session >();
     private static Configuration configuration = new AnnotationConfiguration();
     private static org.hibernate.SessionFactory sessionFactory;
     private static String configFile = CONFIG_FILE_LOCATION;

     static {
         try {
            configuration.configure(configFile);
            sessionFactory = configuration.buildSessionFactory();
        } catch (Exception e) {
            System.err
                    .println( "%%%% Error Creating SessionFactory %%%%");
            e.printStackTrace();
        }
    }
     private HibernateSessionFactory() {
    }

     /**
     * Returns the ThreadLocal Session instance. Lazy initialize
     * the <code>SessionFactory</code> if needed.
     *
     * @return Session
     * @throws HibernateException
     */
     public static Session getSession() throws HibernateException {
        Session session = (Session) threadLocal.get();

         if (session == null || !session.isOpen()) {
             if (sessionFactory == null) {
                rebuildSessionFactory();
            }
            session = (sessionFactory != null) ? sessionFactory.openSession()
                     : null;
            threadLocal.set(session);
        }

         return session;
    }

     /**
     * Rebuild hibernate session factory
     *
     */
     public static void rebuildSessionFactory() {
         try {
            configuration.configure(configFile);
            sessionFactory = configuration.buildSessionFactory();
        } catch (Exception e) {
            System.err
                    .println( "%%%% Error Creating SessionFactory %%%%");
            e.printStackTrace();
        }
    }

     /**
     * Close the single hibernate session instance.
     *
     * @throws HibernateException
     */
     public static void closeSession() throws HibernateException {
        Session session = (Session) threadLocal.get();
        threadLocal.set(null);

         if (session != null) {
            session.close();
        }
    }

     /**
     * return session factory
     *
     */
     public static org.hibernate.SessionFactory getSessionFactory() {
         return sessionFactory;
    }

     /**
     * return session factory
     *
     *    session factory will be rebuilded in the next call
     */
     public static void setConfigFile(String configFile) {
        HibernateSessionFactory.configFile = configFile;
        sessionFactory = null;
    }

     /**
     * return hibernate configuration
     *
     */
     public static Configuration getConfiguration() {
         return configuration;
    }

}
 
Spring托管后的多数据源的操作样例程序如下：
package com.dj.service.cis; 

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.dj.hibernate.dao.CommonDao;
import com.dj.hibernate.stu.StRiverR;
import com.dj.hibernate.stu.StStbprpB;
import com.dj.view.dto.cis.QueryParams;
import com.sun.org.apache.xerces.internal.impl.dv.xs.DateTimeDV;


public class CisInformation {
     /**
     * 获取获取水文站基本属性
     * @return 所有水文测站List<T>类型
     * @throws Exception 
     */
     public List < ? extends Object > getWaterStationProperties() throws Exception
    {
        List params = new ArrayList();
        params.add( "ZQ");
        params.add( "ZZ");
        params.add( "RR");
         return getStationProperties(params);
    }

     /**
     * 获取所有余量站的信息
     * @return 返回范式的类型List<? extends Object>
     * @author WMsteve Email:weisteve@yeah.net
     * @throws Exception 
     */
     public List < ? extends Object > getRainStationProperties() throws Exception
    {
        List params = new ArrayList();
        params.add( "PP");
         return getStationProperties(params);
    }

     public List <StStbprpB > getStationList(){
         try{
            ApplicationContext actx = new ClassPathXmlApplicationContext( "applicationContext.xml");
            CommonDao cd =(CommonDao) actx.getBean( "CommonDaoStu");
            String QueryString =getQueryString( "StStbprpB", null, null, null);
            List list =cd.query(QueryString);
             return list;
        } catch(Exception e){
            e.printStackTrace();
        }
         return null;
    }

     /**
     * 
     * @param params List泛型形式的查询条件
     * @return 返回查询结果List<? extends Object>类型
     * @author WMsteve Email:weisteve@yeah.net
     * @throws Exception 
     */
     public static List <StStbprpB > getStationProperties(List < ? extends Object > params) throws Exception
    {
        ApplicationContext actx = new ClassPathXmlApplicationContext( "applicationContext.xml");
        CommonDao cd =(CommonDao) actx.getBean( "CommonDaoStu");
        String QueryString =getQueryString( "StStbprpB", "STTP", params, "OR");
        System.out.println(QueryString);
        List list =cd.query(QueryString,params);
         return list;
    }



     /**
     * 根据查询列，和查询链接符，参数形式，生成HQL
     * 此查询仅支持单表的单列的多条件查询（链接符号单一的情况）
     * etc.比如查询 站表ST_STBPRP_B中列STTP= 'ZQ|ZZ|RR'的所有情况
     * From ST_STBPRP_B where STTP="ZQ" OR STTP="ZZ" OR STTP="RR"
     * @param TableName 表名
     * @param column 列名
     * @param params 检索条件连接符
     * @param joint 检索条件
     * @return 返回组织后的字符串
     * @author WMsteve weisteve@yeah.net 2011年12月11日10:43:22
     * @throws Exception "TableName 不能为空"
     */
     private static String getQueryString(String TableName,String column,List < ? extends Object > params,String joint) throws Exception
    {
         int size = 0;
         if(params !=null){
            size =params.size();
        }
         //joint连接符，如果为空，则默认为or
         if(joint ==null)
        {
            joint = "or";
        }
        StringBuffer sb = new StringBuffer();
         if(TableName !=null){
            sb.append( "From " +TableName);
             if(size > 0)
            {
                sb.append( " where " +column + "=?");
            }
             for( int i = 1;i <size;i ++)
            {
                sb.append( " " +joint + " " +column + "=?");
            }
        } else throw new Exception( "TableName cannot be null!");
         return sb.toString();
    }

     public List <StRiverR > getListByHQL()
    {
         //StRiverR st=new St;
        ApplicationContext actx = new ClassPathXmlApplicationContext( "applicationContext.xml");
        CommonDao cd =(CommonDao) actx.getBean( "CommonDaoStu");
        List reList = cd.query( "From StRiverR striverr where striverr.id.stcd = '81100350'");

         return reList;
    }

     /**
     * 获取河道水文站一段时间数据
     * stcd列表为要查询水文站点的station code集合 该属性设为null查询所有水文站点
     * startdate 为要查询的记录的起始时间 该属性设为null，查询enddate之前一日之内的水文数据
     * enddate 为要查询的记录的起始时间 该属性设为null，查询startdate之后的全部水文数据
     * startdate、enddate都设为null，查询最近一日之内的水文数据
     * @param qp 远程调用参数
     * @return 返回取得的所有基本数据
     * @throws Exception 
     */
     public List <StRiverR > getWaterStationSpaceProperties(QueryParams qp) throws Exception
    {
        StringBuffer sb = new StringBuffer();
        StringBuffer where = new StringBuffer();
        SimpleDateFormat sdf = new SimpleDateFormat( "yyyy/MM/dd hh:mm:ss");
        System.out.println();
        Date sDate =qp.getStartDate();
        Date eDate =qp.getEndDate();
        sb.append( "From StRiverR striverr where ");
         if(qp.getStcd() !=null)
            sb.append( "striverr.id.stcd in ( :ids ) and "); // and striverr.id.tm between :startDateTime and :endDateTime
         if(sDate !=null &&eDate !=null){
            where.append( "striverr.id.tm between :startDateTime and :endDateTime");
        } else if(sDate !=null){
            where.append( "striverr.id.tm > :startDateTime");
        } else if(eDate !=null){
            sDate = new Date(eDate.getDate());
            eDate = new Date();
            eDate.setDate(eDate.getDate() + 1);
            where.append( "striverr.id.tm between :startDateTime and :endDateTime");
        } else{
            sDate = new Date();
            sDate.setDate( new Date().getDate() - 1);
            where.append( "striverr.id.tm > :startDateTime");
        }
        sb.append(where);
        System.out.println(sb);
        System.out.println(qp.getStcd());
        System.out.println(sDate);
        System.out.println(eDate);
         //'81100350','81103150'
        Map <String,Object > map = new HashMap <String,Object >();
         if(qp.getStcd() !=null)map.put( "ids", qp.getStcd());
         if(sDate !=null)map.put( "startDateTime",qp.getStartDate());
         if(eDate !=null)map.put( "endDateTime",qp.getEndDate());
         if(sDate ==null &&eDate ==null)map.put( "startDateTime",qp.getStartDate());
        ApplicationContext actx = new ClassPathXmlApplicationContext( "applicationContext.xml");
        CommonDao cd =(CommonDao) actx.getBean( "CommonDaoStu");
        List list =cd.query(sb.toString(),map);
         return list;
    }

     public List <StRiverR > getRWaterData(QueryParams qp){
        List list =null;
         return list;
    }
}

Eric_Wei
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Spring AOP 动态多数据源的实例详解
01-08
Spring AOP 动态多数据源的实例详解 当项目中使用到读写分离的时候，我们就会遇到多数据源的问题。多数据源让人最头痛的，不是配置多个数据源，而是如何能灵活动态的切换数据源。例如在一个spring和Mybatis的框架的项目中，我们在spring配置中往往是配置一个dataSource来连接数据库，然后绑定给sessionFactory，在dao层代码中再指定sessionFactory来进行数据库操作。   正如上图所示，每一块都是指定绑死的，如果是多个数据源，也只能是下图中那种方式。 可看出在Dao层代码中写死了两个SessionFactory，这样日后如果再多一个数据源，还
hibernate连接kingbase数据库报错，不能反序列化，主要原因是（org.hibernate.type.descriptor.sql.BlobTypeDescriptor）转换失败
水蜜桃桃桃的博客
07-05 809
报错如下(提示的很明显是数据库字段类型为Clob识别失败)： at org.hibernate.internal.util.SerializationHelper.deserialize(SerializationHelper.java:287) at org.hibernate.type.descriptor.java.SerializableTypeDescriptor.fromBytes(SerializableTypeDescriptor.java:138) at org.hibernate
一个java项目怎么连接两个不同的数据库_SpringMVC配置双数据源，一个java项目同时连接两个数据库...
weixin_31200621的博客
02-18 4201
数据源在配置文件中的配置xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"xmlns:cache="http://www.springframework.org/schema/cache"xmlns:context="http://ww...
【SpringBoot 2.3.3.RELEASE】 JPA配置使用多数据源
BIG BOSS的博客
08-31 1018
1.写配置文件，application.yml # 多数据源配置 spring: datasource: ds1: driverClassName: org.postgresql.Driver jdbc-url: jdbc:postgresql://xxxxx:5432/bigdata?currentSchema=public username: xxx password: xxx ds2: driverClassName: o
Hibernate&Spring对多数据源、多Schema的支持
weixin_34199335的博客
12-30 224
Hibernate&amp;Spring对多数据源、多Schema的支持 @author:WMsteve @Email:[email protected] @Time:2011年12月30日17:02:55 @Modify Time:2012年1月1日13:17:35 v1.1 Hibernate是一个开源的对象映射框架。它实现了对JDBC的轻量级封装，使得java开发人员能够使用...
Mybatis-Plus多数据源事务
ooaash的博客
06-08 4727
Mybatis-Plus多数据源
Java数组
jl08133341的博客
09-08 287
1.数组 数组概念：数组是一种容器，可以同时存放多个数据值。 数组特点：1.数组是一种引用数据类型，2.数组中数据的类型必须统一，3.数组的长度在程序运行期间不可改变。 2.数组的初始化 动态初始化（指定长度） 数据类型[] 数组名称 = new 数据类型[数组长度]; 注意：右侧数据类型必须和左边的数据类型保持一致，可以是基本数据类型，也可以是引用数据类型；数组长度是一个int数字，表示可以保存多少数据。 标准化的静态初始化（指定内容） 数据类型[] 数组名称 = new 数据类型[
mybatisplus动态schema配置
lengxia0的博客
04-21 2837
查询测试环境数据库与生产环境数据库时，sql中的schema一致。
mybatis-plus 3.4.2版本注解@TableName中动态schema实现
xie_apple的博客
10-17 2421
因为该版本的表名生成拦截器不符合我们动态表空间动态替换，去获取.properties里配置的属性值。而注解@TableName里有属性schema，可以设置表空间，但是因为是写死，不够灵活，当测试环境和生产环境的表空间不一致，而对应的表结构一致，或者表空间修改时，那么就需要改动大批量的实体类代码，后期维护太过繁琐，增加工作量。项目数据库test_db和app_db使用同一个mysql实例，分不同的库(表模型)，为了降低复杂度，给db_data_link的用户赋予了db_ds数据库的只读权限，可以跨库查询。
基于 SpringBoot 多数据源 动态数据源 主从分离 快速启动器 支持分布式事务
01-05
基于 SpringBoot 多数据源 动态数据源 主从分离 快速启动器 支持分布式事务。一个基于springboot的快速集成多数据源的启动器。支持 数据源分组 ，适用于多种场景 纯粹多库 读写分离 一主多从 混合模式。支持数据库...
schema:支持多个数据源SQL驱动程序框架
05-13
Schema 一款简单支持异构数据源SQL Driver1. 简介schema 项目是一个简单的union-sql工程， 即用一套SQL可以同时访问不同数据源的数据，做到跨数据源JOIN等复杂操作，目前只简单支持以下数据源 File(本地文件&amp;#41...
hibernate注解 级联 多对一 一对多
12-14
hibernate 注解生成表  JPA注解1、@Entity(name="EntityName")必须,name为可选,对应数据库中一的个表2、@Table(name="",catalog="",schema="")可选,通常和@Entity配合使用,只能标注在实体的class定义处,表示实体...
Spring自定义配置Schema可扩展(二)
09-02
主要介绍了Spring自定义配置Schema可扩展(二)的相关资料,需要的朋友可以参考下
spring和hibernate指定DB2数据库schema的方法
回家换拖鞋的专栏
07-09 3555
1.使用hibernate配置文件指定 Xml代码   hibernate-mapping>     class table="TEST_TABLE" name="com.evan.Test" schema="TESTDB">       ...     class>   hibernate-mapping>    2.当数据库中配置文件多的时候就需要在每
SpringBoo使用hibernate连接数据库
岑如花
08-15 1378
SpringBoots使用Hibernate连接数据库。 环境：IDea springBoot版本：2.1.7 Oracle 11g 中间件：tomcat8（使用8以下的版本在运行程序时会出现一些问题） 项目结构,如图： 使用到的jar包列表（要特别注意引用的jar包的版本，博主在整合hibernate时由于引入的jar包版本不合适，出了好多问题。） 配置文件： web.xml <?xm...
Spring，hibernate数据库连接配置
IT人生
12-15 1450
在项目用Spring，hibernate连接数据库时需要配置config.properties。其中包括Oracle，Mysql，sqlserver。 如下：database.driver=oracle.jdbc.driver.OracleDriver #database.driver=com.mysql.jdbc.Driver #database.driver=com.microsoft.sq
SpringBoot兼容人大金仓数据库
weixin_39327352的博客
09-27 3367
2、重写方言的getQuerySequencesString方法，直接返回null，因为通过对比发现mysql的方言并没有重写此方法，所以认为此处返回null，然后不进行元数据提取不会产生影响，经测试能成功建表。根据安装的数据库版本决定需要引入对应的驱动版本和数据库方言，我们安装的是kingbaseESV8版本，所以我们引入8.2.0的驱动，我们是将jar包推到私服上的，所以直接通过依赖引入。默认为null，而KingbaseDialect中有具体返回，所以会执行后续的元数据提取操作。
小白也能用java实现多数据源切换
面朝大海的博客
10-15 9529
最近做个小项目，spring mvc的，有个数据源切换的问题是以前没有遇到的，在网上搜索还是有很多关于这方面的问题，这里我也把我我写的代码贴出来，有写得不好的地方希望在评论区多指教。 上代码： 1.先创建一个jdbc.properties文件用来写多数据源的驱动，密码等信息： # MySQL1 #===============================================...
Java毕业设计-基于SSM框架的大学生社团管理系统带lw(源码+演示视频+说明).rar
最新发布
05-09
Java毕业设计-基于SSM框架的大学生社团管理系统带lw(源码+演示视频+说明).rar 【项目技术】 开发语言：Java 框架：ssm+vue 架构：B/S 数据库：mysql 【演示视频-编号：438】 https://pan.quark.cn/s/b3a97032fae7 【实现功能】 实现了社长管理，社团信息管理，社团分类管理，社团加入信息管理，社团成员登记管理，活动信息管理等功能。
android 支持多个schema
05-31
是的，Android系统支持多个schema。Schema是一种用于标识URI的语法，它定义了URI的格式和允许的参数。Android系统中常用的一些schema包括http、https、file、content等。开发者可以在应用程序中使用这些schema来处理...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值