From 3f9ac67b7fe272fcf48b2d7ef549e4ac7872a3a8 Mon Sep 17 00:00:00 2001 From: wuww <252740454@qq.com> Date: 星期二, 15 四月 2025 16:40:51 +0800 Subject: [PATCH] 修改数据库表结构,添加实体类 --- src/main/java/com/se/nsl/domain/po/Region.java | 66 +++++++++++++ data/init.sql | 4 src/main/java/com/se/nsl/domain/po/Simu.java | 182 ++++++++++++++++++++++++++++++++++++ 3 files changed, 250 insertions(+), 2 deletions(-) diff --git a/data/init.sql b/data/init.sql index 1022e0c..59cebd4 100644 --- a/data/init.sql +++ b/data/init.sql @@ -31,9 +31,9 @@ comment on column nsl.simu.service_name is '鏈嶅姟鍚嶇О'; comment on column nsl.simu.type is '绫诲埆锛�1-棰勬祴妯℃嫙锛�2-瀹炴椂妯℃嫙锛�3-鍘嗗彶妯℃嫙'; comment on column nsl.simu.area_type is '鍖哄煙绫诲埆锛�0-鑷畾涔夛紝1-琛屾斂鍖哄垝锛�2-閲嶇偣鍖哄煙锛�3-閲嶇偣娌�'; -comment on column nsl.simu.data is '鏁版嵁'; +comment on column nsl.simu.data is '鏁版嵁(JSON)'; comment on column nsl.simu.status is '鐘舵�侊細0-鍒涘缓浠跨湡锛�1-棰勫鐞嗭紝2-鍒嗘瀽涓紝10-瀹屾垚锛�20-鍑洪敊'; -comment on column nsl.simu.result is '缁撴灉'; +comment on column nsl.simu.result is '缁撴灉(JSON)'; comment on column nsl.simu.create_time is '鍒涘缓鏃堕棿'; comment on column nsl.simu.create_user is '鍒涘缓浜�'; comment on column nsl.simu.update_time is '鏇存柊鏃堕棿'; diff --git a/src/main/java/com/se/nsl/domain/po/Region.java b/src/main/java/com/se/nsl/domain/po/Region.java new file mode 100644 index 0000000..6ce3c41 --- /dev/null +++ b/src/main/java/com/se/nsl/domain/po/Region.java @@ -0,0 +1,66 @@ +package com.se.nsl.domain.po; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; + +@TableName("nsl.region") +@SuppressWarnings("ALL") +@ApiModel(value = "鎺ㄦ紨鍖哄煙", description = "鎺ㄦ紨鍖哄煙") +public class Region { + @TableId(type = IdType.AUTO) + @ApiModelProperty("涓婚敭ID") + private Long id; + + @ApiModelProperty("鍚嶇О") + private String name; + + @ApiModelProperty("绫诲埆锛�1-琛屾斂鍖哄垝锛�2-閲嶇偣鍖哄煙锛�3-閲嶇偣娌�") + private Short type; + + @ApiModelProperty("绌洪棿浣嶇疆") + private String geom; + + public Region() { + } + + public Region(String name, Short type, String geom) { + this.name = name; + this.type = type; + this.geom = geom; + } + + public Long getId() { + return id; + } + + public void setId(Long id) { + this.id = id; + } + + public String getName() { + return name; + } + + public void setName(String name) { + this.name = name; + } + + public Short getType() { + return type; + } + + public void setType(Short type) { + this.type = type; + } + + public String getGeom() { + return geom; + } + + public void setGeom(String geom) { + this.geom = geom; + } +} diff --git a/src/main/java/com/se/nsl/domain/po/Simu.java b/src/main/java/com/se/nsl/domain/po/Simu.java new file mode 100644 index 0000000..548b756 --- /dev/null +++ b/src/main/java/com/se/nsl/domain/po/Simu.java @@ -0,0 +1,182 @@ +package com.se.nsl.domain.po; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; + +import java.sql.Timestamp; + +@TableName("nsl.simu") +@SuppressWarnings("ALL") +@ApiModel(value = "鎺ㄦ紨妯℃嫙", description = "鎺ㄦ紨妯℃嫙") +public class Simu { + @TableId(type = IdType.AUTO) + @ApiModelProperty("涓婚敭ID") + private Long id; + + @ApiModelProperty("鍚嶇О") + private String name; + + @ApiModelProperty("鏈嶅姟鍚嶇О") + private String serviceName; + + @ApiModelProperty("绫诲埆锛�1-棰勬祴妯℃嫙锛�2-瀹炴椂妯℃嫙锛�3-鍘嗗彶妯℃嫙") + private Short type; + + @ApiModelProperty("鍖哄煙绫诲埆锛�0-鑷畾涔夛紝1-琛屾斂鍖哄垝锛�2-閲嶇偣鍖哄煙锛�3-閲嶇偣娌�") + private Short areaType; + + @ApiModelProperty("鏁版嵁(JSON)") + private String data; + + @ApiModelProperty("鐘舵�侊細0-鍒涘缓浠跨湡锛�1-棰勫鐞嗭紝2-鍒嗘瀽涓紝10-瀹屾垚锛�20-鍑洪敊") + private Integer status; + + @ApiModelProperty("缁撴灉(JSON)") + private String result; + + @ApiModelProperty("鍒涘缓鏃堕棿") + private Timestamp createTime; + + @ApiModelProperty("鍒涘缓浜�") + private Timestamp createUser; + + @ApiModelProperty("鏇存柊鏃堕棿") + private Timestamp updateTime; + + @ApiModelProperty("鏇存柊浜�") + private Timestamp updateUser; + + @ApiModelProperty("澶囨敞") + private String bak; + + @ApiModelProperty("绌洪棿浣嶇疆") + private String geom; + + public Simu() { + } + + public Simu(String name, String serviceName, Short type, Short areaType, String data, Integer status, String geom) { + this.name = name; + this.serviceName = serviceName; + this.type = type; + this.areaType = areaType; + this.data = data; + this.status = status; + this.geom = geom; + } + + public Long getId() { + return id; + } + + public void setId(Long id) { + this.id = id; + } + + public String getName() { + return name; + } + + public void setName(String name) { + this.name = name; + } + + public String getServiceName() { + return serviceName; + } + + public void setServiceName(String serviceName) { + this.serviceName = serviceName; + } + + public Short getType() { + return type; + } + + public void setType(Short type) { + this.type = type; + } + + public Short getAreaType() { + return areaType; + } + + public void setAreaType(Short areaType) { + this.areaType = areaType; + } + + public String getData() { + return data; + } + + public void setData(String data) { + this.data = data; + } + + public Integer getStatus() { + return status; + } + + public void setStatus(Integer status) { + this.status = status; + } + + public String getResult() { + return result; + } + + public void setResult(String result) { + this.result = result; + } + + public Timestamp getCreateTime() { + return createTime; + } + + public void setCreateTime(Timestamp createTime) { + this.createTime = createTime; + } + + public Timestamp getCreateUser() { + return createUser; + } + + public void setCreateUser(Timestamp createUser) { + this.createUser = createUser; + } + + public Timestamp getUpdateTime() { + return updateTime; + } + + public void setUpdateTime(Timestamp updateTime) { + this.updateTime = updateTime; + } + + public Timestamp getUpdateUser() { + return updateUser; + } + + public void setUpdateUser(Timestamp updateUser) { + this.updateUser = updateUser; + } + + public String getBak() { + return bak; + } + + public void setBak(String bak) { + this.bak = bak; + } + + public String getGeom() { + return geom; + } + + public void setGeom(String geom) { + this.geom = geom; + } +} -- Gitblit v1.9.3