From bbe25007af388943027ee6b630c28a2815edca73 Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.30>
Date: 星期三, 05 十二月 2018 09:51:05 +0800
Subject: [PATCH] 首页上添加续航不足图标功能
---
gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java | 34 +++++++++++++++++++++++++++++++++-
1 files changed, 33 insertions(+), 1 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java
index a4ceb31..79b8943 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java
@@ -11,6 +11,7 @@
import com.fgkj.dao.DAOHelper;
import com.fgkj.dao.LimitNumberFactory;
import com.fgkj.db.DBUtil;
+import com.fgkj.dto.BattMap_information;
import com.fgkj.dto.Batt_endurance;
import com.fgkj.dto.Page;
import com.fgkj.dto.User_inf;
@@ -210,6 +211,33 @@
}
return nums;
}
+ //鏍规嵁鏈烘埧id鏌ヨ璇ユ満鎴跨画鑸笉瓒崇殑鏁�
+ public int serchxuhangNotInThree_stationid(Object obj) {
+ BattMap_information binformation=(BattMap_information) obj;
+ String sql="select count(distinct tb_batt_endurance.deviceid) as nums from web_site.tb_batt_endurance " +
+ " where endurance_actual_timelong<180 and tb_batt_endurance.stationid=? " ;
+ List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binformation.getStationId()}, new CallBack() {
+
+ public List getResults(ResultSet rs) {
+ List list=new ArrayList();
+ try {
+ while(rs.next()){
+ int nums=rs.getInt("nums");
+ list.add(nums);
+ }
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ return list;
+ }
+ });
+ int nums=0;//缁埅涓嶈冻3灏忔椂鏁�
+ if(list!=null&&list.size()>0){
+ nums=(Integer) list.get(list.size()-1);
+ }
+ return nums;
+ }
public List serchByInfo(Object obj) {
// TODO Auto-generated method stub
return null;
@@ -240,7 +268,11 @@
System.out.println(num);
}*/
//System.out.println(list.size());
- int nums=bimpl.serchxuhangNotInThree(uinf);
+ /*int nums=bimpl.serchxuhangNotInThree(uinf);
+ System.out.println(nums);*/
+ BattMap_information binformation=new BattMap_information();
+ binformation.setStationId("42000530");
+ int nums=bimpl.serchxuhangNotInThree_stationid(binformation);
System.out.println(nums);
}
--
Gitblit v1.9.1