一、多数据库环境切换
1、config配置:
<!-- default="mydemo" 指定连接的数据库 -->
<environments default="mydemo">
<!-- mysql连接 -->
<environment id="mydemo">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${db.driver}"/>
<property name="url" value="${db.url}"/>
<property name="username" value="${db.username}"/>
<property name="password" value="${db.password}"/>
</dataSource>
</environment>
<!-- oracle连接 -->
<environment id="mydemo2">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${db.driver2}"/>
<property name="url" value="${db.url2}"/>
<property name="username" value="${db.username2}"/>
<property name="password" value="${db.password2}"/>
</dataSource>
</environment>
</environments>
2、配置数据库支持类
<!-- 配置数据库支持类 -->
<databaseIdProvider type="DB_VENDOR"