3.7

fxl

2023-03-07 52cffc4ab8e9787a6f233295502c7c9788dddae1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
Êþº¾3
.
#com/hxzkoa/services/LocationService
java/lang/Object
em
!Ljavax/persistence/EntityManager;
RuntimeVisibleAnnotations
&Ljavax/persistence/PersistenceContext;
cs
#Lcom/hxzkoa/services/CaozuoService;
8Lorg/springframework/beans/factory/annotation/Autowired;
<init>
()V
Code
 
LineNumberTable
LocalVariableTable
this
%Lcom/hxzkoa/services/LocationService;
getRealTimeLocation
$(Ljava/lang/String;)Ljava/util/List;
  Signature
F(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_realocation;>;
java/lang/StringBuilder
/SELECT id,tagid,x,y,z,layer,time FROM tb_track_

(Ljava/lang/String;)V
!"#
append
-(Ljava/lang/String;)Ljava/lang/StringBuilder;
%&'
toString
()Ljava/lang/String; 
)+-,
javax/persistence/EntityManager./
createNativeQuery
-(Ljava/lang/String;)Ljavax/persistence/Query;132
javax/persistence/Query45
 getResultList
()Ljava/util/List;7
java/util/ArrayList
6:<;
java/util/List=>
size
()I@
com/hxzkoa/json/tb_realocation
?:CDE
get
(I)Ljava/lang/Object;G
[Ljava/lang/Object;I
java/lang/Integer
HKL>
intValue
?NOP
setId
(I)VR

%
?UV
setTagid
?XY
setX
?[\
setY
?^_
setZ
?ab
setLayer
?de
setTime:ghi
add
(Ljava/lang/Object;)Z
date
Ljava/lang/String;
sql
query
Ljavax/persistence/Query;

resultList
Ljava/util/List;
tb_realocationList

i

I
realocation
 Lcom/hxzkoa/json/tb_realocation;
obj
LocalVariableTypeTable
2Ljava/util/List<Lcom/hxzkoa/json/tb_realocation;>;
 StackMapTable{
java/lang/String
(II)Ljava/util/List;
6(II)Ljava/util/List<Lcom/hxzkoa/json/tb_realocation;>;
FSELECT id,tagid,x,y,z,layer,time FROM tb_realocation LIMIT :start,:end
start
Hƒ„…
valueOf
(I)Ljava/lang/Integer;1‡ˆ‰
setParameter
?(Ljava/lang/String;Ljava/lang/Object;)Ljavax/persistence/Query;‹
end
page
perPage
getRealTimeLocationCount
(Ljava/lang/String;)I‘
SELECT count(1) FROM tb_track_1“”•
getSingleResult
()Ljava/lang/Object;
H—˜
parseInt
searchRealTimeLocation
6(Ljava/lang/String;Ljava/lang/String;)Ljava/util/List;
X(Ljava/lang/String;Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_realocation;>;
eSELECT t.id,t.tagid,t.x,t.y,t.z,t.layer,t.time,t.baoliu1,t.baoliu2,t.baoliu3,t.baoliu4 FROM tb_track_Ÿ
n t,tb_person p WHERE t.tagid = p.p_tagid AND p.p_name = :p_tagid OR t.tagid = p.p_tagid AND t.tagid = :p_tagid¡
p_tagid
?£¤
setFangkeid
?¦§
 setJingdu
?©ª
setWeidu
?¬­
setGaocheng
input
searchtablenameLocation±
|SELECT COUNT(`TABLE_NAME`) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA` = 'hxzkuwb' AND `TABLE_NAME` = :tablename³
    tablename
realTimeLocation_delete
(([Ljava/lang/String;Ljava/lang/String;)V
:Lorg/springframework/transaction/annotation/Transactional;¸
DELETE FROM tb_track_º
 WHERE id = :id 
¼  
¾
tb_realocation
ÀÂÁ
!com/hxzkoa/services/CaozuoServiceÃÄ
  tb_caozuo
(Ljava/lang/String;I)VÆ
id1ÈÉ>
 executeUpdate
checkVal
[Ljava/lang/String;
realTimeLocation_deletea
(([Ljava/lang/String;Ljava/lang/String;)I
aaaË
realTimeLocation_deleteAll
realTimeLocation_deleteAlla
   track_add
/(Ljava/lang/String;Lcom/hxzkoa/json/tb_track;)IÕ
INSERT INTO tb_track_×
>(tagid,x,y,z,layer,time) VALUES(:tag_id,:x,:y,:z,:layer,now())Ù
tag_id
ÛÝÜ
com/hxzkoa/json/tb_trackÞ'
getTagidà

x
Ûâã'
getXå

y
Ûçè'
getYê

z
Ûìí'
getZï
layer
Ûñò'
getLayer
track
Lcom/hxzkoa/json/tb_track;
getTrack
&(Ljava/lang/String;II)Ljava/util/List;
B(Ljava/lang/String;II)Ljava/util/List<Lcom/hxzkoa/json/tb_track;>;ù
 LIMIT :start,:end
Û
ÛN
ÛU
ÛX
Û[
Û^
Ûa
Ûd
tb_trackList
,Ljava/util/List<Lcom/hxzkoa/json/tb_track;>;
    getTracka
@(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_track;>;

OSELECT id,tagid,x,y,z,layer,time,baoliu1,baoliu2,baoliu3,baoliu4 FROM tb_track_
Û£
Û¦
Û©
Û¬
getTrackDateList
&()Ljava/util/List<Ljava/lang/String;>;

wselect right(table_name,8) from information_schema.tables where table_schema='hxzkuwb' and table_name like 'tb_track_%'
$Ljava/util/List<Ljava/lang/String;>;
tag_time
(Lcom/hxzkoa/json/tb_tag;)V

7UPDATE tb_tag SET addtime=:addtime WHERE tag_id=:tag_id

tb_tag

addtime




com/hxzkoa/json/tb_tag
'

getAddtime



 '
 getTag_id
tag
Lcom/hxzkoa/json/tb_tag;
panduanweiyi
8(Ljava/lang/String;)Ljava/util/List<Ljava/lang/String;>;
&
2select p_tagid from tb_person where p_name = :name
(
name

resultlist
strs

SourceFile
LocationService.java
(Lorg/springframework/stereotype/Service;!


   



 
/

*·±


0  

M
N»Y·+¶ ¶$M*´(,¹*N-¹0
:»6Y·8:¹9
žÚ6§È»?Y·A:¹BÀF:2ÀH¶J¶M2ÇQ§
2¶S¶T2ÇQ§
2¶S¶W2ÇQ§
2¶S¶Z2ÇQ§
2¶S¶]2ÇQ§
2¶S¶`2ÇQ§2¶S¶c¹fW„
¹9
¡ÿ2°R !" #($1%;&A'J(X)g*+—,¯-Ç.ß/ù0
&
3\ 

jk

lk
mn(íop1äqp>ÔrsJ¹tuX«vGw
1äqxy
=ÿA
zz1::
ÿ3  
zz1::
?F
?ÿ  
zz1::
?F?zP?ÿ   
zz1::
?F?zP?ÿ   
zz1::
?F?zP?ÿ   
zz1::
?F?zP?ÿ   
zz1::
?F?zQ?ÿ   
zz1::
?F?zùú
|}O

*
N
:~N*´(-¹*:€dh¸‚¹†WŠ¸‚¹†W¹0
:»6Y·8:¹9
žÚ6§È»?Y·A:¹BÀF:     2ÀH¶J¶M  2ÇQ§
   2¶S¶T 2ÇQ§
   2¶S¶W 2ÇQ§
   2¶S¶Z 2ÇQ§
   2¶S¶] 2ÇQ§
   2¶S¶` 2ÇQ§    2¶S¶c¹fW„
¹9
¡ÿ2°Z789:;&<4==>F?P@VA_BmC|D”E¬FÄGÜHôI
J
@
'Mf

*
*Œs

*s
(lk
%mn=íopFäqpSÔrs_¹tum«vG w
Fäqxy
5ÿV


z1::
ÿ3



z1::
?F
?ÿ



z1::
?F?zP?ÿ



z1::
?F?zP?ÿ



z1::
?F?zP?ÿ



z1::
?F?zP?ÿ



z1::
?F?zQ?ÿ



z1::
?F?zùú
Ž
…-
M
N»Y·+¶ ¶$M*´(,¹*N-¹’
¶S¸–¬QRST U*--jk
+lk)mn
™š›•


N
:»Yœ·,¶ ž¶ ¶$N*´(-¹*: +¹†W¹0
:»6Y·8:¹9
ž
B6§
0»?Y·A:¹BÀF:   2ÀH¶J¶M  2ÇQ§
   2¶S¶T 2ÇQ§
   2¶S¶W 2ÇQ§
   2¶S¶Z 2ÇQ§
   2¶S¶] 2ÇQ§
   2¶S¶` 2ÇQ§    2¶S¶c    2ÇQ§    2¶S¶¢    2ÇQ§    2¶S¶¥       2ÇQ§     2¶S¶¨  
2ÇQ§  
2¶S¶«¹fW„
¹9
¡þÊ°fYZ[\']2^;_D`NaTb]ckdze’fªgÂhÚiòj
k
&l
@m
Zn
to
~a
rf


®k

jk
Žlk
‹mn;
UopD
LqpQ
<rs]
!tuk
vG w
D
Lqxy ÿT
zzz1::
ÿ3

zzz1::
?F
?ÿ

zzz1::
?F?zP?ÿ

zzz1::
?F?zP?ÿ

zzz1::
?F?zP?ÿ

zzz1::
?F?zP?ÿ

zzz1::
?F?zQ?ÿ

zzz1::
?F?zQ?ÿ

zzz1::
?F?zQ?ÿ

zzz1::
?F?zQ?ÿ

zzz1::
?F?zQ?ÿ

zzz1::
?F?zùú
¯
…)
M
N°M*´(,¹*N-²+¹†W-¹’
¶S¸–¬vwxyz{*))®k
'lk%mn
´µ
¶
b
N
:6§R+2¸–6»Y··,¶ ¹¶ ¶$N*´»½¶¿*´(-¹*:Ÿ‚¹†W¹Ç
W„
+¾¡ÿ­±.€‚ƒ„*…4†@‡OˆW‚aŠHbbÊË
bjk`lk]mnYrsCÆsyþz1
ûN
ÌÍ
¶
'h
N
:+¾66§R+2¸–6»Y··,¶ ¹¶ ¶$N*´»½¶¿*´(-¹*:Ÿ‚¹†W¹Ç
W„
+¾¡ÿ­¬2Ž ‘’“.”8•D–S—[‘e™RhhÊË
hjkflkcmn   _ÎsYrsCÆsyÿ
Ïzz1

ûN
Ð
¶„(
M
N»Y··+¶ ¶$M*´(,¹*N-¹Ç
W±žŸ ¡ ¢'£*((jk
&lk$mn
я
¶‘+
M
N»Y··+¶ ¶$M*´(,¹*N-¹Ç
6¬§¨©ª «(¬4++jk
)lk'mn(Îs
ÒÓ
¶ýy
N
:»YÔ·+¶ Ö¶ ¶$N*´(-¹*:Ø,¶Ú¹†Wß,¶á¹†Wä,¶æ¹†Wé,¶ë¹†Wî,¶ð¹†W¹Ç
6¬.±²³´'µ5¶C·Q¸_¹mºv»>yyjk
yóôwlktmnvÉs
õö÷‡
@
:
:»Y·+¶ ø¶ ¶$:*´(¹*:€dh¸‚¹†WŠ¸‚¹†W¹0
:»6Y·8:¹9
žÚ6§È»ÛY·ú:   ¹BÀF:
   
2ÀH¶J¶û    
2ÇQ§
 
2¶S¶ü   
2ÇQ§
 
2¶S¶ý   
2ÇQ§
 
2¶S¶þ   
2ÇQ§
 
2¶S¶ÿ   
2ÇQ§
 
2¶S¶
   
2ÇQ§
2¶S¶

    ¹fW„
¹9
¡ÿ2°ZÀÁÂÃ*Ä<ÅJÆSÇ\ÈfÉlÊu˃̒ͪÎÂÏÚÐòÑ

Ò
$Ó
.É
=Öp
@
@jk

@Œs
@s
=lk
:mnSíop\ä
piÔrsu¹óô   ƒ«vG
w
\ä

y
Mÿl  
z

z1::
ÿ3
z

z1::
ÛF
Ûÿ
z

z1::
ÛFÛzPÛÿ
z

z1::
ÛFÛzPÛÿ
z

z1::
ÛFÛzPÛÿ
z

z1::
ÛFÛzPÛÿ
z

z1::
ÛFÛzQÛÿ
z

z1::
ÛFÛzùú


Q 
~
M
N»Y
·+¶ ¶$M*´(,¹*N-¹0
:»6Y·8:¹9
ž
B6§
0»ÛY·ú:¹BÀF:2ÀH¶J¶û2ÇQ§
2¶S¶ü2ÇQ§
2¶S¶ý2ÇQ§
2¶S¶þ2ÇQ§
2¶S¶ÿ2ÇQ§
2¶S¶
2ÇQ§2¶S¶

2ÇQ§2¶S¶
2ÇQ§2¶S¶
    2ÇQ§    2¶S¶

 
2ÇQ§
2¶S¶
¹fW„
¹9
¡þÊ°bÛÜÝÞ!ß)à2á<âBãKäYåhæ€ç˜è°éÈêàëúì
í
.î
Hï
bð
lâ
{ó\  
~
~jk

|lk
zmn)
Uop2
L
p?
<rsK
!óôY
vGw
2
L

y
åÿB
zz1::
ÿ3  
zz1::
ÛF
Ûÿ  
zz1::
ÛFÛzPÛÿ   
zz1::
ÛFÛzPÛÿ   
zz1::
ÛFÛzPÛÿ   
zz1::
ÛFÛzPÛÿ   
zz1::
ÛFÛzQÛÿ   
zz1::
ÛFÛzQÛÿ   
zz1::
ÛFÛzQÛÿ   
zz1::
ÛFÛzQÛÿ   
zz1::
ÛFÛzQÛÿ   
zz1::
ÛFÛzùú

5
 Š
L
M
L*´(+¹*M,¹0
N-°÷øùúûü*lk
mnopw
o




¶©A
M
N
M*´»
¶¿*´(,¹*N-
+¶
¹†W-Ø+¶
¹†W-¹Ç
W±&   






,
9
@
 *AA
!
"
?lk=mn

#
$
[
M
N
%M*´(,¹*N-
'+¹†W-¹0
:»6Y·8:6§¹B¶S¹fW„
¹9
¡ÿà°.

 



&
/
5
I
X
H[[
(k
YlkWmn&5
)p/,
*p2&rsw
/,
*
yÿ5
zz1::

+
,

-