springboot项目配置hibernate连接数据库（MySQL，oracle，达梦数据库）

我就是我 2024-03-17 11:08 51阅读 0赞

### 1、添加hibernate依赖坐标 ###

<dependency>
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>

### 2、连接MySQL ###

#### 2.1、MySQL的依赖坐标 ####

<dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.34</version>
    </dependency>

#### 2.2、MySQL的配置 ####

# jpa配置
    spring.jpa.database=MYSQL
    spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
    # MySQL数据源
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    spring.datasource.url=jdbc:mysql://127.0.0.1:3306/mydbname?useSSL=false
    spring.datasource.username=root
    spring.datasource.password=root

### 3、连接oracle ###

#### 3.1、引入oracle依赖坐标 ####

<dependency>
        <groupId>com.oracle</groupId>
        <artifactId>ojdbc7</artifactId>
        <version>12.1.0.2.0</version>
    </dependency>

#### 3.2、oracle的配置 ####

# jpa的配置
    spring.jpa.database = oracle
    spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.Oracle10gDialect
    # oracle的配置
    spring.datasource.driverClassName=oracle.jdbc.driver.OracleDriver
    spring.datasource.url=jdbc:oracle:thin:@127.0.0.1:1521:xe
    spring.datasource.username=root
    spring.datasource.password=root

### 4、连接达梦数据库 ###

#### 4.1、达梦数据库的依赖坐标 ####

<dependency>
    	<groupId>dm</groupId>
    	<artifactId>dm.jdbc.driver</artifactId>
    	<version>18.0.0-SNAPSHOT</version>
    </dependency>
    <dependency>
    	<groupId>dm</groupId>
    	<artifactId>org.hibernate.dialect.DMDialect</artifactId>
    	<version>4.0.0-SNAPSHOT</version>
    </dependency>

#### 4.2、达梦数据库的配置 ####

# jpa的配置
    spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.DmDialect
    # oracle的配置
    spring.datasource.driverClassName=dm.jdbc.driver.DmDriver
    spring.datasource.url=jdbc:dm://localhost:5236/STUDY?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
    spring.datasource.username=STUDY
    spring.datasource.password=STUDY123456

达梦的具体查看官网的配置：[https://eco.dameng.com/document/dm/zh-cn/start/java-development.html][https_eco.dameng.com_document_dm_zh-cn_start_java-development.html]

结束！！！！  
hy:1

--------------------

不被嘲笑的梦想，是不值得去实现的。---罗翔老师

[https_eco.dameng.com_document_dm_zh-cn_start_java-development.html]: https://eco.dameng.com/document/dm/zh-cn/start/java-development.html