| | |
|---|
| | | String numberSql="SELECT FOUND_ROWS() number";//存放总数
|
|---|
| | | Connection conn=DBUtil.getConn();//sql和numberSql共用一个connection
|
|---|
| | | String baseSql = "select SQL_CALC_FOUND_ROWS distinct(db_alarm.tb_battalarm_data_history.BattGroupId),db_alarm.tb_battalarm_data_history.num,alm_signal_id,db_alarm.tb_battalarm_data_history.monnum,alm_value,alm_level,alm_is_confirmed,alm_confirmed_time,alm_start_time,alm_end_time, " +
|
|---|
| | | " stationname,battgroupname" +
|
|---|
| | | " stationname,stationname5,battgroupname" +
|
|---|
| | | " from db_alarm.tb_battalarm_data_history,db_battinf.tb_battinf " +
|
|---|
| | | " where alm_id in(?,?,?,?,?,?) and alm_signal_id%2 in(?,?) " +
|
|---|
| | | " and alm_level in(?,?,?,?) " +
|
|---|
| | | " and alm_start_time>=? and alm_start_time<=? " +
|
|---|
| | | " and db_battinf.tb_battinf.stationname1 like ? and db_battinf.tb_battinf.stationname like ? ";
|
|---|
| | | " and db_battinf.tb_battinf.stationname1 like ? and db_battinf.tb_battinf.stationname like ? and db_battinf.tb_battinf.stationname2 like ? and db_battinf.tb_battinf.stationname5 like ? ";
|
|---|
| | | /*//用于实时告警
|
|---|
| | | String almSqlT="and alm_cleared_type=? ";
|
|---|
| | | //历史告警
|
|---|
| | |
|---|
| | | adata_H.getAlm_start_time1(),
|
|---|
| | | "%"+binf.getStationName1()+"%",
|
|---|
| | | "%"+binf.getStationName()+"%",
|
|---|
| | | "%"+binf.getStationName2()+"%",
|
|---|
| | | "%"+binf.getStationName5()+"%",
|
|---|
| | | //adata_H.getAlm_cleared_type(),
|
|---|
| | |
|
|---|
| | |
|
|---|
| | |
|---|
| | | Batt_Maint_Dealarm bmd = new Batt_Maint_Dealarm();
|
|---|
| | | BattInf binf = new BattInf();
|
|---|
| | | binf.setStationName(rs.getString("stationName"));
|
|---|
| | | binf.setStationName5(rs.getString("stationName5"));
|
|---|
| | | binf.setBattGroupName(rs.getString("battGroupName"));
|
|---|
| | |
|
|---|
| | | Battalarm_data_history adata_H = new Battalarm_data_history();
|
|---|
