| | |
| | | //首页上根据stationid查询电池组的机历卡
|
| | | public List serchBattAllInfoByStationId(Object obj){
|
| | | BattInf binf=(BattInf) obj;
|
| | | String sql="select * from db_battinf.tb_battinf,db_battinf.tb_battinf_ex " +
|
| | | " where db_battinf.tb_battinf.stationId=db_battinf.tb_battinf_ex.stationid " +
|
| | | " and db_battinf.tb_battinf.stationId=? " +
|
| | | String sql="select * from db_battinf.tb_battinf " +
|
| | | " left outer join db_battinf.tb_battinf_ex on db_battinf.tb_battinf.stationId=db_battinf.tb_battinf_ex.stationid " +
|
| | | " where db_battinf.tb_battinf.stationId=? " +
|
| | | " order by db_battinf.tb_battinf.battgroupid";
|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getStationId()}, new CallBack() {
|
| | |
|
| | |
| | | binf.setStationName3("");
|
| | | binf.setBattGroupName("");
|
| | | binf.setBattProducer("1");
|
| | | binf.setStationId("42000002");
|
| | | binf.setStationId("42000575");
|
| | | User_inf uinf=new User_inf();
|
| | | uinf.setUId(1002);
|
| | |
|
| | |
| | | //List<BattInf> list=biml.serchGroupByInfor(binf);
|
| | | //List<BattInf> list=biml.searchInform1(bmd);
|
| | | //<BattInf> list=biml.serchStationName5(binf);
|
| | | //List<BattInf> list=biml.serchBattAllInfoByStationId(binf);
|
| | | List<BattInf> list=biml.searchInform_ky();
|
| | | List<BattInf> list=biml.serchBattAllInfoByStationId(binf);
|
| | | //List<BattInf> list=biml.searchInform_ky();
|
| | | for (BattInf b : list) {
|
| | | System.out.println(b);
|
| | | }
|