1.Oracle
1.1在application中
spring:
application:
name: cloud-export #eureka.instance.hostname:如果两个都设置,则显示spring.application.name
datasource:
driver-class-name: oracle.jdbc.OracleDriver # oracle.jdbc.driver.OracleDriver
type: com.alibaba.druid.pool.DruidDataSource
url: jdbc:oracle:thin:@//10.175.94.95:1521/ORCL5
username: devtest
password: devtest
如果是mybatis的话,还需要配置
mybatis:
mapper-locations: mapper/*.xml,classpath*:mapper/*.xml
type-aliases-package: com.josion.seckill.pojo
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl # 配置于控制臺打印日誌(建議上線后移除,僅開發和測試使用)
1.2在pom中
<!-- 统一管理jar包版本 -->
<properties>
<!-- oracle驱动 -->
<ojdbc7.version>12.1.0.2</ojdbc7.version>
<!-- alibaba druid -->
<druid.version>1.1.12</druid.version>
<mybatis.version>3.5.2</mybatis.version>
<mybatis-spring.version>2.0.2</mybatis-spring.version>
<mybatis-spring-boot-starter.version>2.1.0
</mybatis-spring-boot-starter.version>
</properties>
<dependencyManagement>
<!-- oracle驱动 -->
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc7</artifactId>
<version>${ojdbc7.version}</version>
</dependency>
<!-- alibaba druid -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>${druid.version}</version>
</dependency>
<!-- mybatis and page start -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>${mybatis-spring.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>${mybatis-spring-boot-starter.version}</version>
</dependency>
<!-- mybatis and page start end -->
</dependencyManagement>
2.Mysql
2.1在pom中
<!--导入依赖-->
<dependencies>
<!--mysql驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.46</version>
</dependency>
<!-- 添加JDBC依赖 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<!--mybatis-->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.6</version>
</dependency>
<!-- 引入单元测试依赖 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
2.2在application.yml中
spring:
application:
name: cloud-export #eureka.instance.hostname:如果两个都设置,则显示spring.application.name
datasource:
driver-class-name: com.mysql.jdbc.Driver # 版本超过8的话使用:com.mysql.jdbc.jc.Driver
type: com.alibaba.druid.pool.DruidDataSource
url: jdbc:mysql://localhost:3306/dev1?useUnicode=true&characterEncoding=utf8
username: devtest
password: devtest