| | |
|---|
| | | //批量设置放电参数时，根据省市区，电池单体型号（伏数），组数筛选出电池组
|
|---|
| | | public List serchByDischarge(Object obj) {
|
|---|
| | | BattInf binf=(BattInf) obj;
|
|---|
| | | Page page=binf.getPage();
|
|---|
| | | //Page page=binf.getPage();
|
|---|
| | | /*Connection conn=DBUtil.getConn();
|
|---|
| | | String numberSql=" SELECT FOUND_ROWS() number";SQL_CALC_FOUND_ROWS*/
|
|---|
| | | String sql=" select distinct(StationId),StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,"
|
|---|
| | | + "FBSDeviceName,GroupIndexInFBSDevice,db_battinf.tb_battinf.battgroupId,battGroupName" +
|
|---|
| | | + "FBSDeviceName,GroupIndexInFBSDevice,db_battinf.tb_battinf.battgroupId,battGroupName,battGroupNum" +
|
|---|
| | | ",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,Load_curr,DisCurrMax"
|
|---|
| | | + ",db_ram_db.tb_fbs9100_state.dev_version "
|
|---|
| | | + " from db_battinf.tb_battinf,db_ram_db.tb_fbs9100_state "
|
|---|
| | |
|---|
| | | try {
|
|---|
| | | while(rs.next()) {
|
|---|
| | | BattInf binf = new BattInf();
|
|---|
| | | binf.setNum(0);
|
|---|
| | | binf.setStationId(rs.getString("stationId"));
|
|---|
| | | binf.setStationName(rs.getString("stationName"));
|
|---|
| | | binf.setStationName1(rs.getString("stationName1"));
|
|---|
| | |
|---|
| | | binf.setFBSDeviceName(rs.getString("fBSDeviceName"));
|
|---|
| | | binf.setGroupIndexInFBSDevice(rs.getInt("groupIndexInFBSDevice"));
|
|---|
| | | binf.setBattGroupId(rs.getInt("battGroupId"));
|
|---|
| | | binf.setBattGroupNum(rs.getInt("battGroupNum"));
|
|---|
| | | binf.setBattGroupName(rs.getString("battGroupName"));
|
|---|
| | | /*binf.setBattGroupNum(rs.getInt("battGroupNum"));
|
|---|
| | | binf.setFloatVolLevel(rs.getFloat("floatVolLevel"));
|
|---|
| | |
|---|
| | | }*/
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | |
|---|
| | | public static void main(String[] args) throws ParseException {
|
|---|
| | | //new BattInfImpl().searchAll();
|
|---|
| | |
|
|---|
