From 63c1c105547c97bfe338c625fb53c0fe2ab7ff2e Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期一, 24 十二月 2018 10:03:57 +0800
Subject: [PATCH] 查询出SD卡的状态
---
gx_tieta/src/com/fgkj/dao/impl/ram/Bts_station_stateImpl.java | 42 ++++++++++++++++++++++++++++++++++++++----
1 files changed, 38 insertions(+), 4 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/ram/Bts_station_stateImpl.java b/gx_tieta/src/com/fgkj/dao/impl/ram/Bts_station_stateImpl.java
index bf9c9c2..53ec2d7 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/ram/Bts_station_stateImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/ram/Bts_station_stateImpl.java
@@ -301,6 +301,40 @@
}
return nums;
}
+
+ //鏌ヨ璁惧SD鍗＄殑瀹炴椂鐘舵��
+ public int serchSDCard(Object obj) {
+ BattInf binf=(BattInf) obj;
+ String sql=" select distinct station_stat from db_ram_db.tb_bts_station_state where station_id=? ";
+ List list=DAOHelper.executeQuery(sql, DBUtil.getConn(),new Object[] {binf.getStationId()} , new CallBack() {
+
+ @Override
+ public List getResults(ResultSet rs) {
+ List list=new ArrayList();
+ try {
+ while(rs.next()) {
+ int station_stat=rs.getInt("station_stat");
+ if((station_stat&1024)>1) {
+ list.add(1);
+ }else {
+ list.add(0);
+ }
+ }
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ return list;
+ }
+ });
+ int station_stat=1;
+ if(list!=null&&list.size()>0) {
+ station_stat=(int) list.get(list.size()-1);
+ }
+ return station_stat;
+ }
+
+
public List serchByInfo(Object obj) {
// TODO Auto-generated method stub
return null;
@@ -313,7 +347,7 @@
binf.setStationName2("");
binf.setStationName3("");
binf.setStationName5("");
- binf.setStationId("");
+ binf.setStationId("42000603");
binf.setBattGroupNum(62);
User_inf uinf=new User_inf();
uinf.setUId(1002);
@@ -331,12 +365,12 @@
/*BattMap_information bm=new BattMap_information();
bm.setStationId("42000570");
int nums=bimpl.serchByStationId(bm);*/
- int nums=bimpl.serchByState_diaozhan(uinf);
+ //int nums=bimpl.serchByState_diaozhan(uinf);
/*BattMap_information bm=new BattMap_information();
bm.setStationId("42000366");
int nums=bimpl.serchByStationId_diaozhan(bm);*/
-
- System.out.println(nums);
+ int station_state=bimpl.serchSDCard(binf);
+ System.out.println(station_state);
}
--
Gitblit v1.9.1