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