Sprinboot+Hibernate+DM8(达梦8)整合实例

1. 创建数据库

CREATE TABLE "SYSDBA"."ADDRESS"(ADDRESSID INT NOT NULL PRIMARY KEY,ADDRESS VARCHAR(60) NOT NULL,CITY VARCHAR(30));

INSERT INTO "SYSDBA"."ADDRESS"(ID,ADDRESS,CITY) VALUES(1,'sihui','beijing');
INSERT INTO "SYSDBA"."ADDRESS"(ID,ADDRESS,CITY) VALUES(2,'chayangqu','beijing');
INSERT INTO "SYSDBA"."ADDRESS"(ID,ADDRESS,CITY) VALUES(3,'guomao','beijing');

select * from "SYSDBA"."ADDRESS";

drop table  "SYSDBA"."ADDRESS";

遇到的坑：在insert之后需要 commit，否则查询不出来数据

2. 添加依赖

2.1 项目目录结构

2.2 添加依赖

DmJdbcDriver18.jar （…\安装目录\drivers\jdbc）、DmDialect-for-hibernate5.3.jar（…\安装目录\drivers\jdbc\dialect）

pom.xml

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.1.9.RELEASE</version>
</parent>
<groupId>com.java</groupId>
<artifactId>TestDM</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>war</packaging>
<name>components</name