From 65807b1a334e55b0f30dd53df8bdac81d2dc4dbd Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期二, 25 五月 2021 10:50:54 +0800
Subject: [PATCH] 更新试验接口
---
src/main/java/com/whyc/mapper/CommonMapper.java | 6 +++++-
1 files changed, 5 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/whyc/mapper/CommonMapper.java b/src/main/java/com/whyc/mapper/CommonMapper.java
index b60b2f1..df3c9a6 100644
--- a/src/main/java/com/whyc/mapper/CommonMapper.java
+++ b/src/main/java/com/whyc/mapper/CommonMapper.java
@@ -3,6 +3,7 @@
import com.whyc.pojo.ExperimentPrecondition;
import net.sf.jsqlparser.expression.JdbcNamedParameter;
import org.apache.ibatis.annotations.Select;
+import org.apache.ibatis.annotations.Update;
import java.util.List;
@@ -11,6 +12,9 @@
@Select("select TABLE_NAME FROM information_schema.TABLES where TABLE_SCHEMA= #{dBName} and TABLE_NAME like concat(#{tableLike},'%')")
List<String> getTableName(String dBName, String tableLike);
- @Select("select ${field} as actualValue from ${tableName} where dev_id = #{deviceId}")
+ @Select("select ${field} as actualValue from ${tableName} where dev_id in (#{deviceId})")
Object getPreconditionStatus(ExperimentPrecondition precondition);
+
+ @Update("update ${tableName} set ${field} = #{value} where dev_id in (${deviceId})")
+ int setPrecondition(String tableName,String deviceId,String field,String value);
}
--
Gitblit v1.9.1