Êþº¾ 3 è #com/hxzkoa/services/LocationService java/lang/Object em !Ljavax/persistence/EntityManager; RuntimeVisibleAnnotations &Ljavax/persistence/PersistenceContext; <init> ()V Code
|
|
LineNumberTable LocalVariableTable this %Lcom/hxzkoa/services/LocationService; getRealTimeLocation ()Ljava/util/List; Signature 4()Ljava/util/List<Lcom/hxzkoa/json/tb_realocation;>; 4SELECT id,tagid,x,y,z,layer,time FROM tb_realocation javax/persistence/EntityManager createNativeQuery -(Ljava/lang/String;)Ljavax/persistence/Query; ! # " javax/persistence/Query $ getResultList & java/util/ArrayList
|
% ) + * java/util/List , - size ()I / com/hxzkoa/json/tb_realocation
|
. ) 2 3 4 get (I)Ljava/lang/Object; 6 [Ljava/lang/Object; 8 java/lang/Integer
|
7 : ; - intValue
|
. = > ? setId (I)V A
|
C D E toString ()Ljava/lang/String;
|
. G H I setTagid (Ljava/lang/String;)V
|
. K L I setX
|
. N O I setY
|
. Q R I setZ
|
. T U I setLayer
|
. W X I setTime ) Z [ \ add (Ljava/lang/Object;)Z sql Ljava/lang/String; 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 m java/lang/String (II)Ljava/util/List; 6(II)Ljava/util/List<Lcom/hxzkoa/json/tb_realocation;>; q FSELECT id,tagid,x,y,z,layer,time FROM tb_realocation LIMIT :start,:end s start
|
7 u v w valueOf (I)Ljava/lang/Integer; ! y z { setParameter ?(Ljava/lang/String;Ljava/lang/Object;)Ljavax/persistence/Query; } end page perPage getRealTimeLocationCount #SELECT count(1) FROM tb_realocation !
getSingleResult ()Ljava/lang/Object;
|
7 parseInt (Ljava/lang/String;)I searchRealTimeLocation $(Ljava/lang/String;)Ljava/util/List; F(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_realocation;>; KSELECT id,tagid,x,y,z,layer,time FROM tb_realocation WHERE tagid = :p_tagid p_tagid input realTimeLocation_delete ([Ljava/lang/String;)V :Lorg/springframework/transaction/annotation/Transactional; )DELETE FROM tb_realocation WHERE id = :id id ! - executeUpdate checkVal [Ljava/lang/String; realTimeLocation_deleteAll ¡ DELETE FROM tb_realocation track_add /(Ljava/lang/String;Lcom/hxzkoa/json/tb_track;)I ¥ java/lang/StringBuilder § INSERT INTO tb_track_
|
¤ © I
|
¤ « ¬ append -(Ljava/lang/String;)Ljava/lang/StringBuilder; ¯ >(tagid,x,y,z,layer,time) VALUES(:tag_id,:x,:y,:z,:layer,now())
|
¤ C ² tag_id
|
´ ¶ µ com/hxzkoa/json/tb_track · E getTagid ¹ x
|
´ » ¼ E getX ¾ y
|
´ À Á E getY Ã z
|
´ Å Æ E getZ È layer
|
´ Ê Ë E getLayer date 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;>; Ó /SELECT id,tagid,x,y,z,layer,time FROM tb_track_ Õ LIMIT :start,:end
|
´
|
´ =
|
´ G
|
´ K
|
´ N
|
´ Q
|
´ T
|
´ W tb_trackList ,Ljava/util/List<Lcom/hxzkoa/json/tb_track;>; getTrackDateList &()Ljava/util/List<Ljava/lang/String;>; ã vselect right(table_name,8) from information_schema.tables where table_schema='hxzkoa' and table_name like 'tb_track_%' $Ljava/util/List<Ljava/lang/String;>;
|
SourceFile LocationService.java (Lorg/springframework/stereotype/Service; !
|
|
/ *· ± ü LML*´ +¹ M,¹ N» %Y· ':-¹ ( Ø6§ Ç» .Y· 0:-¹ 1 À 5:2À 7¶ 9¶ <2Ç @§
|
2¶ B¶ F2Ç @§
|
2¶ B¶ J2Ç @§
|
2¶ B¶ M2Ç @§
|
2¶ B¶ P2Ç @§
|
2¶ B¶ S2Ç @§ 2¶ B¶ V¹ Y W-¹ ( ¡ÿ4° R " + 1 : ! G " V # n $ % & ¶ ' Î ( è ) ò , R ] ^ ÿ _ ` ê a b " á c b . Ò d e : ¸ f g G « h 6 i " á c j k % ÿ 1 l ! ) ) ÿ 2 l ! ) ) . 5 .ÿ l ! ) ) . 5 . lP .ÿ l ! ) ) . 5 . lP .ÿ l ! ) ) . 5 . lP .ÿ l ! ) ) . 5 . lP .ÿ l ! ) ) . 5 . lQ .ÿ l ! ) ) . 5 . lù ú
|
n o O
|
*N:pN*´ -¹ :rd h¸ t¹ x W| ¸ t¹ x W¹ :» %Y· ':¹ ( Ú6§ È» .Y· 0:¹ 1 À 5: 2À 7¶ 9¶ < 2Ç @§
|
2¶ B¶ F 2Ç @§
|
2¶ B¶ J 2Ç @§
|
2¶ B¶ M 2Ç @§
|
2¶ B¶ P 2Ç @§
|
2¶ B¶ S 2Ç @§ 2¶ B¶ V¹ Y W¹ ( ¡ÿ2° Z 0 1 2 3 4 & 5 4 6 = 7 F 8 P 9 V : _ ; m < | = > ¬ ? Ä @ Ü A ô B C 9' F f
|
* * ~ e * e ( ] ^ % _ ` = í a b F ä c b S Ô d e _ ¹ f g m « h 6 i F ä c j k 5 ÿ V l ! ) ) ÿ 3
|
l ! ) ) . 5 .ÿ
|
l ! ) ) . 5 . lP .ÿ
|
l ! ) ) . 5 . lP .ÿ
|
l ! ) ) . 5 . lP .ÿ
|
l ! ) ) . 5 . lP .ÿ
|
l ! ) ) . 5 . lQ .ÿ
|
l ! ) ) . 5 . lù ú - m LML*´ +¹ M,¹ ¶ B¸ ¬ J K L M N ] ^ _ ` 0 MNM*´ ,¹ N-+¹ x W-¹ :» %Y· ':¹ ( Ú6§ È» .Y· 0:¹ 1 À 5:2À 7¶ 9¶ <2Ç @§
|
2¶ B¶ F2Ç @§
|
2¶ B¶ J2Ç @§
|
2¶ B¶ M2Ç @§
|
2¶ B¶ P2Ç @§
|
2¶ B¶ S2Ç @§ 2¶ B¶ V¹ Y W¹ ( ¡ÿ2° V R S T U V W $ X - Y 7 Z = [ F \ T ] c ^ { _ ` « a à b Û c õ d ÿ Z g \ ^ ] ^ _ ` $ í a b - ä c b : Ô d e F ¹ f g T « h 6 i - ä c j k = ÿ = l l ! ) ) ÿ 3 l l ! ) ) . 5 .ÿ l l ! ) ) . 5 . lP .ÿ l l ! ) ) . 5 . lP .ÿ l l ! ) ) . 5 . lP .ÿ l l ! ) ) . 5 . lP .ÿ l l ! ) ) . 5 . lQ .ÿ l l ! ) ) . 5 . lù ú Ô AMN6§ 2+2¸ 6M*´ ,¹ N-¸ t¹ x W-¹ W+¾¡ÿͱ *
|
l m n
|
o p q ! r / s 6 n @ u > A A ? ] ^ = _ ` 9 d e # e k þ
|
l !.
|
l LM L*´ +¹ M,¹ W± y z { | } ~ ] ^ _ ` ¢ £ ý yN:» ¤Y¦· ¨+¶ ª®¶ ª¶ °N*´ -¹ :±,¶ ³¹ x W¸,¶ º¹ x W½,¶ ¿¹ x WÂ,¶ Ĺ x WÇ,¶ ɹ x W¹ 6¬ .
' 5 C Q _ m v > y y Ì ^ y Í Î w ] ^ t _ ` v e Ï Ð Ñ @::» ¤YÒ· ¨+¶ ªÔ¶ ª¶ °:*´ ¹ :r d h¸ t¹ x W| ¸ t¹ x W¹ :» %Y· ':¹ ( Ú6§ È» ´Y· Ö: ¹ 1 À 5:
|
|
2À 7¶ 9¶ ×
|
2Ç @§
|
|
2¶ B¶ Ø
|
2Ç @§
|
|
2¶ B¶ Ù
|
2Ç @§
|
|
2¶ B¶ Ú
|
2Ç @§
|
|
2¶ B¶ Û
|
2Ç @§
|
|
2¶ B¶ Ü
|
2Ç @§
|
2¶ B¶ Ý ¹ Y W¹ ( ¡ÿ2° Z * < J S \ f l u ª Â Ú ¡ ò ¢
|
£$ ¤. = § p @ @ Ì ^ @ ~ e @ e = ] ^ : _ ` S í a b \ ä Þ b i Ô d e u ¹ Í Î « h 6
|
i \ ä Þ ß k M ÿ l l l ! ) ) ÿ 3 l l ! ) ) ´ 5 ´ÿ l l ! ) ) ´ 5 ´ lP ´ÿ l l ! ) ) ´ 5 ´ lP ´ÿ l l ! ) ) ´ 5 ´ lP ´ÿ l l ! ) ) ´ 5 ´ lP ´ÿ l l ! ) ) ´ 5 ´ lQ ´ÿ l l ! ) ) ´ 5 ´ lù ú à á LMâL*´ +¹ M,¹ N-° « ¬ ® ¯ ° * ] ^ _ ` a b i a ä å æ ç
|
