public static ArrayList<BookCopy> getAllCopies() {
 		
 		try {
			   if(conn == null || conn.isClosed()){
			    conn = DatabaseConnection.getConnection();
			   }
			  } catch (SQLException e1) {
			   // TODO Auto-generated catch block
			   e1.printStackTrace();
			  }
		
		ArrayList<BookCopy> bookList = new ArrayList<BookCopy>();
		try {
			
			Statement stmnt = conn.createStatement();
			String sql = "SELECT * FROM BookCopies bc, Books b WHERE bc.book_id = b.book_id";
			ResultSet res = stmnt.executeQuery(sql);

			while(res.next()) {
				BookCopy bc = new BookCopy(res.getDate("year"), res.getString("place_of_publication"),
						res.getString("title"), res.getString("genre"), res.getString("author"),
						res.getString("isbn"), res.getString("publisher"), res.getInt("book_id"),
						res.getInt("copy_id"), res.getInt("edition"),res.getBoolean("lendable"));
				bookList.add(bc);
			}

		}
		catch(SQLException e) {
			System.out.println(e);
		}
		
		return bookList;
	}