| | |
| | | //-----------查询电池组信息 |
| | | public List serchAllBattinf(Object obj) { |
| | | BattInf binf = (BattInf) obj; |
| | | String sql = " select DISTINCT StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationId,stationid_ex,StationIP,FBSDeviceId,BattGroupName,BattGroupName1,BattGroupName2,MonCount,battgroupId,MonCapStd,MonVolStd,MonResStd,MonSerStd,BattModel,BattProducer,BattProductDate,BattInUseDate,GroupIndexInFBSDevice,Load_curr,DisCurrMax " + |
| | | String sql = " select DISTINCT StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationId,stationid_ex,StationIP,FBSDeviceId,BattGroupName,BattGroupName1,BattGroupName2,MonCount,battgroupId,MonCapStd,MonVolStd,MonResStd,MonSerStd,BattModel,BattProducer,BattProductDate,BattInUseDate,GroupIndexInFBSDevice,Load_curr,DisCurrMax,PackCount " + |
| | | " from db_battinf.tb_battinf where StationName1 like ? and StationName2 like ? and StationName5 like ? " |
| | | + " and StationName3=? " |
| | | + " ORDER BY StationName4 asc,battgroupId asc "; |
| | |
| | | batt.setGroupIndexInFBSDevice(rs.getInt("groupIndexInFBSDevice")); |
| | | batt.setLoad_curr(rs.getFloat("load_curr")); |
| | | batt.setDisCurrMax(rs.getFloat("disCurrMax")); |
| | | batt.setPackCount(rs.getInt("PackCount")); |
| | | list.add(batt); |
| | | } |
| | | } catch (SQLException e) { |