| | |
|---|
| | | @Override
|
|---|
| | | public List serchByCondition(Object obj) {
|
|---|
| | | Sensor_inf sinf=(Sensor_inf) obj;
|
|---|
| | | String sql=" select distinct sensor_dev_id,num,province,city,county,device_name "
|
|---|
| | | 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 sensor_dev_id=? ";
|
|---|
| | | List list=(List) DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{sinf.getSensor_dev_id()}, new CallBack() {
|
|---|
| | |
|---|
| | | 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);
|
|---|
| | | }
|
|---|
