From e8bf28271c12e1388ca377e1b529b00c78bf5354 Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期一, 24 六月 2019 10:51:43 +0800
Subject: [PATCH] 10笔
---
sensor/src/com/fgkj/dao/impl/Sensor_hisdataImpl.java | 44 ++++++++++++++++++++++++++++++++++++++++----
1 files changed, 40 insertions(+), 4 deletions(-)
diff --git a/sensor/src/com/fgkj/dao/impl/Sensor_hisdataImpl.java b/sensor/src/com/fgkj/dao/impl/Sensor_hisdataImpl.java
index 4e64920..6292b5f 100644
--- a/sensor/src/com/fgkj/dao/impl/Sensor_hisdataImpl.java
+++ b/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());
}
--
Gitblit v1.9.1