Postgresql+Springboot yml基本使用

一、Postgresql介绍

PostgreSQL是一种特性非常齐全的自由软件的对象-关系型数据库管理系统(ORDBMS),是以加州大学计算机系开发的POSTGRES,4.2版本为基础的对象关系型数据库管理系统。POSTGRES的许多领先概念只是在比较迟的时候才出现在商业网站数据库中。PostgreSQL支持大部分的SQL标准并且提供了很多其他现代特性,如复杂查询、外键、触发器、视图、事务完整性、多版本并发控制等。同样,PostgreSQL也可以用许多方法扩展,例如通过增加新的数据类型、函数、操作符、聚集函数、索引方法、过程语言等。另外,因为许可证的灵活,任何人都可以以任何目的免费使用、修改和分发PostgreSQL。

1.、 PostgostreSQL 稳定性很强,在崩溃等场景下抗打击能力特别强,对比mysql在电脑崩溃等情景下的丢失数据情况,PG数据库这方面要好一些。

2.、对比Mysql,PostgostreSQL支持的数据类型更多

3.、PostgostreSQL可以使用sql进行编程

4.、PG 的有多种集群架构可以选择,plproxy 可以支持语句级的镜像或分片,slony 可以进行字段级的同步设置,standby 可以构建WAL文件级或流式的读写分离集群,同步频率和集群策略调整方便,操作非常简单。

5.、PostgreSQL的可以使用函数和条件索引

6.、PG 的 TEXT 类型可以直接访问,SQL语法内置正则表达式,能够索引,还可以全文检索。用PG的话,文档数据库都可以省了。

7.、 PostgreSQL的性能很强,在高并发读写的场景下,PostgreSQL的性能指标依旧可以维持顶峰,相对比 MySQL 在同样的场景下会出现一个明显的下滑(mysql5.5之后,在企业级版本中有个插件可以改善很多,不过需要付费)。

二、Postgresql+Springboot yml基本使用

1.导入Maven

        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <scope>runtime</scope>
        </dependency>

2.编写yml配置文件

spring:
  datasource:

    url: jdbc:postgresql://localhost:5432/postgres #    url: jdbc:mysql://localhost:3306/tis?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=false
    username: postgres
    password: 123456
    driverClassName: org.postgresql.Driver
  jackson:
    time-zone: GMT+8
  jpa:
    properties:
      open-in-view: true
      hibernate:
        show_sql: false
        format_sql: true
        dialect: org.hibernate.dialect.PostgreSQLDialect
        temp:
          use_jdbc_metadata_defaults: false
        hbm2ddl:
          auto: update
    database: postgresql

  rabbitmq:
    host: 192.168.90.205
    port: 5672
    username: admin
    password: admin
    virtual-host: /

3.编写Entity实体类

package com.supcon.oms.entity;

import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import lombok.Data;

import javax.persistence.*;
import java.io.Serializable;

/**
 * @author: zhaoxu
 * @date: 2020/9/8 20:43
 */
@Data
@Entity
@Table(name = "t_tank", schema = "public", catalog = "")
@JsonIgnoreProperties(ignoreUnknown = true)
public class TTankEntity implements Serializable {
    private static final long serialVersionUID = 4718371560086576837L;
    @Id
    @Column(name="tank_id")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer tankId;
    @Basic
    @Column(name = "tank_no", nullable = false, length = 255)
    private String tankNo;

    @Basic
    @Column(name = "equipment_type", nullable = true, length = 255)
    private String equipmentType;
    @Basic
    @Column(name = "tank_name", nullable = true, length = 255)
    private String tankName;
    @Basic
    @Column(name = "tank_description", nullable = true, length = 1000)
    private String tankDescription;
    @Basic
    @Column(name = "equipment_status", nullable = true, length = 255)
    private String equipmentStatus;
    @Basic
    @Column(name = "tank_keepwarm", nullable = true, length = 100)
    private String tankKeepwarm;
    @Basic
    @Column(name = "tank_status", nullable = true, length = 255)
    private String tankStatus;
    @Basic
    @Column(name = "tank_farmid", nullable = true, length = 255)
    private String tankFarmid;
    @Basic
    @Column(name = "tank_type", nullable = true, length = 255)
    private String tankType;
    @Basic
    @Column(name = "tank_diameter", nullable = true, precision = 0)
    private Double tankDiameter;
    @Basic
    @Column(name = "tank_height", nullable = true, precision = 0)
    private Double tankHeight;
    @Basic
    @Column(name = "tank_capacity_standard", nullable = true, precision = 0)
    private Double tankCapacityStandard;
    @Basic
    @Column(name = "liquid_level_temperature", nullable = true, precision = 0)
    private Double liquidLevelTemperature;
    @Basic
    @Column(name = "tank_capacity_safe", nullable = true, precision = 0)
    private Double tankCapacitySafe;
    @Basic
    @Column(name = "calculate_type", nullable = true, length = 255)
    private String calculateType;
    @Basic
    @Column(name = "working_level_min", nullable = true, precision = 0)
    private Double workingLevelMin;
    @Basic
    @Column(name = "working_level_max", nullable = true, precision = 0)
    private Double workingLevelMax;    @Basic
    @Column(name = "nominal_volume", nullable = true, precision = 0)
    private Double nominalVolume;
    @Basic
    @Column(name = "thermal_expansion_system", nullable = true, length = 255)
    private String thermalExpansionSystem;
    @Basic
    @Column(name = "floating_point_quality", nullable = true, length = 255)
    private String floatingPointQuality;
    @Basic
    @Column(name = "level_change_dead", nullable = true, length = 100)
    private String levelChangeDead;
    @Basic
    @Column(name = "alarm_events", nullable = true, length = 255)
    private String alarmEvents;
    @Basic
    @Column(name = "tank_capacity_now", nullable = true, precision = 0)
    private Double tankCapacityNow;
    @Basic
    @Column(name = "tank_quality", nullable = true, precision = 0)
    private Double tankQuality;
    @Basic
    @Column(name = "tank_temperature", nullable = true, precision = 0)
    private Double tankTemperature;
    @Basic
    @Column(name = "tank_pressure", nullable = true, precision = 0)
    private Double tankPressure;
    @Basic
    @Column(name = "flow_speed", nullable = true, precision = 0)
    private Double flowSpeed;
    @Basic
    @Column(name = "flow_amount", nullable = true, precision = 0)
    private Double flowAmount;
    @Basic
    @Column(name = "remaining_space", nullable = true, precision = 0)
    private Double remainingSpace;
    @Basic
    @Column(name = "vcf", nullable = true, precision = 0)
    private Double vcf;
    @Basic
    @Column(name = "liquid_level_status", nullable = true, length = 255)
    private String liquidLevelStatus;
    @Basic
    @Column(name = "net_standard_volume", nullable = true, precision = 0)
    private Double netStandardVolume;
    @Basic
    @Column(name = "water_bottom_volume", nullable = true, precision = 0)
    private Double waterBottomVolume;
    @Basic
    @Column(name = "tank_flow_inout", nullable = true, precision = 0)
    private Double tankFlowInout;
    @Basic
    @Column(name = "usable_volume", nullable = true, precision = 0)
    private Double usableVolume;
    @Basic
    @Column(name = "standard_quality_sum", nullable = true, precision = 0)
    private Double standardQualitySum;
    @Basic
    @Column(name = "standard_quality_net", nullable = true, precision = 0)
    private Double standardQualityNet;
    @Basic
    @Column(name = "working_volume_max", nullable = true, precision = 0)
    private Double workingVolumeMax;

    @Basic
    @Column(name = "working_volume_min", nullable = true, precision = 0)
    private Double workingVolumeMin;
    @Basic
    @Column(name = "liquid_level", nullable = true, precision = 0)
    private Double liquidLevel;
    @Basic
    @Column(name = "physical_temperature", nullable = true, precision = 0)
    private Double physicalTemperature;
    @Basic
    @Column(name = "ambient_temperature", nullable = true, precision = 0)
    private Double ambientTemperature;
    @Basic
    @Column(name = "density_of_material", nullable = true, precision = 0)
    private Double densityOfMaterial;
    @Basic
    @Column(name = "police_liquid_level", nullable = true, length = 255)
    private String policeLiquidLevel;
    @Basic
    @Column(name = "police_temperature", nullable = true, length = 255)
    private String policeTemperature;
    @Basic
    @Column(name = "police_liquid_switch", nullable = true, length = 255)
    private String policeLiquidSwitch;
    @Basic
    @Column(name = "police_instrument_system", nullable = true, length = 255)
    private String policeInstrumentSystem;
    @Basic
    @Column(name = "police_inout_volume", nullable = true, length = 255)
    private String policeInoutVolume;
    @Basic
    @Column(name = "oms_source_target", nullable = true)
    private Integer omsSourceTarget;
    @Basic
    @Column(name = "oms_share", nullable = true)
    private Integer omsShare;
    @Basic
    @Column(name = "oms_share_depth", nullable = true)
    private Integer omsShareDepth;
    @Basic
    @Column(name = "oms_occupy", nullable = true)
    private Integer omsOccupy;
    @Basic
    @Column(name = "materiel_name", nullable = true, length = 255)
    private String materielName;
    @Basic
    @Column(name = "materiel_type", nullable = true, length = 255)
    private String materielType;
    @Basic
    @Column(name = "materiel_quality_attributes", nullable = true, length = 255)
    private String materielQualityAttributes;
    @Basic
    @Column(name = "materiel_density", nullable = true, precision = 0)
    private Double materielDensity;
}

其他的按照正常的框架写就可以了,和mysql的使用方式基本上没有区别

  • 5
    点赞
  • 31
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
PGSQL是指PostgreSQL,它是一种强大的关系型数据库管理系统。在使用Spring Boot框架搭建PGSQL的应用时,常见的做法是使用Druid作为连接池,MyBatis作为持久层框架,通过MyBatis Generator自动生成POJO、Mapper和DAO代码。 在Spring Boot的配置文件中,需要导入PGSQL的依赖项并配置数据源信息,例如URL、用户名、密码等。可以使用以下代码片段作为yml配置文件的示例: ```yaml spring: datasource: url: jdbc:postgresql://localhost:5432/postgres username: postgres password: 123456 driverClassName: org.postgresql.Driver ``` 此外,还可以配置其他相关的属性,如Jackson的时区、JPA的设置、Hibernate的配置、数据库的DDL操作等。需要注意的是,以上仅为一个示例配置,根据实际情况可能需要做出相应的调整。 关于安装PGSQL的方式,可以通过Stack Builder进行安装,但有时可能会遇到速度慢或卡顿的情况。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* [springboot+mybatis3+druid+postgresql](https://download.csdn.net/download/qq_35918388/10399737)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] - *2* [Postgresql+Springboot yml基本使用](https://blog.csdn.net/qq_39898191/article/details/108797167)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] - *3* [Spring Boot配合Postgresql和MybatisPlus实现外卖平台常见的距离你xxx米功能](https://blog.csdn.net/tsgjcnyn/article/details/127694116)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] [ .reference_list ]

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值