ibatis连接两个数据量

来源：互联网发布：明星日常知乎编辑：程序博客网时间：2024/04/29 03:19

1.基于lkbAdmin项目的多数据库配置实现

创建datasources.xml文件的副本,修改为想要连接的数据库,和修改文件名称

<bean id="umDataSource_admin" class="org.apache.tomcat.jdbc.pool.DataSource">                <property name="driverClassName" value="com.mysql.jdbc.Driver" />                                <property name="url" value="jdbc:mysql://127.0.0.1:3307/com_lkb_admin?useUnicode=true&characterEncoding=utf8" />                <property name="username" value="root" />                <property name="password" value="root" />                <property name="defaultAutoCommit" value="true" />                <!-- READ_COMMITTED -->                <property name="defaultTransactionIsolation" value="2" />                                <!-- sizing the connection pool -->                <property name="initialSize" value="5" />                <property name="minIdle" value="5" />                <property name="maxIdle" value="15" />                <property name="maxActive" value="200" />                <!-- in milliseconds -->                <property name="maxWait" value="10000" />                        <property name="testOnBorrow" value="true" />                <property name="validationQuery" value="/* ping */ select 1" />                <property name="validationInterval" value="30000" />                                <property name="testWhileIdle" value="true" />                <!-- in milliseconds, the sweeper runs every 60 seconds -->                <property name="timeBetweenEvictionRunsMillis" value="60000" />                <!-- in milliseconds, the connection will be closed if the idle time is larger than 5 minutes -->                <property name="minEvictableIdleTimeMillis" value="300000" />        </bean>

注意:bean id跟datasources.xml的bean id 不一样
2.第二步在service.xml 增加datasources_admin.xml 数据源

<import resource="classpath:spring-config/datasources.xml" />                <import resource="classpath:spring-config/datasources_admin.xml" />         <import resource="classpath:spring-config/service-config.xml" />        <import resource="classpath:spring-config/applicationContext-security.xml" />

3.第三步
增加不同映射路径如我新的数据库用该com.lkb.daodb 的dao层

<context:component-scan base-package="com.lkb.daoImp,com.lkb.serviceImp,com.lkb.daodb"/>                <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">                <property name="dataSource" ref="umDataSource" />        </bean>                        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">          <property name="basePackage" value="com.lkb.dao" />             <property name="sqlSessionFactoryBeanName" value="umSessionFactory"></property>         </bean>        <tx:annotation-driven transaction-manager="transactionManager" />        <bean id="umSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">                <property name="mapperLocations">                        <list>                                <value>classpath:sql-mapper/*Mapper.xml</value>                        </list>                </property>                <property name="dataSource" ref="umDataSource" />        </bean>                                         <bean id="transactionManager_admin" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">                <property name="dataSource" ref="umDataSource_admin" />        </bean>                <tx:annotation-driven transaction-manager="transactionManager_admin" />        <bean id="umSessionFactory_admin" class="org.mybatis.spring.SqlSessionFactoryBean">                <property name="mapperLocations">                        <list>                                <value>classpath:sql-mapper-admin/*Mapper.xml</value>                        </list>                </property>                <property name="dataSource" ref="umDataSource_admin" />        </bean>         <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">                  <property name="basePackage" value="com.lkb.daodb" />            <property name="sqlSessionFactoryBeanName" value="umSessionFactory_admin"></property>         </bean>

0 0