| | |
|---|
| | | " db_battinf.tb_battinf.stationname " +
|
|---|
| | | " from db_param.tb_dev_param,db_battinf.tb_battinf " +
|
|---|
| | | " where db_param.tb_dev_param.dev_id=db_battinf.tb_battinf.FBSDeviceId " +
|
|---|
| | | " and db_battinf.tb_battinf.StationName1 like ? and db_battinf.tb_battinf.StationName2 like ? and db_battinf.tb_battinf.StationName like ? " ;
|
|---|
| | | " and db_battinf.tb_battinf.StationName1 like ? and db_battinf.tb_battinf.StationName2 like ? and db_battinf.tb_battinf.StationName like ? and db_battinf.tb_battinf.StationName5 like ? " ;
|
|---|
| | | //设备id条件
|
|---|
| | | String devSqlT=" and dev_id=? ";
|
|---|
| | | String devSqlF=" and dev_id!=? ";
|
|---|
| | |
|---|
| | | String endSql=" order by db_param.tb_dev_param.num asc ";
|
|---|
| | | //最终的SQl
|
|---|
| | | sql=baseSql+endSql;
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{"%"+dparam.getStationName1()+"%","%"+dparam.getStationName2()+"%","%"+dparam.getStationName()+"%",dparam.getDev_id(),dparam.getAlm_id()}, new CallBack() {
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{"%"+dparam.getStationName1()+"%","%"+dparam.getStationName2()+"%","%"+dparam.getStationName()+"%","%"+dparam.getStationName5()+"%",dparam.getDev_id(),dparam.getAlm_id()}, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | | List list=new ArrayList();
|
|---|
