From 8410662678ad065a8b270a9c9cbdfde8461f424d Mon Sep 17 00:00:00 2001
From: hdw <496960745@qq.com>
Date: 星期二, 11 十二月 2018 13:22:05 +0800
Subject: [PATCH] 自动获取最大设备id
---
gx_tieta/src/com/fgkj/dao/impl/Batt_rtdataDAOImpl.java | 41 ++++++++++++++++++++++++++++++++++++++++-
1 files changed, 40 insertions(+), 1 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/Batt_rtdataDAOImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Batt_rtdataDAOImpl.java
index 9c8609e..9225c89 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/Batt_rtdataDAOImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/Batt_rtdataDAOImpl.java
@@ -65,6 +65,39 @@
}
});
}
+ //瀹炴椂鐩戞祴<-------璺ㄥ煙----------->
+ public List serchByCondition_ky(Object obj) {
+ Batt_rtdata br=(Batt_rtdata)obj;
+ String sql="select num,BattGroupId,rec_datetime,mon_num,mon_vol,mon_tmp,mon_res,mon_ser,mon_conn_res,mon_cap,mon_JH_curr from db_ram_db.tb_batt_rtdata where BattGroupId=? order by mon_num";
+ return DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{br.getBattGroupId()}, new CallBack() {
+
+ public List getResults(ResultSet rs) {
+ List list=new ArrayList();
+ try {
+ while(rs.next()){
+ Batt_rtdata rtdata=new Batt_rtdata();
+ rtdata.setNum(rs.getInt("num"));
+ rtdata.setBattGroupId(rs.getInt("BattGroupId"));
+ rtdata.setRec_datetime(rs.getDate("rec_datetime"));
+ rtdata.setMon_num(rs.getInt("mon_num"));
+ rtdata.setMon_vol(rs.getFloat("mon_vol"));
+ rtdata.setMon_tmp(rs.getFloat("mon_tmp"));
+ rtdata.setMon_res(rs.getFloat("mon_res"));
+ rtdata.setMon_ser(rs.getFloat("mon_ser"));
+ rtdata.setMon_conn_res(rs.getFloat("mon_conn_res"));
+ rtdata.setMon_cap(rs.getFloat("mon_cap"));
+ rtdata.setMon_JH_curr(rs.getFloat("mon_JH_curr"));
+ //System.out.println(rtdata);
+ list.add(rtdata);
+ }
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+
+ return list;
+ }
+ });
+ }
// 鐢垫睜缁勫崟浣撴渶澶у�煎拰鏈�灏忓��
public List serchByInfo(Object obj) {
BattInf binf=(BattInf)obj;
@@ -167,7 +200,13 @@
//binf.setBattGroupId(1000007);
binf.setFBSDeviceId(910000001);
binf.setGroupIndexInFBSDevice(0);
- List<Batt_rtdata> list=bimpl.serchByThirdBatt(binf);
+ /*List<Batt_rtdata> list=bimpl.serchByThirdBatt(binf);
+ for (Batt_rtdata b : list) {
+ System.out.println(b);
+ }*/
+ Batt_rtdata br=new Batt_rtdata();
+ br.setBattGroupId(1002101);
+ List<Batt_rtdata> list=bimpl.serchByCondition_ky(br);
for (Batt_rtdata b : list) {
System.out.println(b);
}
--
Gitblit v1.9.1