springboot使用国产数据库达梦项目搭建

本项目源码：这里查看

1.准备工作：

1.1 达梦数据库下载并正确安装

1.2 在SYSDBA下创建表TESTTABLE并添加两条数据。如图

2.springboot项目搭建开始，先浏览下项目目录：

2.1 创建maven项目 项目名称这里为bootdmtest

2.2 pom文件内容

<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.budi.bootDM</groupId> <artifactId>bootdmtest</artifactId> <version>1.0-SNAPSHOT</version> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> <version>2.1.9.RELEASE</version> </dependency> <!--dm data--> <dependency> <groupId>com.dm</groupId> <artifactId>jdbc</artifactId> <scope>system</scope> <systemPath>${project.basedir}/src/main/resources/lib/DmJdbcDriver18.jar</systemPath> </dependency> <dependency> <groupId>com.dm</groupId> <artifactId>hibernate5</artifactId> <scope>system</scope> <systemPath>${project.basedir}/src/main/resources/lib/DmDialect-for-hibernate5.3.jar</systemPath> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> <version>2.1.6.RELEASE</version> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>1.16.18</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> <configuration> <fork>true</fork> <addResources>true</addResources> </configuration> </plugin> </plugins> </build> </project>

 

pom文件里面的两个jar包（达梦数据库驱动包和hibernate方言包）在达梦数据库安装包中找到

2.3yaml文件内容

server:
  port: 9001
spring:
  datasource:
    url: jdbc:dm://127.0.0.1:5236
    username: SYSDBA
    password: SYSDBA
    driver-class-name: dm.jdbc.driver.DmDriver
  jpa:
    properties:
      hibernate:
        dialect: org.hibernate.dialect.DmDialect
    show-sql: true

2.4 创建与表对应的实体类TestTable

package com.budi.boot.domain;

import lombok.Data;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import java.math.BigDecimal;

@Data
@Entity
@Table(name = "TESTTABLE")
public class TestTable {
    @Id
    @Column(name = "ID")
    private Integer id;
    @Column(name = "NAME")
    private String name;
    @Column(name="SCOPE")
    private BigDecimal scope;
}

2.5 创建接口 TestTableRepository 并继承 JpaRepository

package com.budi.boot.repository;

import com.budi.boot.domain.TestTable;
import org.springframework.data.jpa.repository.JpaRepository;

public interface TestTableRepository extends JpaRepository<TestTable,Integer> {
}

2.6 创建TestTableService及其实现类TestTableServiceImpl

package com.budi.boot.service;

import com.budi.boot.domain.TestTable;

import java.util.List;

public interface TestTableService {
    List<TestTable> getAllData();
    TestTable getTestTableById(Integer id);
}

package com.budi.boot.service.impl;

import com.budi.boot.domain.TestTable;
import com.budi.boot.repository.TestTableRepository;
import com.budi.boot.service.TestTableService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;
@Service
public class TestTableServiceImpl implements TestTableService {
    @Resource
    private TestTableRepository repository;
    public List<TestTable> getAllData() {
        return repository.findAll();
    }

    public TestTable getTestTableById(Integer id) {
        TestTable table = repository.findById(id).get();
        return table;
    }
}

2.7 创建controller类 DMController

package com.budi.boot.controller;

import com.budi.boot.domain.TestTable;
import com.budi.boot.service.TestTableService;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.util.List;

@RestController
public class DMController {
    @Resource
    private TestTableService service;
    @RequestMapping("/testA")
    @ResponseBody
    public String testA(){
        return "testA";
    }

    @GetMapping("/getAll")
    public List<TestTable> getAll(){
       return service.getAllData();
    }

    @GetMapping(value = "/getById/{id}")
    public TestTable getTestTableById(@PathVariable("id")Integer id){
        return service.getTestTableById(id);
    }
}

2.8 最后一步，主启动类 DmMain

package com.budi.boot;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class DmMain {
    public static void main(String[] args) {
        SpringApplication.run(DmMain.class,args);
    }
}

3 测试

启动主启动类

3.1 访问http://localhost:9001/getAll

3.2 访问http://localhost:9001/getById/1

测试成功,连接达梦数据库成功。

ps自我督促：关于项目中hibernate和jpa的知识，需要有待提高。