From 0be1444ba6afcf04ce02990389a707b3ba2d9888 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 22 十一月 2022 20:12:45 +0800
Subject: [PATCH] 1
---
data/db_tab.sql | 4 ++++
src/main/java/com/lf/server/entity/data/MetaEntity.java | 20 ++++++++++++++++++++
src/main/resources/mapper/data/MetaMapper.xml | 12 ++++++------
3 files changed, 30 insertions(+), 6 deletions(-)
diff --git a/data/db_tab.sql b/data/db_tab.sql
index cd31a10..bbd0e77 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -546,6 +546,8 @@
verid integer default 0,
type varchar(100),
sizes float8 default 0,
+ tab varchar(50),
+ rows integer default 0,
cs varchar(50),
scale varchar(50),
resolution varchar(50),
@@ -571,6 +573,8 @@
comment on column lf.sys_meta.verid is '鐗堟湰ID';
comment on column lf.sys_meta.type is '绫诲瀷:File-鏂囦欢,DB-鏁版嵁';
comment on column lf.sys_meta.sizes is '澶у皬锛氬崟浣峂B';
+comment on column lf.sys_meta.tab is '琛ㄥ悕';
+comment on column lf.sys_meta.rows is '琛屾暟';
comment on column lf.sys_meta.cs is '鍧愭爣绯�';
comment on column lf.sys_meta.scale is '姣斾緥灏�';
comment on column lf.sys_meta.resolution is '鍒嗚鲸鐜�';
diff --git a/src/main/java/com/lf/server/entity/data/MetaEntity.java b/src/main/java/com/lf/server/entity/data/MetaEntity.java
index 5fc4473..dcd1436 100644
--- a/src/main/java/com/lf/server/entity/data/MetaEntity.java
+++ b/src/main/java/com/lf/server/entity/data/MetaEntity.java
@@ -24,6 +24,10 @@
private double sizes;
+ private String tab;
+
+ private int rows;
+
private String cs;
private String scale;
@@ -111,6 +115,22 @@
this.sizes = sizes;
}
+ public String getTab() {
+ return tab;
+ }
+
+ public void setTab(String tab) {
+ this.tab = tab;
+ }
+
+ public int getRows() {
+ return rows;
+ }
+
+ public void setRows(int rows) {
+ this.rows = rows;
+ }
+
public String getCs() {
return cs;
}
diff --git a/src/main/resources/mapper/data/MetaMapper.xml b/src/main/resources/mapper/data/MetaMapper.xml
index 380ffe4..35eeae3 100644
--- a/src/main/resources/mapper/data/MetaMapper.xml
+++ b/src/main/resources/mapper/data/MetaMapper.xml
@@ -35,17 +35,17 @@
</selectKey>
insert into lf.sys_meta
- (name,dirid,depid,verid,type,sizes,cs,scale,resolution,gather,batch,descr,create_user,create_time,geom)
+ (name,dirid,depid,verid,type,sizes,tab,rows,cs,scale,resolution,gather,batch,descr,create_user,create_time,geom)
values
- (#{name},#{dirid},#{depid},#{verid},#{type},#{sizes},#{cs},#{scale},#{resolution},#{createTime},#{batch},#{descr},#{createUser},now(),#{geom})
+ (#{name},#{dirid},#{depid},#{verid},#{type},#{sizes},#{tab},#{rows},#{cs},#{scale},#{resolution},#{createTime},#{batch},#{descr},#{createUser},now(),#{geom})
</insert>
<insert id="inserts">
insert into lf.sys_meta
- (name,dirid,depid,verid,type,sizes,cs,scale,resolution,gather,batch,descr,create_user,create_time,geom)
+ (name,dirid,depid,verid,type,sizes,tab,rows,cs,scale,resolution,gather,batch,descr,create_user,create_time,geom)
values
<foreach collection="list" item="item" index="index" separator=",">
- (#{item.name},#{item.dirid},#{item.depid},#{item.verid},#{item.type},#{item.sizes},#{item.cs},#{item.scale},#{item.resolution},now(),#{item.batch},#{item.descr},#{item.createUser},now(),#{item.geom})
+ (#{item.name},#{item.dirid},#{item.depid},#{item.verid},#{item.type},#{item.sizes},#{item.tab},#{item.rows},#{item.cs},#{item.scale},#{item.resolution},now(),#{item.batch},#{item.descr},#{item.createUser},now(),#{item.geom})
</foreach>
</insert>
@@ -62,7 +62,7 @@
<update id="update">
update lf.sys_meta
- set name=#{name},dirid=#{dirid},depid=#{depid},verid=#{verid},type=#{type},sizes=#{sizes},cs=#{cs},scale=#{scale},resolution=#{resolution},gather=now(),batch=#{batch},descr=#{descr},update_user=#{updateUser},update_time=now(),geom=#{geom}
+ set name=#{name},dirid=#{dirid},depid=#{depid},verid=#{verid},type=#{type},sizes=#{sizes},tab=#{tab},rows=#{rows},cs=#{cs},scale=#{scale},resolution=#{resolution},gather=now(),batch=#{batch},descr=#{descr},update_user=#{updateUser},update_time=now(),geom=#{geom}
where id=#{id}
</update>
@@ -70,7 +70,7 @@
<foreach collection="list" item="item" index="index" separator=";">
update lf.sys_meta
<set>
- name=#{item.name},dirid=#{item.dirid},depid=#{item.depid},verid=#{item.verid},type=#{item.type},sizes=#{item.sizes},cs=#{item.cs},scale=#{item.scale},resolution=#{item.resolution},gather=now(),batch=#{item.batch},descr=#{item.descr},update_user=#{item.updateUser},update_time=now(),geom=#{item.geom}
+ name=#{item.name},dirid=#{item.dirid},depid=#{item.depid},verid=#{item.verid},type=#{item.type},sizes=#{item.sizes},tab=#{item.tab},rows=#{item.rows},cs=#{item.cs},scale=#{item.scale},resolution=#{item.resolution},gather=now(),batch=#{item.batch},descr=#{item.descr},update_user=#{item.updateUser},update_time=now(),geom=#{item.geom}
</set>
where id = #{item.id}
</foreach>
--
Gitblit v1.9.3