java链接海量数据库Vastbase G100

1. 海量官方文档
   https://docs.vastdata.com.cn/zh_CN/VastbaseG100/V3.0.8/1/adce199918814d3dacafe07d1384421f

2. 连接数据库
   
   下载默认驱动

3. 添加maven依赖

        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>42.3.8</version>
        </dependency>

        <!-- SPRINGBOOT DRUID -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>

4. 数据库配置

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name=org.postgresql.Driver
spring.datasource.url=jdbc:postgresql://192.0.0.3:5432/jkcard?currentSchema=bi_data
spring.datasource.username=4564
spring.datasource.password=123
mybatis.mapper-locations=classpath*\:cc/eslink/bi/mapper/*.xml
mybatis.type-aliases-package=cc.eslink.bi.domain
spring.datasource.druid.initial-size=5
spring.datasource.druid.min-idle=5
spring.datasource.druid.max-active=20
spring.datasource.druid.max-wait=60000
spring.datasource.druid.time-between-eviction-runs-millis=60000
spring.datasource.druid.min-evictable-idle-time-millis=300000

5. 测试数据

CREATE TABLE bi_data.user_info_data (
    user_id SERIAL PRIMARY KEY,
    user_name_data varchar(50) NOT NULL,
    email_data varchar(100) NULL,
    password_data varchar(255) NOT NULL,
    created_time timestamp(0) NULL DEFAULT pg_systimestamp(),
    updated_time timestamp(0) NULL DEFAULT pg_systimestamp(),
    CONSTRAINT users_email_key UNIQUE (email_data)
);

SELECT created_time::timestamp FROM bi_data.user_info_data;


INSERT INTO bi_data.user_info_data (user_id,user_name_data,email_data,password_data) VALUES
	 (1,'xiaokli','aa','123'),
	 (2,'john_doe','john@example.com','password123');

package cc.eslink.bi.domain;

import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;

import javax.persistence.Id;
import javax.persistence.Table;
import java.time.ZonedDateTime;

/**
 * @author : wxj
 * @date : 2025/4/2 13:43
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
@Builder
@Table(name = "user_info_data")
public class Users {
    @Id
    private Long userId;
    private String userNameData;
    private String emailData;
    private String passwordData;
    private ZonedDateTime createdTime;
    private ZonedDateTime updatedTime;
}

package cc.eslink.bi.dao;

import cc.eslink.bi.domain.Users;
import cc.eslink.common.base.BaseDao;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author : wxj
 * @date : 2025/4/2 13:46
 */
@Mapper
public interface UsersDao extends BaseDao<Users> {
    List<Users>  queryOne(@Param("username") String username);
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cc.eslink.bi.dao.UsersDao">

    <select id="queryOne" resultType="cc.eslink.bi.domain.Users">
        SELECT user_id,user_name_data,email_data,password_data FROM user_info_data where user_name_data = #{username}
    </select>


</mapper>

6. Vastbase G100 时间类型字段处理可能会有问题
   时间最好用 TIMESTAMP

CREATE TABLE device_warn (
    id BIGINT PRIMARY KEY COMMENT '告警记录的唯一标识',
    happenTime TIMESTAMP COMMENT '告警发生的时间',
    companyCode VARCHAR(20) COMMENT '公司代码',
    stationId VARCHAR(50) COMMENT '站点ID',
    stationName VARCHAR(255) COMMENT '站点名称',
    deviceId VARCHAR(50) COMMENT '设备ID',
    deviceName VARCHAR(255) COMMENT '设备名称',
    measId INT COMMENT '测量点ID',
    measName VARCHAR(255) COMMENT '测量点名称',
    messageByte TEXT COMMENT '原始告警消息字节数据',
    message TEXT COMMENT '告警消息内容',
    state INT COMMENT '告警状态',
    dealerId INT COMMENT '处理人ID',
    dealerName VARCHAR(255) COMMENT '处理人姓名',
    dealType VARCHAR(50) COMMENT '处理类型',
    dealTime TIMESTAMP COMMENT '处理时间',
    dealDes TEXT COMMENT '处理描述',
    type VARCHAR(50) COMMENT '告警类型',
    lalarmgradeid INT COMMENT '告警等级ID',
    handleTime TIMESTAMP COMMENT '处理时间',
    handleUsername VARCHAR(255) COMMENT '处理人用户名',
    dispatchTime TIMESTAMP COMMENT '派发时间',
    dispatchUsername VARCHAR(255) COMMENT '派发人用户名',
    dispatchState INT COMMENT '派发状态',
    yystate INT COMMENT '运营状态',
    faultState INT COMMENT '故障状态',
    tid VARCHAR(50) COMMENT '事务ID',
    map TEXT COMMENT '地图信息',
    devcode VARCHAR(50) COMMENT '设备编码',
    link TEXT COMMENT '链接信息',
    phone VARCHAR(20) COMMENT '联系电话',
    address TEXT COMMENT '地址信息',
    vender VARCHAR(255) COMMENT '供应商信息',
    countnum INT COMMENT '计数',
    LimitId INT COMMENT '限制ID'
) COMMENT='设备告警记录表';