DM8整合java的jpa框架（附整合源码）

整合完毕后的地址：https://gitee.com/gy297879328/dm_jpa_demo/tree/master
项目结构

CREATE TABLE "T_USER"
(
"ID" INT IDENTITY(1, 1) NOT NULL,
"USERNAME" VARCHAr(50),
"PHONE" VARCHAr(50),
UNIQUE("ID"));


-- oracle
create sequence user_seq
    increment by 1    -- 每次递增1
    start with 1       -- 从1开始
    nomaxvalue      -- 没有最大值
    minvalue 1       -- 最小值=1
    NOCYCLE;      -- 不循环
    
 CREATE TRIGGER user_seq
       BEFORE INSERT ON T_USER
       FOR EACH ROW
       WHEN (new.id IS Null)
BEGIN
       SELECt user_seq.nextval INTO:new.id FROM sys.dual;
END;

数据库驱动在达梦数据库的安装目录driversjdbc
hibernate框架所需的方言包在dialect目录。对应关系可以看同目录下的readme.txt文件。

在项目中我把数据库的驱动包以及方言包放到了lib目录下单独加载了，所以pom文件中没有。

    

        
            org.springframework.boot
            spring-boot-starter-web
        
        
            org.springframework.boot
            spring-boot-starter-data-jpa
        

        
            org.hibernate
            hibernate-core
            5.4.22.Final
        


        
            org.projectlombok
            lombok
            true
        
        
            org.springframework.boot
            spring-boot-starter-test
            test
        
    

server:
  port: 8080
spring:
  datasource:
    driver-class-name: dm.jdbc.driver.DmDriver
    url: jdbc:dm://127.0.0.1:5236
    username: SYSDBA
    password: SYSDBA
  # jpa相关配置
  jpa:
    show-sql: true
    hibernate:
      ddl-auto: update
      naming:
        physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
    open-in-view: false
    properties:
      hibernate:
        dialect: org.hibernate.dialect.DmDialect

@Data
@Builder
@NoArgsConstructor
@AllArgsConstructor
@Entity(name = "T_USER")
public class User {
    
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer ID;
    
    @Column(name = "USERNAME")
    private String username;
    @Column(name = "PHONE")
    private String phone;
}

import com.dameng.jpa_dm.mode.User;
import org.springframework.data.jpa.repository.JpaRepository;


public interface UserRepository extends JpaRepository {
}

@RestController
public class UserController {

    @Autowired
    private UserRepository userRepository;

    @GetMapping("/user")
    public List findAll() {
        userRepository.save(User.builder().username("xiaoqiang").phone("120").build());
        return userRepository.findAll();
    }
}