From e150655a785de36a65a26a0dc4d3d6d65fe7e9d0 Mon Sep 17 00:00:00 2001
From: fxl <473369119@qq.com>
Date: 星期四, 04 五月 2023 18:03:37 +0800
Subject: [PATCH] 11111
---
src/main/java/com/hxzkoa/services/HelmetService.java | 75 ++++++++++++++++++++++++++++---------
1 files changed, 56 insertions(+), 19 deletions(-)
diff --git a/src/main/java/com/hxzkoa/services/HelmetService.java b/src/main/java/com/hxzkoa/services/HelmetService.java
index 32fda64..f5d3a64 100644
--- a/src/main/java/com/hxzkoa/services/HelmetService.java
+++ b/src/main/java/com/hxzkoa/services/HelmetService.java
@@ -1,20 +1,26 @@
+//
+// Source code recreated from a .class file by IntelliJ IDEA
+// (powered by FernFlower decompiler)
+//
+
package com.hxzkoa.services;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
-
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@Service
public class HelmetService {
-
@PersistenceContext
private EntityManager em;
-
+
+ public HelmetService() {
+ }
+
@Transactional
- public void offhat(String tagid,String state) {
+ public void offhat(String tagid, String state) {
Query query = null;
String sql = null;
sql = "UPDATE tb_person SET baoliu29=:state WHERE p_tagid=:tagid";
@@ -23,9 +29,9 @@
query.setParameter("state", state);
query.executeUpdate();
}
-
+
@Transactional
- public void smash(String tagid,String state) {
+ public void smash(String tagid, String state) {
Query query = null;
String sql = null;
sql = "UPDATE tb_person SET baoliu25=:state WHERE p_tagid=:tagid";
@@ -34,9 +40,9 @@
query.setParameter("state", state);
query.executeUpdate();
}
-
+
@Transactional
- public void stopmoving(String tagid,String state) {
+ public void stopmoving(String tagid, String state) {
Query query = null;
String sql = null;
sql = "UPDATE tb_person SET baoliu26=:state WHERE p_tagid=:tagid";
@@ -45,9 +51,9 @@
query.setParameter("state", state);
query.executeUpdate();
}
-
+
@Transactional
- public void high(String tagid,String state) {
+ public void high(String tagid, String state) {
Query query = null;
String sql = null;
sql = "UPDATE tb_person SET baoliu27=:state WHERE p_tagid=:tagid";
@@ -56,9 +62,9 @@
query.setParameter("state", state);
query.executeUpdate();
}
-
+
@Transactional
- public void nearele(String tagid,String state) {
+ public void nearele(String tagid, String state) {
Query query = null;
String sql = null;
sql = "UPDATE tb_person SET baoliu28=:state WHERE p_tagid=:tagid";
@@ -67,9 +73,9 @@
query.setParameter("state", state);
query.executeUpdate();
}
-
+
@Transactional
- public void video(String tagid,String name) {
+ public void video(String tagid, String name) {
Query query = null;
String sql = null;
sql = "UPDATE tb_person SET baoliu30=:name WHERE p_tagid=:tagid";
@@ -78,9 +84,9 @@
query.setParameter("name", name);
query.executeUpdate();
}
-
+
@Transactional
- public void audio(String tagid,String name) {
+ public void audio(String tagid, String name) {
Query query = null;
String sql = null;
sql = "UPDATE tb_person SET baoliu31=:name WHERE p_tagid=:tagid";
@@ -89,9 +95,20 @@
query.setParameter("name", name);
query.executeUpdate();
}
-
+
@Transactional
- public void setgps(String tagid,String lon,String lat) {
+ public void image(String tagid, String name) {
+ Query query = null;
+ String sql = null;
+ sql = "UPDATE tb_person SET baoliu34=:name WHERE p_tagid=:tagid";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("tagid", tagid);
+ query.setParameter("name", name);
+ query.executeUpdate();
+ }
+
+ @Transactional
+ public void setgps(String tagid, String lon, String lat) {
Query query = null;
String sql = null;
sql = "UPDATE tb_gps SET gsp_jingdu=:lon,gps_weidu=:lat WHERE tagid=:tagid";
@@ -101,5 +118,25 @@
query.setParameter("lat", lat);
query.executeUpdate();
}
-
+
+ @Transactional
+ public void guanbi(String tagid, String type) {
+ Query query = null;
+ String sql = null;
+ sql = "UPDATE tb_person SET " + type + "='' WHERE p_tagid=:tagid";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("tagid", tagid);
+ query.executeUpdate();
+ }
+
+ @Transactional
+ public String removefile(String tagid, String type) {
+ Query query = null;
+ String sql = null;
+ sql = "SELECT " + type + " from tb_person WHERE p_tagid=:tagid";
+ query = this.em.createNativeQuery(sql);
+ query.setParameter("tagid", tagid);
+ Object person = query.getSingleResult();
+ return person.toString();
+ }
}
--
Gitblit v1.10.0