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
117
118
119
120
| Êþº¾ 32
| Y · ¸
| · ¹
| º »
| ¼ X ½ ¾ ¿ À Á Â
| · Ã Ä Å
| · Ã Æ m Ç
| È
| É
| Y ¼
| Ê
| Ë
| Ì
| Í
| Î
| Ï Ã Ð Ñ Ò
| Ó À Ô Õ Ö À ×
| Ø Ù Ú Û
| Ü
| Ý
| Þ
| ß à á â ã X ä å
| æ ç À è é ê ë
| B ì í
| B î ï
| B ð ñ
| B ò ó
| B ô õ ö
| B ·
| B É
| B Ê
| B Ë
| B Ì
| B Í
| B Î
| B Ï ÷
| B Ü
| B Ý
| B Þ
| B ß ø ù ú û
| ü ý
| ü þ ÿ ° 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; realocation Lcom/hxzkoa/json/tb_realocation; obj [Ljava/lang/Object; i I date Ljava/lang/String; sql query Ljavax/persistence/Query;
| resultList Ljava/util/List; tb_realocationList LocalVariableTypeTable 2Ljava/util/List<Lcom/hxzkoa/json/tb_realocation;>; StackMapTable Å Signature F(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_realocation;>; (II)Ljava/util/List; page perPage 6(II)Ljava/util/List<Lcom/hxzkoa/json/tb_realocation;>; getRealTimeLocationCount (Ljava/lang/String;)I searchRealTimeLocation 6(Ljava/lang/String;Ljava/lang/String;)Ljava/util/List; input X(Ljava/lang/String;Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_realocation;>; searchtablenameLocation realTimeLocation_delete (([Ljava/lang/String;Ljava/lang/String;)V id checkVal [Ljava/lang/String; :Lorg/springframework/transaction/annotation/Transactional; realTimeLocation_deletea (([Ljava/lang/String;Ljava/lang/String;)I aaa realTimeLocation_deleteAll (Ljava/lang/String;)V realTimeLocation_deleteAlla track_add /(Ljava/lang/String;Lcom/hxzkoa/json/tb_track;)I track Lcom/hxzkoa/json/tb_track; executeUpdate getTrack &(Ljava/lang/String;II)Ljava/util/List; tb_trackList ,Ljava/util/List<Lcom/hxzkoa/json/tb_track;>; ö B(Ljava/lang/String;II)Ljava/util/List<Lcom/hxzkoa/json/tb_track;>; getTracka @(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_track;>; getTrackDateList ()Ljava/util/List; $Ljava/util/List<Ljava/lang/String;>; &()Ljava/util/List<Ljava/lang/String;>; tag_time (Lcom/hxzkoa/json/tb_tag;)V tag Lcom/hxzkoa/json/tb_tag; panduanweiyi name
| resultlist strs 8(Ljava/lang/String;)Ljava/util/List<Ljava/lang/String;>;
| SourceFile LocationService.java (Lorg/springframework/stereotype/Service; a b java/lang/StringBuilder /SELECT id,tagid,x,y,z,layer,time FROM tb_track_ Z [
| ¨ java/util/ArrayList com/hxzkoa/json/tb_realocation java/lang/Integer FSELECT id,tagid,x,y,z,layer,time FROM tb_realocation LIMIT :start,:end start end SELECT count(1) FROM tb_track_ ! " 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 # $ % & |SELECT COUNT(`TABLE_NAME`) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA` = 'hxzkuwb' AND `TABLE_NAME` = :tablename tablename DELETE FROM tb_track_ WHERE id = :id ^ _ tb_realocation' () INSERT INTO tb_track_ >(tagid,x,y,z,layer,time) VALUES(:tag_id,:x,:y,:z,:layer,now()) tag_id * x + y , z - layer . LIMIT :start,:end com/hxzkoa/json/tb_track OSELECT id,tagid,x,y,z,layer,time,baoliu1,baoliu2,baoliu3,baoliu4 FROM tb_track_ wselect right(table_name,8) from information_schema.tables where table_schema='hxzkuwb' and table_name like 'tb_track_%' 7UPDATE tb_tag SET addtime=:addtime WHERE tag_id=:tag_id tb_tag addtime/ 0 1 2select p_tagid from tb_person where p_name = :name #com/hxzkoa/services/LocationService java/lang/Object java/lang/String javax/persistence/Query java/util/List append -(Ljava/lang/String;)Ljava/lang/StringBuilder; toString ()Ljava/lang/String; javax/persistence/EntityManager createNativeQuery -(Ljava/lang/String;)Ljavax/persistence/Query; getResultList size ()I get (I)Ljava/lang/Object; intValue setId (I)V setTagid setX setY setZ setLayer setTime add (Ljava/lang/Object;)Z valueOf (I)Ljava/lang/Integer; setParameter ?(Ljava/lang/String;Ljava/lang/Object;)Ljavax/persistence/Query; getSingleResult ()Ljava/lang/Object; parseInt setFangkeid setJingdu setWeidu setGaocheng !com/hxzkoa/services/CaozuoService tb_caozuo (Ljava/lang/String;I)V getTagid getX getY getZ getLayer com/hxzkoa/json/tb_tag
| getAddtime getTag_id ! X Y Z [ \ ] ^ _ \ ` a b c / *· ± d e f g h i c 8 MN» Y· ¶ +¶ ¶ ¶ M*´ ,¹ N-¹
| :» Y· :¹ Ý6¹ ¢ λ Y· :¹ À À :2À ¶ ¶ 2Ç §
| 2¶ ¶ 2Ç §
| 2¶ ¶ 2Ç §
| 2¶ ¶ 2Ç §
| 2¶ ¶ 2Ç §
| 2¶ ¶ 2Ç § 2¶ ¶ ¹ W§ÿ,° d R ! " ( # 0 $ 9 % C & R ' [ ( l ) { * + « , Ã - Û . ó / 0 & 3 e \ [ ¼ j k l « l m F × n o f g p q r q s t 0 ð u v 9 ç w v x 9 ç w y z : ÿ F { | | } ~ ~ ÿ B { | | } ~ ~ ÿ { | | } ~ ~ |P ÿ { | | } ~ ~ |P ÿ { | | } ~ ~ |P ÿ { | | } ~ ~ |P ÿ { | | } ~ ~ |Q ÿ { | | } ~ ~ |ø h c O
| -N: N*´ -¹ : d h¸ ¹ W! ¸ ¹ W¹
| :» Y· :¹ Ý6¹ ¢ λ Y· :¹ À À : 2À ¶ ¶ 2Ç §
| 2¶ ¶ 2Ç §
| 2¶ ¶ 2Ç §
| 2¶ ¶ 2Ç §
| 2¶ ¶ 2Ç §
| 2¶ ¶ 2Ç § 2¶ ¶ ¹ W§ÿ,° d Z 7 8 9 : ; & < 4 = = > F ? P @ _ A h B y C D E ¸ F Ð G è H I J$ @* M e f
| h ¼ j k y « l m S × n o - f g - o - o + r q ( s t = ð u v F ç w v x F ç w y z 2 ÿ S { | } ~ ~ ÿ B
| { | } ~ ~ ÿ
| { | } ~ ~ |P ÿ
| { | } ~ ~ |P ÿ
| { | } ~ ~ |P ÿ
| { | } ~ ~ |P ÿ
| { | } ~ ~ |Q ÿ
| { | } ~ ~ |ø
c 5MN» Y· "¶ +¶ ¶ ¶ M*´ ,¹ N-¹ # ¶ ¸ $¬ d Q R S T ( U e * 5 f g 5 p q 3 r q 1 s t c
| N:» Y· %¶ ,¶ &¶ ¶ N*´ -¹ :'+¹ W¹
| :» Y· :¹ E6¹ ¢6» Y· :¹ À À : 2À ¶ ¶ 2Ç §
| 2¶ ¶ 2Ç §
| 2¶ ¶ 2Ç §
| 2¶ ¶ 2Ç §
| 2¶ ¶ 2Ç §
| 2¶ ¶ 2Ç § 2¶ ¶ 2Ç § 2¶ ¶ ( 2Ç § 2¶ ¶ ) 2Ç § 2¶ ¶ *
| 2Ç §
| 2¶ ¶ +¹ W§þÄ° d f Y Z [ \ * ] 5 ^ > _ G ` Q a ` b i c z d e ¡ f ¹ g Ñ h é i j k5 lO mi n o a r e f
| i$ j k z l m T? n o f g q p q r q s t >X u v GO w v x GO w y z ÿ T { | | | } ~ ~ ÿ B
| { | | | } ~ ~ ÿ
| { | | | } ~ ~ |P ÿ
| { | | | } ~ ~ |P ÿ
| { | | | } ~ ~ |P ÿ
| { | | | } ~ ~ |P ÿ
| { | | | } ~ ~ |Q ÿ
| { | | | } ~ ~ |Q ÿ
| { | | | } ~ ~ |Q ÿ
| { | | | } ~ ~ |Q ÿ
| { | | | } ~ ~ |Q ÿ
| { | | | } ~ ~ |ø c
)MN,M*´ ,¹ N--+¹ W-¹ # ¶ ¸ $¬ d v w x y z { e * ) f g ) q ' r q % s t c eN:6+¾¢ X+2¸ $6» Y· .¶ ,¶ /¶ ¶ N*´ 01¶ 2*´ -¹ :3¸ ¹ W¹ 4 W§ÿ§± d . 1
; G V ^ d e H F o \ n o e f g e e p q c r q ` s t z þ | }ú [ \ c * kN:+¾66+¾¢ X+2¸ $6» Y· .¶ ,¶ /¶ ¶ N*´ 01¶ 2*´ -¹ :3¸ ¹ W¹ 4 W§ÿ§¬ d 2 5 ? K Z b h e R F o \ n o k f g k k p q i r q f s t b o z ÿ { | | } ú [ \ c 0MN» Y· .¶ +¶ ¶ ¶ M*´ ,¹ N-¹ 4 W± d ¡ ( ¢ / £ e * 0 f g 0 p q . r q , s t \ c 3MN» Y· .¶ +¶ ¶ ¶ M*´ ,¹ N-¹ 4 6¬ d § ¨ © ª ( « 0 ¬ e 4 3 f g 3 p q 1 r q / s t 0 o \ c |N:» Y· 5¶ +¶ 6¶ ¶ N*´ -¹ :7,¶ 8¹ W9,¶ :¹ W;,¶ <¹ W=,¶ >¹ W?,¶ @¹ W¹ 4 6¬ d . ± ² ³ ´ * µ 8 ¶ F · T ¸ b ¹ p º y » e > | f g | p q | z r q w s t y o \ c G::» Y· ¶ +¶ A¶ ¶ :*´ ¹ : d h¸ ¹ W!2¸ ¹ W¹
| :» Y· :¹ Ý6¹ ¢ λ BY· C: ¹ À À :
|
| 2À ¶ ¶ D
| 2Ç §
|
| 2¶ ¶ E
| 2Ç §
|
| 2¶ ¶ F
| 2Ç §
|
| 2¶ ¶ G
| 2Ç §
|
| 2¶ ¶ H
| 2Ç §
|
| 2¶ ¶ I
| 2Ç §
| 2¶ ¶ J ¹ W§ÿ,° d Z À Á Â Ã - Ä ? Å N Æ W Ç ` È j É y Ê Ë Ì ¢ Í º Î Ò Ï ê Ð Ñ Ò4 Ó> ÉD Ö e p ¼ « l m
| m × n o G f g G p q G o G o D r q A s t W ð u v ` ç ¡ v x ` ç ¡ ¢ z J ÿ m { | | } ~ ~ ÿ B { | | } ~ ~ £ £ÿ { | | } ~ ~ £ £ |P £ÿ { | | } ~ ~ £ £ |P £ÿ { | | } ~ ~ £ £ |P £ÿ { | | } ~ ~ £ £ |P £ÿ { | | } ~ ~ £ £ |Q £ÿ { | | } ~ ~ £ £ |ø ¤ ¥ i c X MN» Y· K¶ +¶ ¶ ¶ M*´ ,¹ N-¹
| :» Y· :¹ E6¹ ¢6» BY· C:¹ À À :2À ¶ ¶ D2Ç §
| 2¶ ¶ E2Ç §
| 2¶ ¶ F2Ç §
| 2¶ ¶ G2Ç §
| 2¶ ¶ H2Ç §
| 2¶ ¶ I2Ç § 2¶ ¶ J2Ç § 2¶ ¶ L2Ç § 2¶ ¶ M 2Ç § 2¶ ¶ N
| 2Ç §
| 2¶ ¶ O¹ W§þÄ° d b Û Ü Ý Þ ( ß 0 à 9 á C â R ã [ ä l å { æ ç « è Ã é Û ê ó ë ì' íA î[ ïu ð â
ó e \ [$ l l m F? n o f g p q r q s t 0X u v 9O ¡ v x 9O ¡ ¢ z â ÿ F { | | } ~ ~ ÿ B { | | } ~ ~ £ £ÿ { | | } ~ ~ £ £ |P £ÿ { | | } ~ ~ £ £ |P £ÿ { | | } ~ ~ £ £ |P £ÿ { | | } ~ ~ £ £ |P £ÿ { | | } ~ ~ £ £ |Q £ÿ { | | } ~ ~ £ £ |Q £ÿ { | | } ~ ~ £ £ |Q £ÿ { | | } ~ ~ £ £ |Q £ÿ { | | } ~ ~ £ £ |Q £ÿ { | | } ~ ~ £ £ |ø ¦ § ¨ c LMPL*´ +¹ M,¹
| N-° d ÷ ø ù ú û ü e * f g r q s t u v x u © ª « ¬ c ¦ >MNQM*´ 0R¶ 2*´ ,¹ N-S+¶ T¹ W-7+¶ U¹ W-¹ 4 W± d & ) 6 = e * > f g > ® < r q : s t \ ¯ i c YMNVM*´ ,¹ N-W+¹ W-¹
| :» Y· :6¹ ¢ ¹ ¶ ¹ W§ÿÝ° d . $ - < P V e H 0 & n o Y f g Y ° q W r q U s t $ 5 ± v - , ² v x - , ² © z ÿ 0 { | | } ~ ~ ú % ³ ´ µ \ ¶
|
|
