From edbb243cb95ece8c6c6df68e7a886d4b9a9a8863 Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期一, 24 六月 2019 09:34:38 +0800
Subject: [PATCH] 1
---
sensor/src/com/fgkj/dao/impl/Sensor_hisdataImpl.java | 16 +++++++++++++---
1 files changed, 13 insertions(+), 3 deletions(-)
diff --git a/sensor/src/com/fgkj/dao/impl/Sensor_hisdataImpl.java b/sensor/src/com/fgkj/dao/impl/Sensor_hisdataImpl.java
index a29f47f..4e64920 100644
--- a/sensor/src/com/fgkj/dao/impl/Sensor_hisdataImpl.java
+++ b/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());
--
Gitblit v1.9.1