关于springboot:Mybatis与SQL连接配置

MySQL

MySQL依赖

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.2</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

application.properties配置

spring.datasource.url=jdbc:mysql://IP地址/数据库?serverTimeZone=GMT%2B8&Character=utf8
spring.datasource.username=账号
spring.datasource.password=明码

mybatis.mapper-locations=classpath:/mapper/*.xml

Oracle

Oracle依赖

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.2</version>
        </dependency>

        <dependency>
            <groupId>com.oracle.database.jdbc</groupId>
            <artifactId>ojdbc8</artifactId>
            <version>12.2.0.1</version>
        </dependency>

application.peoperties

spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.url=jdbc:oracle:thin:@IP地址
spring.datasource.username=账号
spring.datasource.password=明码