连接数据库配置驱动_数据库连接驱动-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_53088095/article/details/126161229

本文详细介绍了如何在Spring Boot应用中集成Oracle和MySQL数据库，包括DataSource配置、pom.xml中依赖的管理，以及application.yml中的相关设置。重点涵盖了Oracle的ojdbc7驱动和Druid连接池，以及Mysql的mysql-connector和mybatis的配置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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