修改

81041

2019-06-24 a7cdf717e2ad9f3c7a8dcff5ecfa499e2fd372e8

修改

 sensor/src/com/fgkj/dao/impl/Sensor_infImpl.java

@@ -162,7 +162,7 @@
    //查询所有的设备（四级）

    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";

        String sql=" select distinct sensor_dev_id,num,province,city,county,airtmp_alarm,airhum_alarm,smoke_alarm,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

@@ -176,6 +176,9 @@
                        s.setProvince(rs.getString("province"));

                        s.setCity(rs.getString("city"));

                        s.setCounty(rs.getString("county"));

                        s.setAirtmp_alarm(rs.getFloat("airtmp_alarm"));

                        s.setAirhum_alarm(rs.getFloat("airhum_alarm"));

                        s.setSmoke_alarm(rs.getInt("smoke_alarm"));

                        s.setDevice_name(rs.getString("device_name"));

                        list.add(s);

                    }

@@ -203,7 +206,13 @@
    

    public static void main(String[] args) {

        Sensor_infImpl simpl=new Sensor_infImpl();

        List list=simpl.serchProvice();

        //List list=simpl.serchProvice();

        Sensor_inf sinf=new Sensor_inf();

        sinf.setSensor_dev_id(291200001);

        List<Sensor_inf> list=simpl.serchByCondition(sinf);

        for (Sensor_inf s : list) {

            System.out.println(s);

        }

        System.out.println(list.size());

    }




 sensor/src/com/fgkj/dao/impl/Sensor_stateImpl.java

@@ -90,5 +90,7 @@
        // TODO Auto-generated method stub

        return null;

    }



    public static void main(String[] args) {

		
    }

}