mybatis如何配置使用多个数据源?
出自http://zhangbo-peipei-163-com.iteye.com/blog/2052924
- hd.jdbc.driverClassName=com.mysql.jdbc.Driver
- hd.jdbc.url=jdbc:mysql://127.0.0.1::3306/hd?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true
- hd.jdbc.username=root
- hd.jdbc.password=root
- ho.jdbc.driverClassName=com.mysql.jdbc.Driver
- ho.jdbc.url=jdbc:mysql://127.0.0.1:3306/ho?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true
- ho.jdbc.username=root
- ho.jdbc.password=root
二、mybatis配置文件,配置两个environment:
- <?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
- "http://mybatis.org/dtd/mybatis-3-config.dtd">
- <configuration>
- <properties resource="mybatis/jdbc.properties"/>
- <environments default="HO">
- <environment id="HD">
- <transactionManager type="JDBC" />
- <dataSource type="POOLED">
- <property name="driver" value="${hd.jdbc.driverClassName}" />
- <property name="url" value="${hd.jdbc.url}" />
- <property name="username" value="${hd.jdbc.username}" />
- <property name="password" value="${hd.jdbc.password}" />
- </dataSource>
- </environment>
- <environment id="HO">
- <transactionManager type="JDBC" />
- <dataSource type="POOLED">
- <