public static BookCopy getBookCopyByBookCopyID(int copyID){
		
		try {
			   if(conn == null || conn.isClosed()){
			    conn = DatabaseConnection.getConnection();
			   }
			  } catch (SQLException e1) {
			   // TODO Auto-generated catch block
			   e1.printStackTrace();
			  }
		
		BookCopy bc = null;
		
		try {
			PreparedStatement stmnt = conn.prepareStatement("SELECT * FROM Books b, BookCopies bc WHERE b.book_id = bc.book_id AND bc.copy_id = ?");
			stmnt.setInt(1, copyID);
			ResultSet res = stmnt.executeQuery();
			if(res.next())
			{
				bc = new BookCopy(StringDateSwitcher.toDateYear(res.getString("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"));
			}
		}
		catch(SQLException e) {
			System.out.println(e);
		}
		
		return bc;
	}