public static Boolean checkDate(int roomID, String dateOut, String dateIn) {
		try {
			   if(conn == null || conn.isClosed()){
			    conn = DatabaseConnection.getConnection();
			   }
			  } catch (SQLException e1) {
			   // TODO Auto-generated catch block
			   e1.printStackTrace();
			  }
		
		Statement stmnt = null;
		String sql = "";
		ResultSet res = null;
		Boolean booked = false;
		try{
			stmnt = conn.createStatement();
			sql = "SELECT * FROM RentTransactions rt, Rentals r WHERE r.rental_id = rt.rent_trans_id AND rt.date_out = '" + dateOut + "' AND rt.date_in = '" + dateIn + "' AND r.product_id = " + roomID;
			res = stmnt.executeQuery(sql);
			System.out.println(res.isBeforeFirst());
			if(!res.isBeforeFirst()) {
				booked = false;
			}
			else {
				booked = true;
			}
		}
		catch(SQLException e){
			System.out.println("Update fail: " + e);
		}
		
		return booked;
	}