1

81041

2019-06-24 edbb243cb95ece8c6c6df68e7a886d4b9a9a8863

1

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

@@ -2,9 +2,13 @@


import java.sql.ResultSet;

import java.sql.SQLException;

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Date;

import java.util.List;



import com.fgkj.actions.ActionUtil;

import com.fgkj.dao.BaseDAO;

import com.fgkj.dao.CallBack;

import com.fgkj.dao.DAOHelper;

@@ -49,8 +53,9 @@
        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 asc ";

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

                + "  where sensor_dev_id=?  and  record_time>=? and record_time<=? "

                + "  order by record_time asc ";

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

            

            @Override

            public List getResults(ResultSet rs) {

@@ -88,10 +93,15 @@
        // TODO Auto-generated method stub

        return null;

    }

    public static void main(String[] args) {

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

        Sensor_hisdataImpl simpl=new Sensor_hisdataImpl();

        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

        Date date1 = sdf.parse("2000-01-01");

        Date date2 = sdf.parse("2020-01-01");

        Sensor_hisdata sdata=new Sensor_hisdata();

        sdata.setSensor_dev_id(291200001);

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

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

        List list=simpl.serchByCondition(sdata);

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

        


 sensor/src/com/fgkj/dto/Sensor_hisdata.java

@@ -7,6 +7,7 @@
    private int num;

    private int sensor_dev_id;

    private Date record_time;

    private Date record_time1;

    private float airtmp;

    private float airhum;

    private int  smoke;

@@ -95,12 +96,19 @@
    public void setNote(String note) {

        this.note = note;

    }

    public Date getRecord_time1() {

        return record_time1;

    }

    public void setRecord_time1(Date record_time1) {

        this.record_time1 = record_time1;

    }

    @Override

    public String toString() {

        return "Sensor_hisdata [num=" + num + ", sensor_dev_id="

                + sensor_dev_id + ", record_time=" + record_time + ", airtmp="

                + airtmp + ", airhum=" + airhum + ", smoke=" + smoke

                + ", water=" + water + ", lightintensity=" + lightintensity

                + sensor_dev_id + ", record_time=" + record_time

                + ", record_time1=" + record_time1 + ", airtmp=" + airtmp

                + ", airhum=" + airhum + ", smoke=" + smoke + ", water="

                + water + ", lightintensity=" + lightintensity

                + ", CO2concentration=" + CO2concentration

                + ", COconcentration=" + COconcentration

                + ", CH4concentration=" + CH4concentration