| | |
| | | + "FBSDeviceName,GroupIndexInFBSDevice,battgroupId,BattGroupNum,BattGroupName,FloatVolLevel,OfflineVolLevel,BattFloatCurrent" +
|
| | | ",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,MonVolLowToAvg,BattProducer,BattModel,BattProductDate,BattInUseDate " +
|
| | | " From db_battinf.tb_battinf " +
|
| | | " Where StationName like ? and StationName1 like ? " +
|
| | | " Where StationName like ? and StationName1 like ? and StationName2 like ? " +
|
| | | " order by StationId " +
|
| | | " limit ?,?";
|
| | | List<BattInf> list=DAOHelper.executeQueryLimit(sql,conn, new Object[]{"%"+binf.getStationName()+"%","%"+binf.getStationName1()+"%",(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()},new CallBack() {
|
| | | List<BattInf> list=DAOHelper.executeQueryLimit(sql,conn, new Object[]{"%"+binf.getStationName()+"%","%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%",(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()},new CallBack() {
|
| | |
|
| | | public List getResults(ResultSet rs) {
|
| | | List list = new ArrayList<BattInf>();
|
| | |
| | | // batt.setStationName(rs.getString("StationName"));
|
| | | batt.setBattGroupName(rs.getString("battGroupName"));
|
| | | batt.setMonCount(rs.getInt("monCount"));
|
| | | batt.setMonNum(Integer.parseInt(rs.getString("signalname").split("#")[0]));
|
| | | //batt.setMonNum(Integer.parseInt(rs.getString("signalname").split("#")[0]));
|
| | | //System.out.println(batt);
|
| | | list.add(batt);
|
| | | }
|
| | |
| | |
|
| | | BattInfImpl biml = new BattInfImpl();
|
| | | BattInf binf = new BattInf();
|
| | | binf.setBattGroupId(0);
|
| | | binf.setBattGroupId(1000967);
|
| | | binf.setStationName("内蒙古");
|
| | | binf.setStationName1("内蒙古");
|
| | |
|
| | |
| | | bmd.setUinf(uinf);
|
| | | //List<BattInf> list = biml.serchByConditionNew(bmd);
|
| | | //List<BattInf> list=biml.serchByTestType(bmd);
|
| | | List<BattInf> list=biml.serchGroupAssess(bmd);
|
| | | //List<BattInf> list=biml.serchGroupAssess(bmd);
|
| | | List<BattInf> list=biml.serchByMonNum(binf);
|
| | | for (BattInf b : list) {
|
| | | System.out.println(b);
|
| | | }
|