@Override
public ArrayList<ResultDTO> getAllResult(Boolean getInActive) {
Connection connection = null;
PreparedStatement stm = null;
ArrayList<ResultDTO> resultData = new ArrayList<ResultDTO>();
try {
connection = BaseDAO.getConnect();
if (getInActive == false) {
stm =
connection.prepareStatement(
"SELECT resultID, uploadedImage, listTraffic, creator, createDate, isActive FROM result WHERE isActive = ? ORDER BY resultID DESC");
stm.setBoolean(1, true);
} else {
stm =
connection.prepareStatement(
"SELECT resultID, uploadedImage, listTraffic, creator, createDate, isActive FROM result ORDER BY resultID DESC");
}
ResultSet rs = stm.executeQuery();
while (rs.next()) {
ResultDTO resultObject = new ResultDTO();
resultObject.setResultID(rs.getInt("resultID"));
resultObject.setUploadedImage(rs.getString("uploadedImage"));
resultObject.setListTraffic(rs.getString("listTraffic"));
resultObject.setCreator(rs.getString("creator"));
Timestamp tempTimeStamp = rs.getTimestamp("createDate");
Date tempDate = new Date(tempTimeStamp.getTime());
resultObject.setCreateDate(tempDate);
resultObject.setIsActive(rs.getBoolean("isActive"));
resultData.add(resultObject);
}
return resultData;
} catch (Exception e) {
e.printStackTrace();
} finally {
if (stm != null) {
try {
stm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return resultData;
}
public ResultDTO getResultByID(int id) {
Connection connection = null;
PreparedStatement stm = null;
ResultDTO resultData = new ResultDTO();
try {
connection = BaseDAO.getConnect();
stm =
connection.prepareStatement(
"SELECT uploadedImage,listTraffic,creator,createDate,isActive FROM trafficdb.result WHERE resultID=? ORDER BY resultID DESC");
stm.setInt(1, id);
ResultSet rs = stm.executeQuery();
if (rs.next()) {
resultData.setResultID(id);
resultData.setUploadedImage(rs.getString("uploadedImage"));
resultData.setListTraffic(rs.getString("listTraffic"));
resultData.setCreator(rs.getString("creator"));
Timestamp tempTimeStamp = rs.getTimestamp("createDate");
Date tempDate = new Date(tempTimeStamp.getTime());
resultData.setCreateDate(tempDate);
resultData.setIsActive(rs.getBoolean("isActive"));
return resultData;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
if (stm != null) {
try {
stm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return null;
}
@Override
public ArrayList<ResultDTO> getResultInLastXDay(int days) {
Connection connection = null;
PreparedStatement stm = null;
ArrayList<ResultDTO> resultData = new ArrayList<ResultDTO>();
try {
connection = BaseDAO.getConnect();
stm =
connection.prepareStatement(
"SELECT resultID, createDate FROM trafficdb.result WHERE createDate >= DATE_SUB(NOW(),INTERVAL ? DAY) ORDER BY createDate DESC");
stm.setInt(1, days);
ResultSet rs = stm.executeQuery();
while (rs.next()) {
ResultDTO resultObject = new ResultDTO();
resultObject.setResultID(rs.getInt("resultID"));
resultObject.setCreateDate(rs.getDate("createDate"));
resultData.add(resultObject);
}
return resultData;
} catch (Exception e) {
e.printStackTrace();
} finally {
if (stm != null) {
try {
stm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return resultData;
}