| | |
|---|
| | | //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,"
|
|---|
| | | String sql=" select distinct(db_battinf.tb_battinf.StationId),StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,"
|
|---|
| | | + "FBSDeviceName,battGroupNum" +
|
|---|
| | | ",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,Load_curr,DisCurrMax,montmpstd,floatVolLevel,offlineVolLevel,battFloatCurrent"
|
|---|
| | | + ",db_ram_db.tb_fbs9100_state.dev_version "
|
|---|
| | |
|---|
| | | //+ " limit ?,? ";StationName1 like ? and StationName2 like ? and StationName3 like ? and StationName5 like ? "
|
|---|
| | | //,(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize(),"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName3()+"%",
|
|---|
| | | //条件
|
|---|
| | | String sql0=" and stationid=? "; //具体机房
|
|---|
| | | String sql0=" and db_battinf.tb_battinf.stationid=? "; //具体机房
|
|---|
| | | String sql1=" and stationname1=? ";//省
|
|---|
| | | String sql2=" and stationname2=? ";//市
|
|---|
| | | String sql5=" and stationname5=? ";//区县
|
|---|
| | |
|---|
| | | //+ " limit ?,? ";StationName1 like ? and StationName2 like ? and StationName3 like ? and StationName5 like ? "
|
|---|
| | | //,(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize(),"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName3()+"%",
|
|---|
| | | //条件
|
|---|
| | | String sql0=" and stationid=? "; //具体机房
|
|---|
| | | String sql0=" and db_battinf.tb_battinf.stationid=? "; //具体机房
|
|---|
| | | String sql1=" and stationname1=? ";//省
|
|---|
| | | String sql2=" and stationname2=? ";//市
|
|---|
| | | String sql5=" and stationname5=? ";//区县
|
|---|
| | |
|---|
| | |
|
|---|
| | | BattInfImpl biml = new BattInfImpl();
|
|---|
| | | BattInf binf = new BattInf();
|
|---|
| | | binf.setNum(2);
|
|---|
| | | binf.setNum(0);
|
|---|
| | | binf.setBattGroupId(1000001);
|
|---|
| | | binf.setStationName("百色");
|
|---|
| | | binf.setStationName("42000611");
|
|---|
| | | binf.setStationName1("");
|
|---|
| | | binf.setStationName2("");
|
|---|
| | | binf.setStationName3("");
|
|---|
