From bc131131c5c96f8cb3bed679d4a359820c22e335 Mon Sep 17 00:00:00 2001
From: 15832144755 <67030627+15832144755@users.noreply.github.com>
Date: 星期四, 17 三月 2022 09:38:47 +0800
Subject: [PATCH] 3.17
---
src/main/java/com/hxzkoa/services/BasicInfoService.java | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/hxzkoa/services/BasicInfoService.java b/src/main/java/com/hxzkoa/services/BasicInfoService.java
index 55db713..b54c9dd 100644
--- a/src/main/java/com/hxzkoa/services/BasicInfoService.java
+++ b/src/main/java/com/hxzkoa/services/BasicInfoService.java
@@ -410,6 +410,27 @@
}
return tb_personList;
}
+
+ public List<tb_tag> searchPersonManagementa(String input) {
+ String sql = null;
+ Query query = null;
+ sql = "SELECT * FROM tb_tag WHERE tag_id = :tag_id";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("tag_id", input);
+ List resultList = query.getResultList();
+ List<tb_tag> tb_personList = new ArrayList<tb_tag>();
+ if (resultList.size() > 0) {
+ for (int i = 0; i < resultList.size(); i++) {
+ tb_tag tb_tag = new tb_tag();
+ Object[] obj = (Object[]) resultList.get(i);
+ tb_tag.setId((int) obj[0]);
+ tb_tag.setState(obj[2] == null ? "" : obj[2].toString());
+ tb_tag.setPower(obj[3] == null ? "" : obj[3].toString());
+ tb_personList.add(tb_tag);
+ }
+ }
+ return tb_personList;
+ }
@Transactional
public int personManagement_delete(String checkVal) {
--
Gitblit v1.10.0