SourceFile GpsService.java (Lorg/springframework/stereotype/Service; java/util/LinkedList D:\baowen.txt java/io/File í java/io/FileInputStream java/io/BufferedReader java/io/InputStreamReader java/io/IOException java/io/FileNotFoundException Ò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,ccid FROM tb_gps java/util/ArrayList Æ com/hxzkoa/json/tb_gps java/lang/Integer Æ í í í í í í ¡ í ¢ í £ í ¤ í ¥ í ¦ í § í ¨ í © í ª í « í ¬ í í® ¯° ±² ³ ã ú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,ccid FROM tb_gps order by addtime desc LIMIT :start,:end ´µ ¶· è·å失败 SELECT count(1) FROM tb_gps ¸¹dSELECT g.id,g.gps_utc_time,g.gps_weidu,g.gps_NS,g.gsp_jingdu,g.gps_EW,g.gps_state,g.gps_num,g.gps_hdop,g.gps_haiba_gao,g.gps_tuoqiu,g.gps_chafen_time,g.gps_chafen_id,g.gps_jiaoyan,g.tagid,g.gps_kahao,g.gps_power,g.gps_sos,g.addtime,g.ccid FROM tb_gps g,tb_person p WHERE p.p_tagid = g.tagid AND g.tagid = :tagid OR p.p_tagid = g.tagid AND p.p_name = :tagid <SELECT gps_weidu,gsp_jingdu FROM tb_gps WHERE tagid = :tagid tUPDATE tb_system SET origin_jingdu=:origin_jingdu,origin_weidu=:origin_weidu,origin_jiaodu=:origin_jiaodu WHERE id=1
tb_systemº »¼ origin_jingdu½ ¾ origin_weidu ¿ origin_jiaodu À Á Æ 'DELETE FROM tb_gps WHERE tagid = :tagid tb_gps java/lang/StringBuilder SELECT * FROM tb_gps_track_ ÂÃ LIMIT :start,:end "SELECT count(1) FROM tb_gps_track_ where tagid = :tagid {select right(table_name,8) from information_schema.tables where table_schema='hxzkuwb' and table_name like 'tb_gps_track_%' DELETE FROM tb_gps_track_ WHERE id = :id 4 WHERE tagid = :p_tagid ORDER BY id DESC LIMIT 0,100 p_tagid SELECT id,gps_weidu,gsp_jingdu,gps_state,gps_num,gps_haiba_gao,gps_chafen_id,tagid,gps_hdop,gps_chafen_time,gps_power,addtime FROM tb_gps_track_ WHERE tagid = ' ' AND addtime>= ' ' AND addtime<= ' ' ORDER BY addtime /SELECT p_online FROM tb_person WHERE p_tagid =' ' +SELECT anchorid,tagid,AQBJ_SCZ FROM tb_buju select id,acid,state,jingdu,weidu,gaodu,posx,posy,floor,distance,port,baoliu1,baoliu2,addtime from tb_rtkanchor ORDER BY addtime DESC LIMIT :start,:end com/hxzkoa/json/tb_rtkanchor Ä í Å í Æ í Ç í È í É í Ê í Ë í Ì í Í í Î í Ï í select id,acid,state,jingdu,weidu,gaodu,posx,posy,floor,distance,port,baoliu1,baoliu2,addtime from tb_rtkanchor WHERE acid = :acid ORDER BY addtime DESC acid !SELECT count(1) FROM tb_rtkanchor 'DELETE FROM tb_rtkanchor WHERE id = :id DELETE FROM tb_rtkanchor com/hxzkoa/services/GpsService java/lang/Object java/util/List java/lang/String java/lang/Throwable javax/persistence/Query (Ljava/io/File;)V (Ljava/io/InputStream;)V (Ljava/io/Reader;)V readLine ()Ljava/lang/String; add (Ljava/lang/Object;)Z close printStackTrace javax/persistence/EntityManager createNativeQuery -(Ljava/lang/String;)Ljavax/persistence/Query; getResultList size get (I)Ljava/lang/Object; intValue setId (I)V toString setGps_utc_time setGps_weidu setGps_NS setGsp_jingdu setGps_EW setGps_state
|
