10笔

81041

2019-06-24 e8bf28271c12e1388ca377e1b529b00c78bf5354

10笔

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

@@ -16,7 +16,13 @@
        result=tojson(model);

        return SUCCESS;

    }

	
    //实时页面最新的的10笔数据

    public String serchByInfo() {

        Sensor_hisdata sdata=getGson("yyyy-MM-dd").fromJson(json, Sensor_hisdata.class);

        ServiceModel model=service.serchByInfo(sdata);

        result=tojson(model);

        return SUCCESS;

    }

    

    

    


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

@@ -88,10 +88,45 @@
        return list;

    }



    @Override

    //实时页面最新的的10笔数据

    public List serchByInfo(Object obj) {

        // TODO Auto-generated method stub

        return null;

        Sensor_hisdata sdata=(Sensor_hisdata) obj;

        String sql=" select distinct num,sensor_dev_id,record_time,airtmp,airhum,smoke,water,lightintensity"

                + "  ,CO2concentration,COconcentration,CH4concentration,O2concentration,note "

                + "  from db_sensor_history.tb_sensor_hisdata_"+sdata.getSensor_dev_id()

                + "  where sensor_dev_id=?   "

                + "  order by record_time desc  limit 0,10";

        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{sdata.getSensor_dev_id()}, new CallBack() {

			
            @Override

            public List getResults(ResultSet rs) {

                List list=new ArrayList();

                try {

                    while(rs.next()){

                        Sensor_hisdata s=new Sensor_hisdata();

                        s.setNum(rs.getInt("num"));

                        s.setSensor_dev_id(rs.getInt("sensor_dev_id"));

                        s.setRecord_time(rs.getTimestamp("record_time"));

                        s.setAirtmp(rs.getFloat("airtmp"));

                        s.setAirhum(rs.getFloat("airhum"));

                        s.setSmoke(rs.getInt("smoke"));

                        s.setWater(rs.getInt("water"));

                        s.setLightintensity(rs.getInt("lightintensity"));

                        s.setCO2concentration(rs.getInt("cO2concentration"));

                        s.setCOconcentration(rs.getInt("cOconcentration"));

                        s.setCH4concentration(rs.getInt("cH4concentration"));

                        s.setO2concentration(rs.getInt("o2concentration"));

                        s.setNote(rs.getString("note"));

                        list.add(s);

                    }

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                return list;

            }

        });

        return list;

    }

    public static void main(String[] args) throws ParseException {

        Sensor_hisdataImpl simpl=new Sensor_hisdataImpl();

@@ -102,7 +137,8 @@
        sdata.setSensor_dev_id(291200001);

        sdata.setRecord_time(ActionUtil.getSimpDate(date2));

        sdata.setRecord_time1(ActionUtil.getSimpDate(date1));

        List list=simpl.serchByCondition(sdata);

        //List list=simpl.serchByCondition(sdata);

        List list=simpl.serchByInfo(sdata);

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

        

    }


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

@@ -28,6 +28,18 @@
        }

        return model;

    }

	
    //实时页面最新的的10笔数据

    public ServiceModel serchByInfo(Object obj) {

        List list=dao.serchByInfo(obj);

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

            model.setCode(1);

            model.setData(list);

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

        }else{

            model.setCode(0);

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

        }

        return model;

    }



}