public ArrayList<RentTransaction> getAllRentTransaction(){
		
		try {
			   if(conn == null || conn.isClosed()){
			    conn = DatabaseConnection.getConnection();
			   }
			  } catch (SQLException e1) {
			   // TODO Auto-generated catch block
			   e1.printStackTrace();
			  }
		
		ArrayList<RentTransaction> rentTransactionList = new ArrayList<RentTransaction>();
		
		try {
			Statement stmnt = conn.createStatement();
			String sql = "SELECT * FROM RentTransactions";
			ResultSet res = stmnt.executeQuery(sql);

			while(res.next()) {
				
				rentalList = RentalDAO.getRentalById(res.getInt("rent_trans_id"));
				
				for (int i = 0; i < rentalList.size(); i++) {
					
					if (rentalList.get(i).getType() == "boek"){
						
						bookList.add(BookDAO.getBookCopyByBookCopyID(rentalList.get(i).getProductId()));
					}
					if (rentalList.get(i).getType() == "dvd" || rentalList.get(i).getType() == "cd"){ 
						
						mediaList.add(MediaDAO.getMediaCopyByMediaCopyID(rentalList.get(i).getProductId()));
					}
					
					
				}
				
				rentTransaction = new RentTransaction(res.getBoolean("closed"),bookList,mediaList,res.getInt("rent_trans_id"),res.getInt("member_id"),res.getString("date_out"),res.getString("date_in"),res.getString("staff_id"));
				rentTransactionList.add(rentTransaction);
				
				bookList = null;
				mediaList = null;
				rentalList = null;
			}

		}
		catch(SQLException e) {
			System.out.println("PROBLEM");
			e.printStackTrace();
		}
		
		return rentTransactionList;
			
		}