11111

fxl

2023-05-04 e150655a785de36a65a26a0dc4d3d6d65fe7e9d0

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

@@ -93,7 +93,7 @@
      sql = "SELECT id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,version,gonglv,jiaozhundistance,GreateTime FROM (SELECT id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,version,gonglv,jiaozhundistance,GreateTime FROM tb_achor ORDER BY id DESC) s LIMIT :start,:end";
      query = this.em.createNativeQuery(sql);
      query.setParameter("start", (page - 1) * Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
      query.setParameter("end", Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")));
      query.setParameter("end", 50);
      List resultList = query.getResultList();
      List<tb_achor> tb_achorList = new ArrayList<tb_achor>();
      if (resultList.size() > 0) {