Android Fragment中实现SearchCategories函数及解决空指针异常问题

Hey there, let's tackle your Android Fragment search functionality issues step by step!

First: Fixing the Null Pointer Exception in SearchSubCategories #

That null object reference error usually pops up when one of the components in your call chain isn't initialized properly. Here are the most common fixes:

1. Validate the passed checkbox text before calling the function #

Make sure the text you're sending from MainActivity isn't empty or null. Add a quick check when triggering the function:

// Inside MainActivity when checkbox is clicked
CheckBox clickedCheckBox = (CheckBox) view;
String subCategoryText = clickedCheckBox.getText().toString().trim();

// Only call the fragment function if the text is valid
if (!TextUtils.isEmpty(subCategoryText) && yourFragment != null && yourFragment.isAdded()) {
    yourFragment.searchSubCategories(subCategoryText);
}

2. Ensure Fragment & RecyclerView components are initialized #

Double-check that in your Fragment's onViewCreated method, you've properly set up the RecyclerView, adapter, and data source:

@Override
public void onViewCreated(@NonNull View view, @Nullable Bundle savedInstanceState) {
    super.onViewCreated(view, savedInstanceState);
    recyclerView = view.findViewById(R.id.your_recycler_view);
    dataList = new ArrayList<>();
    adapter = new YourRecyclerViewAdapter(dataList);
    recyclerView.setLayoutManager(new LinearLayoutManager(getContext()));
    recyclerView.setAdapter(adapter);
}

If any of these (like adapter or dataList) are null when searchSubCategories runs, you'll hit a null pointer.

3. Safely handle database query results #

When fetching data from the database, never assume the cursor or returned data isn't null:

public void searchSubCategories(String subCategory) {
    if (dataList == null || adapter == null) return;

    SQLiteDatabase db = yourDbHelper.getReadableDatabase();
    Cursor cursor = db.query(
        "your_table_name",
        null,
        "sub_category = ?", // Your column name
        new String[]{subCategory},
        null, null, null
    );

    dataList.clear();
    if (cursor != null) {
        while (cursor.moveToNext()) {
            // Parse cursor data into your model class
            YourDataModel item = new YourDataModel(
                cursor.getString(cursor.getColumnIndex("item_name")),
                // Add other fields as needed
            );
            dataList.add(item);
        }
        cursor.close(); // Always close the cursor!
    }

    // Update RecyclerView on the main thread
    requireActivity().runOnUiThread(() -> adapter.notifyDataSetChanged());

    // Handle empty state
    if (dataList.isEmpty()) {
        Toast.makeText(getContext(), "No data found for " + subCategory, Toast.LENGTH_SHORT).show();
        // Optional: Show an empty state view instead of blank RecyclerView
    }
}

Second: Implementing SearchCategories in Fragment #

This function will follow a similar pattern to SearchSubCategories, but targeting top-level categories. Here's a complete implementation:

public void searchCategories(String category) {
    // Guard clause for uninitialized components
    if (dataList == null || adapter == null || getContext() == null) return;

    // Use coroutines for background database work (avoid blocking main thread)
    lifecycleScope.launch(Dispatchers.IO) {
        SQLiteDatabase db = yourDbHelper.getReadableDatabase();
        Cursor cursor = db.query(
            "your_table_name",
            null,
            "main_category = ?", // Match your table's main category column
            new String[]{category},
            null, null, null
        );

        List<YourDataModel> filteredData = new ArrayList<>();
        if (cursor != null) {
            while (cursor.moveToNext()) {
                filteredData.add(new YourDataModel(
                    cursor.getString(cursor.getColumnIndex("item_name")),
                    cursor.getString(cursor.getColumnIndex("sub_category")),
                    // Add other fields
                ));
            }
            cursor.close();
        }

        // Update UI on main thread
        launch(Dispatchers.Main) {
            dataList.clear();
            dataList.addAll(filteredData);
            adapter.notifyDataSetChanged();

            if (filteredData.isEmpty()) {
                Toast.makeText(getContext(), "No items in " + category, Toast.LENGTH_SHORT).show();
            }
        }
    }
}

Quick Tips for Robustness #

• Use Room instead of raw SQLite: Room simplifies database operations, handles background threads automatically, and reduces boilerplate code that can cause null pointers.
• Manage fragment lifecycle: Always check if the fragment is attached to an activity (isAdded()) before accessing getContext() or updating UI.
• Handle multiple selections: If users can select multiple checkboxes, adjust your database query to use IN instead of =, e.g., main_category IN (?, ?) with an array of selected category strings.

内容的提问来源于stack exchange，提问作者Majid Ali