直接开始
-
下载最新达梦JDBC驱动包到本地,放到工程的/src/lib/目录(推荐)
https://mvnrepository.com/artifact/com.dameng/DmJdbcDriver18/8.1.1.193
-
创建一个springboot工程,添加web支持,pom如下:
<dependencies>
<!-- web支持 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- springboot jdbc支持 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!-- 达梦数据库支持 -->
<dependency>
<groupId>com.dm</groupId>
<artifactId>Dm8JdbcDriver</artifactId>
<version>1.8</version>
<scope>system</scope>
<!-- 建议将下载的jdbc驱动放到自己工程下对应的该目录 -->
<!--jar包下载: https://mvnrepository.com/artifact/com.dameng/DmJdbcDriver18/8.1.1.193-->
<systemPath>${project.basedir}/src/lib/DmJdbcDriver18-8.1.1.193.jar</systemPath>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<configuration>
<!--因为需要将达梦jar包打进项目最终可执行jar,需配置includeSystemScope-->
<includeSystemScope>true</includeSystemScope>
</configuration>
</plugin>
</plugins>
</build>
- 编写application.yaml配置文件,配置jdbc连接地址
# spring相关配置
spring:
datasource:
driver-class-name: dm.jdbc.driver.DmDriver
url: jdbc:dm://192.168.2.189:5236/XX_BASE?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
username: SYSDBA
password: xxxxx
- 编写一个Controller,测试下是否连接正常?
package cn.com.ebidding.dm.controller;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
import java.util.Map;
/**
* @author qinchen
* @date 2021/11/25 18:48
* @description TODO
*/
@RestController
public class TestController {
@Autowired
private JdbcTemplate jdbcTemplate;
@GetMapping("/test/base/user")
public List testBaseUser(){
List<Map<String, Object>> maps = jdbcTemplate.queryForList("select * from EBS_BASE.base_user");
return maps;
}
}
最后补充
-
安装达梦数据库自己网上找下
-
本地客户端安装包和服务安装包在一起,安装时选择只安装客户端即可
-
安装好后,打开管理工具