8.27

15832144755

2021-08-27 3516f02277035cdc7ff137422709b16efe97ca4a

 src/main/java/com/hxzkoa/services/GpsService.java

@@ -124,7 +124,7 @@
      int end = perPage;
      String sql = null;
      Query query = null;
      sql = "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";
      sql = "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 order by addtime desc LIMIT :start,:end";
      query = this.em.createNativeQuery(sql);
      query.setParameter("start", start);
      query.setParameter("end", end);