@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;
  }