數(shù)據(jù)源添加mysql和oracle
代碼見具體github：https://github.com/JNUpython/springboot2/tree/develop

ojdbc依賴無(wú)法下載

github上面下載該jar 并通過maven命令本地安裝

mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc7 -Dversion=12.1.0.2 -Dpackaging=jar -Dfile=./libs/ojdbc7-12.1.0.2.jar 

mybatis 全局配置xml文件，以及數(shù)據(jù)庫(kù)配置文件

image.png

mybatis-mysql.xml

<?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>
    <!-- 添加公共變量信息：方法1   -->
    <properties resource="application-dev.properties"></properties>
    <!--   自定義一些變量-->
    <!--    <properties>-->
    <!--        <property name="url" value="jdbc:mysql://127.0.0.1:3306/test?serverTimezone=CTT&amp;useUnicode=true&amp;characterEncoding=utf-8&amp;allowMultiQueries=true"/>-->
    <!--        <property name="driver" value="com.mysql.jdbc.Driver"/>-->
    <!--        <property name="username" value="root"/>-->
    <!--        <property name="password" value="123456"/>-->
    <!--    </properties>-->

    <settings>
        <!--   設(shè)置數(shù)庫(kù)每個(gè)設(shè)置項(xiàng)     -->
        <!--   全局地開啟或關(guān)閉配置文件中的所有映射器已經(jīng)配置的任何緩存账月。     -->
        <setting name="cacheEnabled" value="true"/>
    </settings>

    <!--  default 選定不同環(huán)境  -->
    <environments default="oracle">

        <environment id="mysql">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${database.driverName2}"/>
                <property name="url" value="${database.url1}"/>
                <property name="username" value="${database.username1}"/>
                <property name="password" value="${database.password1}"/>
            </dataSource>
        </environment>

        <environment id="oracle">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${database.driverName2}"/>
                <property name="url" value="${database.url2}"/>
                <property name="username" value="${database.username2}"/>
                <property name="password" value="${database.password2}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="mybatis/EmployeeMapper.xml"/>
        <mapper resource="mybatis/EmployeeMapperInterface"/>
    </mappers>
</configuration>

application-dev.properties

# 開發(fā)環(huán)境配置文件

# 程序中會(huì)用到的一些自定義變量
com.didispace.blog.name=學(xué)習(xí)spring
com.didispace.blog.title=進(jìn)階
com.dispspace.blog.randomString=${random.value}
com.dispspace.blog.root=${com.didispace.blog.title}-${com.didispace.blog.title}


# mysql test 數(shù)據(jù)庫(kù)
database.url1=jdbc:mysql://127.0.0.1:3306/test?serverTimezone=CTT&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true
database.username1=root
database.password1=123456
database.driverName1=com.mysql.cj.jdbc.Driver

# oracle 數(shù)據(jù)庫(kù)
database.url2=jdbc:oracle:thin:@127.0.0.1:1521:orcl
database.username2=c##kean
database.password2=123456
database.driverName2=oracle.jdbc.driver.OracleDriver

執(zhí)行結(jié)果

22:11:16.601 [main] DEBUG org.apache.ibatis.logging.LogFactory - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
22:11:16.811 [main] DEBUG org.apache.ibatis.datasource.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
22:11:16.812 [main] DEBUG org.apache.ibatis.datasource.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
22:11:16.812 [main] DEBUG org.apache.ibatis.datasource.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
22:11:16.812 [main] DEBUG org.apache.ibatis.datasource.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
22:11:16.916 [main] INFO com.mybatis.MybatisTest - Mapper class: class com.sun.proxy.$Proxy6
22:11:16.928 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Opening JDBC Connection
22:11:19.052 [main] DEBUG org.apache.ibatis.datasource.pooled.PooledDataSource - Created connection 927327686.
22:11:19.052 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection [oracle.jdbc.driver.T4CConnection@3745e5c6]
22:11:19.054 [main] DEBUG com.mybatis.dao.EmployeeMapper.getEmpById - ==>  Preparing: select * from tbl_employee where id = ? 
22:11:19.184 [main] DEBUG com.mybatis.dao.EmployeeMapper.getEmpById - ==> Parameters: 101(Integer)
22:11:19.277 [main] DEBUG com.mybatis.dao.EmployeeMapper.getEmpById - <==      Total: 1
22:11:19.278 [main] INFO com.mybatis.MybatisTest - 101 jack man
22:11:19.278 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection [oracle.jdbc.driver.T4CConnection@3745e5c6]
22:11:19.279 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Closing JDBC Connection [oracle.jdbc.driver.T4CConnection@3745e5c6]
22:11:19.279 [main] DEBUG org.apache.ibatis.datasource.pooled.PooledDataSource - Returned connection 927327686 to pool.
22:11:19.279 [main] INFO com.mybatis.MybatisTest - 查詢完成!