From e4efa2387409d35e1fc5e566b84e2065aafa30a6 Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期四, 20 六月 2019 16:17:59 +0800
Subject: [PATCH] 修改三级
---
sensor/src/com/fgkj/dao/impl/Sensor_infImpl.java | 10 +++++++---
1 files changed, 7 insertions(+), 3 deletions(-)
diff --git a/sensor/src/com/fgkj/dao/impl/Sensor_infImpl.java b/sensor/src/com/fgkj/dao/impl/Sensor_infImpl.java
index 5a4c6db..eb87150 100644
--- a/sensor/src/com/fgkj/dao/impl/Sensor_infImpl.java
+++ b/sensor/src/com/fgkj/dao/impl/Sensor_infImpl.java
@@ -126,7 +126,7 @@
//鏌ヨ鎵�鏈夌殑鍩庡競锛堜笁绾э級
public List serchCounty(Object obj){
Sensor_inf sinf=(Sensor_inf) obj;
- String sql=" select distinct county from db_sensor.tb_sensor_inf where province like ? and city like ? order by province asc";
+ String sql=" select distinct county,sensor_dev_id,province,device_name from db_sensor.tb_sensor_inf where province like ? and city like ? order by province asc";
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{"%"+sinf.getProvince()+"%","%"+sinf.getCity()+"%"}, new CallBack() {
@Override
@@ -134,8 +134,12 @@
List list=new ArrayList();
try {
while(rs.next()){
- String county=rs.getString("county");
- list.add(county);
+ Sensor_inf s=new Sensor_inf();
+ s.setSensor_dev_id(rs.getInt("sensor_dev_id"));
+ s.setProvince(rs.getString("province"));
+ s.setCity(rs.getString("city"));
+ s.setCounty(rs.getString("county"));
+ s.setDevice_name(rs.getString("device_name"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
--
Gitblit v1.9.1