| | |
| | | " from db_battinf.tb_battinf " +
|
| | | " left outer join (select * from db_battinf.tb_battinf_rebuild where tb_battinf_rebuild.rebuild_clear_type=1 ) as battinf_re " +
|
| | | " on BattGroupId=battinf_re.new_battgroupid or BattGroupId=battinf_re.old_battgroupid " +
|
| | | " where stationname1 like ? and stationname2 like ? and stationname3 like ? and battgroupname like ? ";
|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName3()+"%","%"+binf.getStationName4()+"%"}, new CallBack() {
|
| | | " where stationname1 like ? and stationname2 like ? and stationname3 like ? and battgroupname like ? and battgroupid=? ";
|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName3()+"%","%"+binf.getBattGroupName()+"%",binf.getBattGroupId()}, new CallBack() {
|
| | |
|
| | | public List getResults(ResultSet rs) {
|
| | | List<BattInf> list=new ArrayList();
|
| | |
| | |
|
| | | BattInfImpl biml = new BattInfImpl();
|
| | | BattInf binf = new BattInf();
|
| | | binf.setBattGroupId(1000967);
|
| | | binf.setBattGroupId(1000001);
|
| | | binf.setStationName("");
|
| | | binf.setStationName1("");
|
| | | binf.setStationName2("");
|
| | | binf.setStationName3("武汉源暢实验室1");
|
| | | binf.setBattGroupName("");
|
| | | binf.setBattProducer("1");
|
| | | User_inf uinf=new User_inf();
|
| | | uinf.setUId(1002);
|
| | |
| | | //List<BattInf> list = biml.serchByConditionNew(bmd);
|
| | | //List<BattInf> list=biml.serchByTestType(bmd);
|
| | | //List<BattInf> list=biml.serchGroupAssess(bmd);
|
| | | List<BattInf> list=biml.serchMakeGroup(binf);
|
| | | //List<BattInf> list=biml.serchMakeGroup(binf);
|
| | | List<BattInf> list=biml.serchGroupByInfor(binf);
|
| | | for (BattInf b : list) {
|
| | | System.out.println(b);
|
| | | }
|