| | |
|---|
| | | " alm_low_level,alm_high_en,alm_low_en," +
|
|---|
| | | " 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 " ;
|
|---|
| | | " where db_param.tb_dev_param.dev_id=db_battinf.tb_battinf.FBSDeviceId " +
|
|---|
| | | " and StationName1 like ? and StationName2 like ? and StationName 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.getDev_id(),dparam.getAlm_id()}, new CallBack() {
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{"%"+dparam.getStationName1()+"%","%"+dparam.getStationName2()+"%","%"+dparam.getStationName()+"%",dparam.getDev_id(),dparam.getAlm_id()}, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | | List list=new ArrayList();
|
|---|
