添加四级导航

81041

2019-06-20 1a3f82584ef2fb2a6b5c9c95d14b77b6f7fb3325

添加四级导航

 sensor/src/com/fgkj/actions/Sensor_infAction.java

@@ -30,6 +30,13 @@
        result=tojson(model);

        return SUCCESS;

    }

    //查询所有的设备（四级）

    public String serchDevice(){

        Sensor_inf sinf=ActionUtil.getGson().fromJson(json, Sensor_inf.class);

        ServiceModel model=service.serchDevice(sinf);

        result=tojson(model);

        return SUCCESS;

    }

    //根据设备id查询信息

    public String serchByCondition(){

        Sensor_inf sinf=ActionUtil.getGson().fromJson(json, Sensor_inf.class);


 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


 sensor/src/com/fgkj/services/Sensor_infService.java

@@ -56,6 +56,19 @@
        }

        return model;

    }

    //查询所有的设备（四级）

    public ServiceModel serchDevice(Object obj){

        List list=((Sensor_infImpl)dao).serchDevice(obj);

        if(list!=null&&list.size()>0){

            model.setCode(1);

            model.setData(list);

            model.setMsg("查询成功!");

        }else{

            model.setCode(0);

            model.setMsg("查询失败!");

        }

        return model;

    }

    //根据设备id查询信息

    public ServiceModel serchByCondition(Object obj){

        List list=dao.serchByCondition(obj);