关于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=utf8spring.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.OracleDriverspring.datasource.url=jdbc:oracle:thin:@IP地址spring.datasource.username=账号spring.datasource.password=明码