定制网站系统开发,苏州网站建站,WordPress社团展示,wap网站制作视频教程文章目录 前言依赖配置对应的domain类和repository 前言
最近有一个新项目#xff0c;由于信息安全等要求只能使用达梦数据库#xff08;dm8#xff09;#xff0c;之前从来没用过#xff0c;特此开一个笔记记录一下spring bootjpa如何使用达梦数据库完成开发。
依赖
p… 文章目录 前言依赖配置对应的domain类和repository 前言
最近有一个新项目由于信息安全等要求只能使用达梦数据库dm8之前从来没用过特此开一个笔记记录一下spring bootjpa如何使用达梦数据库完成开发。
依赖
pom文件需要 !-- https://mvnrepository.com/artifact/com.dameng/Dm8JdbcDriver18 --dependencygroupIdcom.dameng/groupIdartifactIdDm8JdbcDriver18/artifactIdversion8.1.1.49/version/dependencydependencygroupIdcom.dameng/groupIdartifactIdDmDialect-for-hibernate5.3/artifactIdversion8.1.1.49/version/dependency配置
spring:devtools:restart:enabled: falsedatasource:type: com.alibaba.druid.pool.DruidDataSourcedriver-class-name: dm.jdbc.driver.DmDriverurl: jdbc:dm://${DM_HOST}:${DM_PORT}/${DM_DATABASE}username: ${DM_USERNAME}password: ${DM_PASSWORD}druid:initial-size: 5min-idle: 20maxActive: 100maxWait: 60000timeBetweenEvictionRunsMillis: 60000minEvictableIdleTimeMillis: 300000validationQuery: SELECT 1testWhileIdle: truetestOnBorrow: truetestOnReturn: falsepoolPreparedStatements: truemaxPoolPreparedStatementPerConnectionSize: 10filters: stat,slf4jweb-stat-filter:enabled: falsejpa:database-platform: org.hibernate.dialect.DmDialectshow-sql: trueopen-in-view: falsehibernate:default_schema: suosddl-auto: noneproperties:javax:persistence:sharedCache:mode: ENABLE_SELECTIVEhibernate:default_schema: ${DM_DATABASE}use_jdbc_metadata_defaults: falseenable_lazy_load_no_trans: trueformat_sql: trueconnection:provider_disables_autocommit: falsegenerate_statistics: falseid:new_generator_mappings: truejdbc:batch_size: 25order_inserts: trueorder_updates: truequery:fail_on_pagination_over_collection_fetch: truein_clause_parameter_padding: trueshow_sql: truedialect: org.hibernate.dialect.DmDialect对应的domain类和repository
domain
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;
import lombok.experimental.SuperBuilder;
import org.springframework.data.jpa.domain.support.AuditingEntityListener;import javax.persistence.Entity;
import javax.persistence.EntityListeners;
import javax.persistence.Table;NoArgsConstructor
SuperBuilder
Getter
Setter
Entity
EntityListeners(AuditingEntityListener.class)
Table(schema SUOS)
public class Class extends AbstractModel{Schema(description 校区id)private Integer campusId;Schema(description 校区名称)private String campusName;Schema(description 专业id)private Integer majorId;Schema(description 专业代码)private String majorCode;Schema(description 专业名称)private String majorName;Schema(description 方向)private String field;Schema(description 界别)private String grade;Schema(description 班级名称)private String name;Schema(description 班号)private String number;
}注意这个schema最好是带上不然可能会给你写到默认database里去 repository
import com.timerchina.suos.domain.Class;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;public interface ClassRepository extends JpaRepositoryClass, Integer, JpaSpecificationExecutorClass {}
