Êþº¾ 3 Ò com/hxzkoa/services/GpsService java/lang/Object em !Ljavax/persistence/EntityManager; RuntimeVisibleAnnotations &Ljavax/persistence/PersistenceContext; <init> ()V Code
|
|
LineNumberTable LocalVariableTable this Lcom/hxzkoa/services/GpsService; getGpsManagement ()Ljava/util/List; Signature ,()Ljava/util/List<Lcom/hxzkoa/json/tb_gps;>; ÍSELECT id,gps_utc_time,gps_weidu,gps_NS,gsp_jingdu,gps_EW,gps_state,gps_num,gps_hdop,gps_haiba_gao,gps_tuoqiu,gps_chafen_time,gps_chafen_id,gps_jiaoyan,tagid,gps_kahao,gps_power,gps_sos,addtime FROM tb_gps 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_gps
|
. ) 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 setGps_utc_time (Ljava/lang/String;)V
|
. K L I setGps_weidu
|
. N O I setGps_NS
|
. Q R I setGsp_jingdu
|
. T U I setGps_EW
|
. W X I setGps_state
|
. Z [ I
|
setGps_num
|
. ] ^ I setGps_hdop
|
. ` a I setGps_haiba_gao
|
. c d I setGps_tuoqiu
|
. f g I setGps_chafen_time
|
. i j I setGps_chafen_id
|
. l m I setTagid
|
. o p I setGps_kahao
|
. r s I setGps_power
|
. u v I
|
setGps_sos
|
. x y I
|
setAddtime ) { | } add (Ljava/lang/Object;)Z sql Ljava/lang/String; query Ljavax/persistence/Query;
|
resultList Ljava/util/List;
|
tb_gpsList i I gps Lcom/hxzkoa/json/tb_gps; obj LocalVariableTypeTable *Ljava/util/List<Lcom/hxzkoa/json/tb_gps;>; StackMapTable java/lang/String (I)Ljava/util/List; -(I)Ljava/util/List<Lcom/hxzkoa/json/tb_gps;>;
|
com/hxzkoa/util/Config E getPageConfig perPage
|
com/hxzkoa/util/ModifyConfig readData 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
|
7 ¡ parseInt (Ljava/lang/String;)I £ ßSELECT id,gps_utc_time,gps_weidu,gps_NS,gsp_jingdu,gps_EW,gps_state,gps_num,gps_hdop,gps_haiba_gao,gps_tuoqiu,gps_chafen_time,gps_chafen_id,gps_jiaoyan,tagid,gps_kahao,gps_power,gps_sos,addtime FROM tb_gps LIMIT :start,:end ¥ start
|
7 § ¨ © valueOf (I)Ljava/lang/Integer; ! « ¬ setParameter ?(Ljava/lang/String;Ljava/lang/Object;)Ljavax/persistence/Query; ¯ end
|
. ± ² I setGps_jiaoyan page getGpsManagementCount ¶ SELECT count(1) FROM tb_gps ! ¸ ¹ º getSingleResult ()Ljava/lang/Object; searchGpsManagement $(Ljava/lang/String;)Ljava/util/List; >(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/tb_gps;>; ¿ âSELECT id,gps_utc_time,gps_weidu,gps_NS,gsp_jingdu,gps_EW,gps_state,gps_num,gps_hdop,gps_haiba_gao,gps_tuoqiu,gps_chafen_time,gps_chafen_id,gps_jiaoyan,tagid,gps_kahao,gps_power,gps_sos,addtime FROM tb_gps WHERE tagid = :tagid Á tagid input gpsManagement_delete ([Ljava/lang/String;)V :Lorg/springframework/transaction/annotation/Transactional; Ç !DELETE FROM tb_gps WHERE id = :id É id ! Ë Ì - executeUpdate checkVal [Ljava/lang/String;
|
SourceFile GpsService.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¶ V2Ç @§ 2¶ B¶ Y2Ç @§ 2¶ B¶ \ 2Ç @§ 2¶ B¶ _
|
2Ç @§
|
2¶ B¶ b 2Ç @§ 2¶ B¶ e 2Ç @§ 2¶ B¶ h 2Ç @§ 2¶ B¶ k2Ç @§ 2¶ B¶ n2Ç @§ 2¶ B¶ q2Ç @§ 2¶ B¶ t2Ç @§ 2¶ B¶ w¹ z W-¹ ( ¡þ° ~ " + 1 : ! G " V # n $ % & ¶ ' Î ( è ) * +6 ,P -j . / 0¸ 1Ò 2ì 3 4 7 R ! ~ "ÿ .ð
:Ö GÉ 6 "ÿ Ò %ÿ 1 ! ) ) ÿ 2 ! ) ) . 5 .ÿ ! ) ) . 5 . P .ÿ ! ) ) . 5 . P .ÿ ! ) ) . 5 . P .ÿ ! ) ) . 5 . P .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . ù ú
|
w¸ ¸ ¸ =d h> 6::¢:*´ ¹ :¤ ¸ ¦¹ ª W®¸ ¦¹ ª 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
|
2Ç @§ 2¶ B¶ Y
|
2Ç @§ 2¶ B¶ \
|
2Ç @§ 2¶ B¶ _
|
|
2Ç @§
|
2¶ B¶ b
|
2Ç @§ 2¶ B¶ e
|
2Ç @§ 2¶ B¶ h
|
2Ç @§ 2¶ B¶ °
|
2Ç @§ 2¶ B¶ k
|
2Ç @§ 2¶ B¶ n
|
2Ç @§ 2¶ B¶ q
|
2Ç @§ 2¶ B¶ t
|
2Ç @§ 2¶ B¶ w
|
¹ z W ¹ ( ¡ýú° % ; < = > ? @ A , B : C I D R E [ F e G k H t I J K © L Á M Ù N ñ O P# Q= RW Sq T U¥ V¿ WÙ Xó Y Z' [A \[ ]e Gt ` z w w ³ k e ¥ b ¯ _ ~ \ R% [ h
tñ
|
ã 6 [ I 'ÿ k
|
! ) ) ÿ 3 ! ) ) . 5 .ÿ ! ) ) . 5 . P .ÿ ! ) ) . 5 . P .ÿ ! ) ) . 5 . P .ÿ ! ) ) . 5 . P .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . Q .ÿ ! ) ) . 5 . ù ú ´ - m LMµL*´ +¹ M,¹ · ¶ B¸ ¬ d e f g h ~ » ¼ ½ à
|
O+MN:¾N*´ -¹ :À,¹ ª 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 2Ç @§ 2¶ B¶ Y 2Ç @§ 2¶ B¶ \ 2Ç @§ 2¶ B¶ _
|
2Ç @§
|
2¶ B¶ b 2Ç @§ 2¶ B¶ e 2Ç @§ 2¶ B¶ h 2Ç @§ 2¶ B¶ ° 2Ç @§ 2¶ B¶ k 2Ç @§ 2¶ B¶ n 2Ç @§ 2¶ B¶ q 2Ç @§ 2¶ B¶ t 2Ç @§ 2¶ B¶ w¹ z W¹ ( ¡ýú° " l m n o
|
p q ! r * s 3 t = u C v L w Z x i y z { ± | É } á ~ û / I c }
± Ë å ÿ 3 = uL f
|
O O Â M Á K ~ H *% 3 @
Lñ Zã 6 3 q 'ÿ C ! ) ) ÿ 3
|
! ) ) . 5 .ÿ
|
! ) ) . 5 . P .ÿ
|
! ) ) . 5 . P .ÿ
|
! ) ) . 5 . P .ÿ
|
! ) ) . 5 . P .ÿ
|
! ) ) . 5 . Q .ÿ
|
! ) ) . 5 . Q .ÿ
|
! ) ) . 5 . Q .ÿ
|
! ) ) . 5 . Q .ÿ
|
! ) ) . 5 . Q .ÿ
|
! ) ) . 5 . Q .ÿ
|
! ) ) . 5 . Q .ÿ
|
! ) ) . 5 . Q .ÿ
|
! ) ) . 5 . Q .ÿ
|
! ) ) . 5 . Q .ÿ
|
! ) ) . 5 . Q .ÿ
|
! ) ) . 5 . Q .ÿ
|
! ) ) . 5 . Q .ÿ
|
! ) ) . 5 . ù ú Ã Ä Å Ô AMN6§ 2+2¸ 6ÆM*´ ,¹ N-ȸ ¦¹ ª W-¹ Ê W+¾¡ÿͱ *
|
|
! / 6 @ > A A Í Î ? ~ = 9
# É þ
|
!. Ï Ð Ñ
|
