导出通用表格数据

whyclj

2019-06-29 83467fc92a2a945522cf4a6ebb28f86b41715be2

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

@@ -27,7 +27,7 @@
   @Override

   public boolean update(Object obj) {

      Sensor_inf sinf=(Sensor_inf) obj;

      String sql=" repalce into db_sensor.tb_sensor_inf(sensor_dev_id,province,city,county,device_name)"

      String sql=" replace into db_sensor.tb_sensor_inf(sensor_dev_id,province,city,county,device_name)"

            + "  values(?,?,?,?,?)";

      boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{sinf.getSensor_dev_id(),sinf.getProvince(),sinf.getCity(),sinf.getCounty(),sinf.getDevice_name()});

      return bl;

@@ -36,10 +36,9 @@
   //修改告警值

   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()});

      String sql=" update db_sensor.tb_sensor_inf set airtmp_alarm=?,airhum_alarm=?,smoke_alarm=? where sensor_dev_id=? ";

      boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{

         sinf.getAirtmp_alarm(),sinf.getAirhum_alarm(),sinf.getSmoke_alarm(),sinf.getSensor_dev_id()});

      return bl;

   }

   //删除信息

@@ -209,11 +208,16 @@
      //List list=simpl.serchProvice();

      Sensor_inf sinf=new Sensor_inf();

      sinf.setSensor_dev_id(291200001);

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

      sinf.setAirtmp_alarm(34.4f);

      sinf.setAirhum_alarm(70.4f);

      sinf.setSmoke_alarm(1000);

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

      for (Sensor_inf s : list) {

         System.out.println(s);

      }

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

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

      boolean bl=simpl.replaceAlarm(sinf);

      System.out.println(bl);

   }