有时候我们可能在一个项目中使用两个数据库，为了实现使用两个或多个数据库的功能，我们需要在Spring中配置相关信息。
首先是添加配置文件conf.properties
<ol class="dp-c"> <li class="alt"><span><span><bean><span class="string">"propertyConfigurer"</span><span> </span><span class="keyword">class</span><span>=</span><span class="string">"org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"</span><span>> </span></bean></span></span></li> <li><span> <property><span class="string">"locations"</span><span>> </span></property></span></li> <li class="alt"><span> <list> </list></span></li> <li><span> <value>classpath:config.properties</value> </span></li> <li class="alt"><span> </span></li> <li><span> </span></li> <li class="alt"><span> </span></li> </ol>
其次是添加数据源(${...}对应的是conf.properties中的配置信息)
<ol class="dp-c">
<li class="alt"><span><span><!--对应数据A的数据源--> </span></span></li>
<li><span><bean><span class="string">"dataSource_A"</span><span> </span><span class="keyword">class</span><span>=</span><span class="string">"org.apache.commons.dbcp.BasicDataSource"</span><span>> </span></bean></span></li>
<li class="alt"><span> <property><span class="string">"driverClassName"</span><span> value=</span><span class="string">"${A.driver_class}"</span><span> /> </span></property></span></li>
<li><span> <property><span class="string">"url"</span><span> value=</span><span class="string">"${A.url}"</span><span> /> </span></property></span></li>
<li class="alt"><span> <property><span class="string">"username"</span><span> value=</span><span class="string">"${A.username}"</span><span> /> </span></property></span></li>
<li><span> <property><span class="string">"password"</span><span> value=</span><span class="string">"${A.password}"</span><span> /> </span></property></span></li>
<li class="alt"><span> </span></li>
<li><span><!--对应数据库B的数据源--> </span></li>
<li class="alt"><span><bean><span class="string">"dataSource_B"</span><span> </span><span class="keyword">class</span><span>=</span><span class="string">"org.apache.commons.dbcp.BasicDataSource"</span><span>> </span></bean></span></li>
<li><span> <property><span class="string">"driverClassName"</span><span> value=</span><span class="string">"${B.driver_class}"</span><span> /> </span></property></span></li>
<li class="alt"><span> <property><span class="string">"url"</span><span> value=</span><span class="string">"${B.url}"</span><span> /> </span></property></span></li>
<li><span> <property><span class="string">"username"</span><span> value=</span><span class="string">"${B.username}"</span><span> /> </span></property></span></li>
<li class="alt"><span> <property><span class="string">"password"</span><span> value=</span><span class="string">"${B.password}"</span><span> /> </span></property></span></li>
<li><span> </span></li>
</ol>
之后是添加对应的sessionFactory:
<ol class="dp-c"> <li class="alt"><span><span><!-- A的sessionFactory --> </span></span></li> <li><span> <bean><span class="string">"sessionFactory_A"</span><span> </span><span class="keyword">class</span><span>=</span><span class="string">"moretv.commons.spring.hibernate3.AnnotationSessionFactoryBean"</span><span>> </span></bean></span></li> <li class="alt"><span> <property><span class="string">"dataSource"</span><span> ref=</span><span class="string">"dataSource_A"</span><span>/> </span></property></span></li> <li><span> </span></li> <li class="alt"><span><!-- B的sessionFactory --> </span></li> <li><span> <bean><span class="string">"sessionFactory_B"</span><span> </span><span class="keyword">class</span><span>=</span><span class="string">"moretv.commons.spring.hibernate3.AnnotationSessionFactoryBean"</span><span>> </span></bean></span></li> <li class="alt"><span> <property><span class="string">"dataSource"</span><span> ref=</span><span class="string">"dataSource_B"</span><span>/> </span></property></span></li> <li><span> </span></li> </ol>
在项目中的dao层有时会出现这样的配置信息：
<ol class="dp-c"> <li class="alt"><span><span><bean><span class="string">"XDao"</span><span> </span><span class="keyword">class</span><span> = </span><span class="string">"xxx.xxx.xDaoImpl"</span><span>> </span></bean></span></span></li> <li><span><property><span class="string">"sessionFactory"</span><span> ref=</span><span class="string">"sessionFactory"</span><span>></span></property> </span></li> <li class="alt"><span> </span></li> </ol>
为了实现使用两个不同的数据库，可以改成
<ol class="dp-c"> <li class="alt"><span><span><span><span class="string">"font-family:'sans serif', tahoma, verdana, helvetica;font-size:13px;line-height:19px;white-space:normal;background-color:#ffffff;"</span><span>> </span><span><span class="string">"font-family:'sans serif', tahoma, verdana, helvetica;white-space:normal;background-color:#ffffff;"</span><span>><!--使用A数据库的DAO--></span> <bean><span class="string">"XDao"</span><span> </span><span class="keyword">class</span><span> = </span><span class="string">"xxx.xxx.xDaoImpl"</span><span>> </span></bean></span></span></span></span></li> <li><span><property><span class="string">"sessionFactory"</span><span> ref=</span><span class="string">"sessionFactory_A"</span><span>></span></property> </span></li> <li class="alt"><span> </span></li> <li><span><!--使用B数据库的DAO--> </span></li> <li class="alt"><span><bean><span class="string">"XDao"</span><span> </span><span class="keyword">class</span><span> = </span><span class="string">"xxx.xxx.xDaoImpl"</span><span>> </span></bean></span></li> <li><span><property><span class="string">"sessionFactory"</span><span> ref=</span><span class="string">"sessionFactory_B"</span><span>></span></property> </span></li> <li class="alt"><span> </span></li> </ol>
这样就能实现双数据库了。。。。
Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Assassin's Creed Shadows: Seashell Riddle Solution
3 weeks agoByDDD
What's New in Windows 11 KB5054979 & How to Fix Update Issues
2 weeks agoByDDD
Where to find the Crane Control Keycard in Atomfall
3 weeks agoByDDD
Assassin's Creed Shadows - How To Find The Blacksmith And Unlock Weapon And Armour Customisation
1 months agoByDDD
Roblox: Dead Rails - How To Complete Every Challenge
3 weeks agoByDDD
Hot Tools
SublimeText3 Chinese version
Chinese version, very easy to use
mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),
Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.
PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool
Notepad++7.3.1
Easy-to-use and free code editor
