From 7b4c8991dca9cf2a809a95e239d144697d3afb56 Mon Sep 17 00:00:00 2001
From: 15832144755 <67030627+15832144755@users.noreply.github.com>
Date: 星期四, 06 一月 2022 12:15:34 +0800
Subject: [PATCH] 2022.1.6
---
src/main/java/com/hxzkoa/services/FenceService.java | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/hxzkoa/services/FenceService.java b/src/main/java/com/hxzkoa/services/FenceService.java
index 36ef4df..6c40ca4 100644
--- a/src/main/java/com/hxzkoa/services/FenceService.java
+++ b/src/main/java/com/hxzkoa/services/FenceService.java
@@ -30,7 +30,7 @@
public List<tb_fence> getFenceList() {
String sql = null;
Query query = null;
- sql = "SELECT id,floor,type,bumen,name,zuobiao,shape,start,stop,addtime,color FROM tb_fence";
+ sql = "SELECT id,floor,type,bumen,name,zuobiao,shape,start,stop,addtime,color,baoliu1 FROM tb_fence";
query = this.em.createNativeQuery(sql);
List resultList = query.getResultList();
List<tb_fence> tb_fenceList = new ArrayList<tb_fence>();
@@ -49,6 +49,7 @@
fence.setStop(obj[8] == null ? "" : obj[8].toString());
fence.setAddtime(obj[9] == null ? "" : obj[9].toString());
fence.setColor(obj[10] == null ? "" : obj[10].toString());
+ fence.setBaoliu1(obj[11] == null ? "" : obj[11].toString());
tb_fenceList.add(fence);
}
}
@@ -241,7 +242,7 @@
public void fenceList_modify(tb_fence fence) {
String sql = null;
Query query = null;
- sql = "UPDATE tb_fence SET bumen=:bumen,name=:name,zuobiao=:zuobiao,start=:start,stop=:stop WHERE id=:id";
+ sql = "UPDATE tb_fence SET bumen=:bumen,name=:name,zuobiao=:zuobiao,start=:start,stop=:stop,baoliu1=:baoliu1 WHERE id=:id";
cs.tb_caozuo("tb_fence", 3);
query = this.em.createNativeQuery(sql);
query.setParameter("bumen", fence.getBumen());
@@ -250,6 +251,7 @@
query.setParameter("start", fence.getStart());
query.setParameter("stop", fence.getStop());
query.setParameter("id", fence.getId());
+ query.setParameter("baoliu1", fence.getBaoliu1());
query.executeUpdate();
}
--
Gitblit v1.10.0