String service;
String serviceStateDetail;
Timestamp stateLoggedTime;
Timestamp detailLoggedTime;
ServiceStateDetailInfoBean serviceStateDetailInfoBean;
try {
while (rs.next()) {
serviceStateDetailInfoBean = new ServiceStateDetailInfoBean();
service = rs.getString(StatusMonitorConstants.SERVICE_WSL_NAME);
stateLoggedTime = rs.getTimestamp(StatusMonitorConstants.SERVICE_STATE_WSL_TIMESTAMP);
detailLoggedTime =
rs.getTimestamp(StatusMonitorConstants.SERVICE_STATE_DETAIL_WSL_TIMESTAMP);
serviceStateDetail = rs.getString(StatusMonitorConstants.SERVICE_STATE_DETAIL);
serviceStateDetailInfoBean.setService(service);
serviceStateDetailInfoBean.setStateLoggedTime(stateLoggedTime.getTime());
serviceStateDetailInfoBean.setServiceStateDetail(serviceStateDetail);
serviceStateDetailInfoBean.setDetailLoggedTime(detailLoggedTime.getTime());
stateDetailList.add(serviceStateDetailInfoBean);
}
} catch (SQLException e) {
String msg = "Getting the serviceID failed";