| | |
|---|
| | | 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) { |
|---|
