| | |
| | | public List<tb_gas> getSensorManagement() { |
| | | String sql = null; |
| | | Query query = null; |
| | | sql = "SELECT id,wei_zhi,gas_type,nong_du,status,collect_ip,tong_dao,waring_zhi,ip,x,y,addtime FROM tb_gas"; |
| | | sql = "SELECT id,wei_zhi,gas_type,nong_du,status,collect_ip,tong_dao,waring_zhi,ip,x,y,addtime,name FROM tb_gas"; |
| | | query = this.em.createNativeQuery(sql); |
| | | List resultList = query.getResultList(); |
| | | List<tb_gas> tb_gasList = new ArrayList<tb_gas>(); |
| | |
| | | gas.setX(obj[9] == null ? "" : obj[9].toString()); |
| | | gas.setY(obj[10] == null ? "" : obj[10].toString()); |
| | | gas.setAddtime(obj[11] == null ? "" : obj[11].toString()); |
| | | gas.setName(obj[12] == null ? "" : obj[12].toString()); |
| | | tb_gasList.add(gas); |
| | | } |
| | | } |