| | |
| | | private String json;
|
| | | private String result;
|
| | |
|
| | | |
| | | //修改告警值
|
| | | public String replaceAlarm(){
|
| | | Sensor_inf sinf=ActionUtil.getGson().fromJson(json, Sensor_inf.class);
|
| | | ServiceModel model=service.replaceAlarm(sinf);
|
| | | result=tojson(model);
|
| | | return SUCCESS;
|
| | | }
|
| | | |
| | | //查询所有的省份(一级)
|
| | | public String serchProvice(){
|
| | | ServiceModel model=service.serchProvice();
|
| | |
| | | boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{sinf.getSensor_dev_id(),sinf.getProvince(),sinf.getCity(),sinf.getCounty(),sinf.getDevice_name()});
|
| | | return bl;
|
| | | }
|
| | | //删除信息
|
| | | |
| | | //修改告警值
|
| | | public boolean replaceAlarm(Object obj){
|
| | | Sensor_inf sinf=(Sensor_inf) obj;
|
| | | String sql=" repalce into db_sensor.tb_sensor_inf(sensor_dev_id,airtmp_alarm,airhum_alarm,smoke_alarm)"
|
| | | + " values(?,?,?,?)";
|
| | | boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{sinf.getSensor_dev_id(),
|
| | | sinf.getAirtmp_alarm(),sinf.getAirhum_alarm(),sinf.getSmoke_alarm()});
|
| | | return bl;
|
| | | }
|
| | | //删除信息
|
| | | @Override
|
| | | public boolean del(Object obj) {
|
| | | Sensor_inf sinf=(Sensor_inf) obj;
|
| | |
| | |
|
| | | import com.fgkj.dao.BaseDAO;
|
| | | import com.fgkj.dao.BaseDAOFactory;
|
| | | import com.fgkj.dao.DAOHelper;
|
| | | import com.fgkj.dao.impl.Sensor_infImpl;
|
| | | import com.fgkj.db.DBUtil;
|
| | | import com.fgkj.dto.Sensor_inf;
|
| | | import com.fgkj.dto.ServiceModel;
|
| | |
|
| | | public class Sensor_infService {
|
| | |
| | | dao=BaseDAOFactory.getBaseDAO(BaseDAO.SENSOR_INF);
|
| | | model=new ServiceModel();
|
| | | }
|
| | | //修改告警值
|
| | | public ServiceModel replaceAlarm(Object obj){
|
| | | boolean bl=((Sensor_infImpl)dao).replaceAlarm(obj);
|
| | | if(bl){
|
| | | model.setCode(1);
|
| | | model.setMsg("修改成功!");
|
| | | }else{
|
| | | model.setCode(0);
|
| | | model.setMsg("修改失败!");
|
| | | }
|
| | | return model;
|
| | | }
|
| | | |
| | | //查询所有的省份(一级)
|
| | | public ServiceModel serchProvice(){
|
| | | List list=((Sensor_infImpl)dao).serchProvice();
|