| | |
|---|
| | | " db_battinf.tb_battinf.stationName,db_battinf.tb_battinf.stationName5,db_battinf.tb_battinf.FbsDeviceName " +
|
|---|
| | | " FROM db_alarm.tb_devalarm_data,db_battinf.tb_battinf " +
|
|---|
| | | " WHERE " +
|
|---|
| | | " tb_devalarm_data.dev_id=db_battinf.tb_battinf.FbsDeviceId " ;
|
|---|
| | | " tb_devalarm_data.dev_id=db_battinf.tb_battinf.FbsDeviceId and tb_battinf.station_intall=1 " ;
|
|---|
| | | //设备实时告警
|
|---|
| | | String alarmTypeSql=" AND alm_cleared_type=0 ";
|
|---|
| | | baseSql+=alarmTypeSql;
|
|---|
| | |
|---|
| | | //分页
|
|---|
| | | String limitSql=" LIMIT ?,? ";
|
|---|
| | | sql=baseSql+endSql+limitSql;
|
|---|
| | | List<Batt_devalarm_data> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{ddata.getStationName1(),ddata.getStationName(),ddata.getStationName2(),ddata.getAlm_type(),uinf.getUId(),(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
|
|---|
| | | List<Batt_devalarm_data> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{ddata.getStationName1(),ddata.getStationName(),ddata.getStationName2(),ddata.getStationName5(),ddata.getAlm_type(),uinf.getUId(),(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | | List list=new ArrayList();
|
|---|
