@Override
 public List<Booking> loadActiveBookingsByAccountId(Integer accountId) {
   Connection connect = null;
   PreparedStatement preparedStatement = null;
   ResultSet resultSet = null;
   // boolean isAuthenticated = false;
   List<Booking> bookings = new ArrayList<Booking>();
   // Date currentDate = new Date(new java.util.Date().getTime());
   try {
     connect = ConnectionPool.getPool().getConnection();
     preparedStatement = connect.prepareStatement(SELECT_BOOKINGS_BY_ACCOUNT_ID);
     preparedStatement.setInt(1, accountId);
     // preparedStatement.setDate(2, currentDate);
     // preparedStatement.setDate(3, currentDate);
     resultSet = preparedStatement.executeQuery();
     while (resultSet.next()) {
       Booking booking = new Booking();
       booking.setId(resultSet.getInt(BookingColumns.Id.getName()));
       booking.setRoomId(resultSet.getInt(BookingColumns.roomId.getName()));
       booking.setCheckinDate(resultSet.getDate(BookingColumns.checkinDate.getName()));
       booking.setCheckoutDate(resultSet.getDate(BookingColumns.checkoutDate.getName()));
       System.out.println(booking.getId());
       System.out.println(booking.getRoomId());
       System.out.println(booking.getCheckinDate());
       System.out.println(booking.getCheckoutDate());
       bookings.add(booking);
     }
   } catch (Exception e) {
     throw new DAOException(e);
   } finally {
     ConnectionPool.releaseConnection(connect, preparedStatement, resultSet);
   }
   return bookings;
 }
 @Override
 public void saveBooking(Booking booking) throws DAOException {
   Connection connect = null;
   PreparedStatement preparedStatement = null;
   ResultSet resultSet = null;
   try {
     connect = ConnectionPool.getPool().getConnection();
     preparedStatement = connect.prepareStatement(SAVE_BOOKING);
     // preparedStatement.setInt(1, booking.getId());
     preparedStatement.setInt(1, booking.getRoomId());
     preparedStatement.setInt(2, booking.getAccountId());
     Date orderDate = new Date(booking.getCheckinDate().getTime());
     preparedStatement.setDate(3, orderDate);
     Date checkinDate = new Date(booking.getCheckinDate().getTime());
     preparedStatement.setDate(4, checkinDate);
     Date checkoutDate = new Date(booking.getCheckoutDate().getTime());
     preparedStatement.setDate(5, checkoutDate);
     preparedStatement.executeUpdate();
   } catch (Exception e) {
     throw new DAOException(e);
   } finally {
     ConnectionPool.releaseConnection(connect, preparedStatement, resultSet);
   }
 }