driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver jdbcUrl=jdbc:sqlserver://:111111;DatabaseName=XF_System_Data user=11111 password=1111 jdbcUrl2=jdbc:sqlserver://111:6002;DatabaseName=XF_System_Orig_Data user2=1111111 password2=1111111
<!-- c3p0--> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="${driverClass}"/> <property name="jdbcUrl" value="${jdbcUrl}"></property> <property name="user" value="${user}" /> <property name="password" value="${password}"/> </bean> <!-- c3p0--> <bean id="dataSource2" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="${driverClass}"/> <property name="jdbcUrl" value="${jdbcUrl2}"></property> <property name="user" value="${user2}" /> <property name="password" value="${password2}"/> </bean>
<!-- 创建Mybatis SessionFactory --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="configLocation" value="classpath:mybatis-config.xml"/> </bean> <!-- 配置Mybatis扫描 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="xfhm.core.dao"/> <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property> </bean> <!-- 创建Mybatis SessionFactory --> <bean id="sqlSessionFactory2" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource2" /> <property name="configLocation" value="classpath:mybatis-config.xml"/> </bean> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="xfhm.core.daos.picdate" /> <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory2"></property> </bean>
