关于spring多数据配置-个人向

最新推荐文章于 2024-05-30 11:05:32 发布

icmLz_765674832

最新推荐文章于 2024-05-30 11:05:32 发布

阅读量243

点赞数 2

分类专栏： spring 文章标签： spring 多数据源多事务

本文链接：https://blog.csdn.net/icmLz_765674832/article/details/53321956

版权

spring 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

个人看的，仅仅贴出配置文件

applicationContext

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd 
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">

    <context:annotation-config />
    
	<!-- 配置文件信息读取 -->
	<bean id="propertyConfigurer"
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="locations">
			<list>
			    <value>classpath:jdbc.properties</value>
			</list>
		</property>
	</bean>
	
	<!-- 数据源1定义 -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<property name="driverClassName" value="${jdbc.driverClassName}" />
		<property name="url" value="${jdbc.url}" />
		<property name="username" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
		<property name="maxActive" value="${jdbc.maxactive}" />
		<property name="removeAbandonedTimeout" value="${jdbc.removeAbandonedTimeout}" />
		<property name="logAbandoned" value="${jdbc.logAbandoned}" />
	</bean>

	<!-- 数据源2定义 -->
	<bean id="sqldataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<property name="driverClassName" value="${jdbc.driverClassName}" />
		<property name="url" value="${sql.url}" />
		<property name="username" value="${sql.username}" />
		<property name="password" value="${sql.password}" />
		<property name="maxActive" value="${jdbc.maxactive}" />
		<property name="removeAbandonedTimeout" value="${jdbc.removeAbandonedTimeout}" />
		<property name="logAbandoned" value="${jdbc.logAbandoned}" />
	</bean>
	
	<!-- 事务管理器1定义 -->
	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource" />
	</bean>
	<!-- 一个包括以上的事务管理器都需要有一个id名为transactionManager -->
	<!-- 事务管理器2定义 -->
	<bean id="sqltransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="sqldataSource" />
	</bean>
	<!-- spring-mybatis 关联 -->
	<!-- 数据源管理类1的定义 -->
	<!-- 关于多数据源时针对各个mapper所调用的数据源进行管理 -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean" scope="singleton">
		<property name="configLocation" value="classpath:mybatis/mapperConfig.xml"></property>
		<!-- 针对配置文件名称进行设置 -->
		<property name="mapperLocations" value="classpath:mybatis/sql/as*Mapper.xml"></property>
		<property name="dataSource" ref="dataSource"></property>
	</bean>
	<!-- 数据源管理2类的定义 -->
	<bean id="jdbcSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean" scope="singleton">
		<property name="configLocation" value="classpath:mybatis/mapperConfig.xml"></property>
		<property name="mapperLocations" value="classpath:mybatis/sql/bs*Mapper.xml"></property>
		<property name="dataSource" ref="sqldataSource"></property>
	</bean>
	
	<!-- <context:component-scan base-package="com.wenyu.weixiangxue.api.action" /> -->
	<!-- 导入 -->
	<import resource="applicationContextDAOBean.xml" />
	
</beans>

applicationContextDAOBean

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd 
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">
	
	<!-- 参考 -->
	<bean id="AitsAgencyDAO" class="org.mybatis.spring.mapper.MapperFactoryBean" scope="singleton">
		<property name="mapperInterface" value="com.aits.db.dao.AitsAgencyMapper"></property>
		<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
	</bean>
	
	<bean id="AitsComplaintDAO" class="org.mybatis.spring.mapper.MapperFactoryBean" scope="singleton">
		<property name="mapperInterface" value="com.aits.db.dao.AitsComplaintMapper"></property>
		<property name="sqlSessionFactory" ref="jdbcSessionFactory"></property>
	</bean>

</beans>