【2022年法定工作日，周末，节假日类型使用Java存入sql】

Json下载链接：https://download.csdn.net/download/Macho_/68245740
Sql下载：https://download.csdn.net/download/Macho_/68245389

实体类

public class DateType {
    Integer id;
    @JsonFormat(locale="zh", timezone="GMT + 8",shape=JsonFormat.Shape.STRING, pattern="yyyy-MM-dd")
    Date dateStr;
    Integer dateType;

    public DateType() {
    }

    public DateType(Integer id, Date dateStr, Integer dateType) {
        this.id = id;
        this.dateStr = dateStr;
        this.dateType = dateType;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public Date getDateStr() {
        return dateStr;
    }

    public void setDateStr(Date dateStr) {
        this.dateStr = dateStr;
    }

    public Integer getDateType() {
        return dateType;
    }

    public void setDateType(Integer dateType) {
        this.dateType = dateType;
    }
}

枚举类

工作日；0，周末：1，节假日：2;

public enum EnumDateType {
    //工作类型枚举
    DATE_TYPE_WORKDAY("工作日",0),
    DATE_TYPE_WEEKEND("周末",1),
    DATE_TYPE_HOLIDAY("节假日",2);

    private String name;
    private Integer value;

    EnumDateType() {
    }

    EnumDateType(String name, Integer value) {
        this.name = name;
        this.value = value;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getValue() {
        return value;
    }

    public void setValue(Integer value) {
        this.value = value;
    }
}

json串

[{
        "dateStr": "2022-01-01",
        "dateType": 2
    }, {
        "dateStr": "2022-01-02",
        "dateType": 2
    }, {
        "dateStr": "2022-01-03",
        "dateType": 2
    }, {
        "dateStr": "2022-01-04",
        "dateType": 0
    }, {
        "dateStr": "2022-01-05",
        "dateType": 0
    }]
    ...

Sql语句

INSERT INTO "public"."calendar_table" VALUES (1, '2022-01-01', 2);
INSERT INTO "public"."calendar_table" VALUES (2, '2022-01-02', 2);
INSERT INTO "public"."calendar_table" VALUES (3, '2022-01-03', 2);
INSERT INTO "public"."calendar_table" VALUES (4, '2022-01-04', 0);
.....