如何在带数据库的TabLayout+ViewPager中仅用一个Fragment更新页面？

我来给你捋捋怎么搞定这个需求——核心思路就是让同一个Fragment根据当前选中的Tab去拉取对应数据库数据，不用重复创建多个Fragment实例，既省资源又方便维护，下面一步步来实现：

1. 完善你的SQLite助手类 #

先把你给出的Simple1类补全，比如添加按Tab分类获取数据的方法（假设你的Tab对应数据库里的分类字段）：

public class Simple1 extends SQLiteAssetHelper {
    private static final String DATABASE_NAME = "yogalite.db";
    private static final int DATABASE_VERSION = 1;
    private static final String ID="id";
    private static final String NAME="name";
    private static final String DESCRIPTION="description";
    private static final String POSES_TABLE="poses";
    // 假设数据库表有category字段对应Tab分类
    private static final String CATEGORY = "category";

    public Simple1(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    // 根据分类获取瑜伽姿势列表
    public ArrayList<YogaPose> getPosesByCategory(String category) {
        ArrayList<YogaPose> poseList = new ArrayList<>();
        SQLiteDatabase db = getReadableDatabase();
        Cursor cursor = db.query(POSES_TABLE,
                new String[]{ID, NAME, DESCRIPTION},
                CATEGORY + "=?",
                new String[]{category},
                null, null, null);

        if (cursor.moveToFirst()) {
            do {
                YogaPose pose = new YogaPose();
                pose.setId(cursor.getInt(cursor.getColumnIndexOrThrow(ID)));
                pose.setName(cursor.getString(cursor.getColumnIndexOrThrow(NAME)));
                pose.setDescription(cursor.getString(cursor.getColumnIndexOrThrow(DESCRIPTION)));
                poseList.add(pose);
            } while (cursor.moveToNext());
        }
        cursor.close();
        db.close();
        return poseList;
    }

    // 获取所有Tab分类，用来设置Tab标题
    public ArrayList<String> getTabCategories() {
        ArrayList<String> categories = new ArrayList<>();
        SQLiteDatabase db = getReadableDatabase();
        Cursor cursor = db.rawQuery("SELECT DISTINCT " + CATEGORY + " FROM " + POSES_TABLE, null);
        if (cursor.moveToFirst()) {
            do {
                categories.add(cursor.getString(0));
            } while (cursor.moveToNext());
        }
        cursor.close();
        db.close();
        return categories;
    }
}

// 对应的实体类，用来封装数据
public class YogaPose {
    private int id;
    private String name;
    private String description;

    // getter和setter方法
    public int getId() { return id; }
    public void setId(int id) { this.id = id; }
    public String getName() { return name; }
    public void setName(String name) { this.name = name; }
    public String getDescription() { return description; }
    public void setDescription(String description) { this.description = description; }
}

2. 创建可复用的单个Fragment #

这个Fragment要具备接收数据并更新UI的能力，我们给它加一个核心的updateContent方法，用来在Tab切换时刷新内容：

public class YogaPoseFragment extends Fragment {
    private RecyclerView recyclerView;
    private YogaPoseAdapter adapter;
    private Simple1 dbHelper;

    @Nullable
    @Override
    public View onCreateView(@NonNull LayoutInflater inflater, @Nullable ViewGroup container, @Nullable Bundle savedInstanceState) {
        View view = inflater.inflate(R.layout.fragment_yoga_pose, container, false);
        recyclerView = view.findViewById(R.id.recycler_view);
        recyclerView.setLayoutManager(new LinearLayoutManager(getContext()));
        adapter = new YogaPoseAdapter(new ArrayList<>());
        recyclerView.setAdapter(adapter);
        dbHelper = new Simple1(getContext());
        return view;
    }

    // 核心方法：根据分类更新页面内容
    public void updateContent(String category) {
        // 注意：如果数据库查询耗时，建议放到异步线程（比如Coroutines/AsyncTask）
        ArrayList<YogaPose> poseList = dbHelper.getPosesByCategory(category);
        adapter.updateData(poseList);
    }

    // RecyclerView适配器，负责渲染列表
    private static class YogaPoseAdapter extends RecyclerView.Adapter<YogaPoseAdapter.ViewHolder> {
        private ArrayList<YogaPose> poseList;

        public YogaPoseAdapter(ArrayList<YogaPose> poseList) {
            this.poseList = poseList;
        }

        public void updateData(ArrayList<YogaPose> newList) {
            this.poseList = newList;
            notifyDataSetChanged();
        }

        @NonNull
        @Override
        public ViewHolder onCreateViewHolder(@NonNull ViewGroup parent, int viewType) {
            View view = LayoutInflater.from(parent.getContext()).inflate(R.layout.item_yoga_pose, parent, false);
            return new ViewHolder(view);
        }

        @Override
        public void onBindViewHolder(@NonNull ViewHolder holder, int position) {
            YogaPose pose = poseList.get(position);
            holder.tvName.setText(pose.getName());
            holder.tvDesc.setText(pose.getDescription());
        }

        @Override
        public int getItemCount() {
            return poseList.size();
        }

        static class ViewHolder extends RecyclerView.ViewHolder {
            TextView tvName, tvDesc;

            public ViewHolder(@NonNull View itemView) {
                super(itemView);
                tvName = itemView.findViewById(R.id.tv_pose_name);
                tvDesc = itemView.findViewById(R.id.tv_pose_desc);
            }
        }
    }
}

3. 配置TabLayout和ViewPager的自定义适配器 #

关键来了：我们的PagerAdapter不需要创建多个Fragment，而是始终返回同一个实例，同时监听ViewPager的页面切换事件，触发Fragment的内容更新：

public class MainActivity extends AppCompatActivity {
    private TabLayout tabLayout;
    private ViewPager viewPager;
    private YogaPoseFragment singleFragment;
    private ArrayList<String> tabCategories;
    private Simple1 dbHelper;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        tabLayout = findViewById(R.id.tab_layout);
        viewPager = findViewById(R.id.view_pager);
        dbHelper = new Simple1(this);
        tabCategories = dbHelper.getTabCategories();

        // 初始化单个Fragment实例
        singleFragment = new YogaPoseFragment();

        // 设置自定义PagerAdapter
        viewPager.setAdapter(new PagerAdapter(getSupportFragmentManager(), tabCategories));
        tabLayout.setupWithViewPager(viewPager);

        // 监听ViewPager页面切换，更新Fragment内容
        viewPager.addOnPageChangeListener(new ViewPager.OnPageChangeListener() {
            @Override
            public void onPageScrolled(int position, float positionOffset, int positionOffsetPixels) {}

            @Override
            public void onPageSelected(int position) {
                // 获取当前Tab对应的分类，调用Fragment的更新方法
                String currentCategory = tabCategories.get(position);
                singleFragment.updateContent(currentCategory);
            }

            @Override
            public void onPageScrollStateChanged(int state) {}
        });

        // 初始化第一个Tab的内容
        if (!tabCategories.isEmpty()) {
            singleFragment.updateContent(tabCategories.get(0));
        }
    }

    // 自定义PagerAdapter，始终返回同一个Fragment
    private class PagerAdapter extends FragmentPagerAdapter {
        private ArrayList<String> categories;

        public PagerAdapter(@NonNull FragmentManager fm, ArrayList<String> categories) {
            super(fm, BEHAVIOR_RESUME_ONLY_CURRENT_FRAGMENT);
            this.categories = categories;
        }

        @NonNull
        @Override
        public Fragment getItem(int position) {
            // 不管哪个位置，都返回同一个Fragment实例
            return singleFragment;
        }

        @Override
        public int getCount() {
            return categories.size();
        }

        @Nullable
        @Override
        public CharSequence getPageTitle(int position) {
            return categories.get(position);
        }
    }
}

几个关键注意点 #

• 如果数据库查询耗时，一定要把查询逻辑放到异步线程，避免阻塞UI（比如用Kotlin Coroutines或者Java的AsyncTask）。
• 如果你的Tab是按索引而非分类区分，只需要把category参数换成position，在数据库查询时按索引对应的条件获取数据即可。
• 复用Fragment时要注意避免数据错乱，确保每次切换Tab都能正确传递当前Tab的标识。

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