| | |
|---|
| | | //根据设备id查询机房名称 |
|---|
| | | public List serchByInfo(Object obj) { |
|---|
| | | BattInf binf=(BattInf) obj; |
|---|
| | | String sql="select distinct db_battinf.tb_battinf.FBSDeviceId,stationName3,stationName " |
|---|
| | | String sql="select distinct db_battinf.tb_battinf.FBSDeviceId,stationName3,stationName,FbsDeviceIp,db_battinf.tb_battinf.FBSDeviceName " |
|---|
| | | + " ,battProducer,monCount,monVolStd,monResStd,monCapStd,battModel " |
|---|
| | | + " FROM db_battinf.tb_battinf " |
|---|
| | | + " where FBSDeviceId=? "; |
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getFBSDeviceId()}, new CallBack() { |
|---|
| | |
|---|
| | | binf.setStationName(rs.getString("stationName"));; |
|---|
| | | binf.setStationName3(rs.getString("stationName3")); |
|---|
| | | binf.setFBSDeviceId(rs.getInt("FBSDeviceId")); |
|---|
| | | |
|---|
| | | binf.setFbsDeviceIp(rs.getString("FbsDeviceIp")); |
|---|
| | | binf.setFBSDeviceName(rs.getString("fBSDeviceName")); |
|---|
| | | binf.setBattProducer(rs.getString("battProducer")); |
|---|
| | | binf.setMonCount(rs.getInt("monCount")); |
|---|
| | | binf.setMonVolStd(rs.getFloat("monVolStd")); |
|---|
| | | binf.setMonResStd(rs.getFloat("monResStd")); |
|---|
| | | binf.setMonCapStd(rs.getFloat("monCapStd")); |
|---|
| | | binf.setBattModel(rs.getString("battModel")); |
|---|
| | | list.add(binf); |
|---|
| | | } |
|---|
| | | } catch (SQLException e) { |
|---|
