快捷導(dǎo)航

SpringBoot工程中測(cè)試連接DaMeng數(shù)據(jù)庫實(shí)踐

更新時(shí)間：2026年01月23日 09:43:36 作者：裊沫

本文介紹了如何在SpringBoot工程中配置達(dá)夢(mèng)數(shù)據(jù)庫,并通過添加相關(guān)依賴和編寫測(cè)試代碼進(jìn)行連接測(cè)試,最終成功實(shí)現(xiàn)數(shù)據(jù)庫連接

一、環(huán)境準(zhǔn)備與依賴配置

SpringBoot工程：

達(dá)夢(mèng)數(shù)據(jù)庫

二、數(shù)據(jù)庫配置信息

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    druid:
      primary:
        driver-class-name: dm.jdbc.driver.DmDriver
        url: jdbc:dm://xxxxx.5:5236/sacoa_business
        username: SYSDBA
        password: SYSDBA
      second:
        url: jdbc:mysql://xxxxx:3306/testdb?characterEncoding=UTF-8&useUnicode=true&serverTimezone=GMT%2B8
        driver-class-name: com.mysql.cj.jdbc.Driver
        username: root
        password: chen
      third:
        url: jdbc:dm://xxxxx:5236/sacoa_platform
        username: SYSDBA
        password: SYSDBA
        driver-class-name: dm.jdbc.driver.DmDriver
      #初始連接數(shù)量
      initial-size: 20
      #最小連接數(shù)量
      min-idle: 20
      #最大連接數(shù)量
      max-active: 1000
      #獲取連接等待超時(shí)的時(shí)間 單位是毫秒,這里配置60秒
      max-wait: 30000

三、添加相關(guān)依賴

如果是微服務(wù)結(jié)構(gòu)，首先在項(xiàng)目的pom.xml文件中添加相關(guān)依賴

      <!--達(dá)夢(mèng)-->
      <dependency>
        <groupId>com.dameng</groupId>
        <artifactId>DmJdbcDriver18</artifactId>
        <version>8.1.3.140</version>
      </dependency>

其次在使用連接數(shù)據(jù)庫的模塊中，再次引入依賴！

如果是SpringBoot項(xiàng)目只需要引入一次即可

四、controller測(cè)試

@RequestMapping(HttpConstants.REST_URL_PREFIX+"/test")
@Api(value = "TestController", tags = "測(cè)試")
@RestController
public class TestController {

    @Resource
    private RedisUtil redisUtil;
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @ApiOperation(value = "測(cè)試dataSource" , httpMethod = "GET")
    @GetMapping("/testConnection")
    public String testDatabaseConnection() {
        List<String> result = jdbcTemplate.queryForList("SELECT 'Connected to DM database successfully!' FROM dual", String.class);
        return result.isEmpty() ? "Connection failed." : result.get(0);
    }


    @ApiOperation(value = "測(cè)試" , httpMethod = "GET")
    @GetMapping("{name}")
    public ResponseEntity<String> test(@PathVariable("name")String name) {
        return ResponseEntity.ok("hello + " + name);
    }

    @ApiOperation(value = "測(cè)試Redis" , httpMethod = "GET")
    @GetMapping("/redis/{name}")
    public ResponseEntity<String> testRedis(@PathVariable("name") String name) {
        redisUtil.set(name, "Redis: " + name);
        Object nameObj = redisUtil.get(name);
        return ResponseEntity.ok("hello + " + nameObj);
    }

}