From 1a3f82584ef2fb2a6b5c9c95d14b77b6f7fb3325 Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期四, 20 六月 2019 16:43:05 +0800
Subject: [PATCH] 添加四级导航
---
sensor/src/com/fgkj/dao/impl/Sensor_infImpl.java | 27 ++++++++++++++++++++++++++-
1 files changed, 26 insertions(+), 1 deletions(-)
diff --git a/sensor/src/com/fgkj/dao/impl/Sensor_infImpl.java b/sensor/src/com/fgkj/dao/impl/Sensor_infImpl.java
index eb87150..213800a 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,sensor_dev_id,province,device_name from db_sensor.tb_sensor_inf where province like ? and city like ? order by province asc";
+ String sql=" select distinct county 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,12 +134,37 @@
List list=new ArrayList();
try {
while(rs.next()){
+ String county=rs.getString("county");
+ list.add(county);
+ }
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ return list;
+ }
+ });
+ return list;
+ }
+ //鏌ヨ鎵�鏈夌殑璁惧锛堝洓绾э級
+ public List serchDevice(Object obj){
+ Sensor_inf sinf=(Sensor_inf) obj;
+ String sql=" select distinct sensor_dev_id,num,province,city,county,device_name from db_sensor.tb_sensor_inf where province like ? and city like ? and county like ? order by province asc";
+ List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{"%"+sinf.getProvince()+"%","%"+sinf.getCity()+"%","%"+sinf.getCounty()+"%"}, new CallBack() {
+
+ @Override
+ public List getResults(ResultSet rs) {
+ List list=new ArrayList();
+ try {
+ while(rs.next()){
Sensor_inf s=new Sensor_inf();
+ s.setNum(rs.getInt("num"));
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"));
+ list.add(s);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
--
Gitblit v1.9.1