You need to enable JavaScript to run this app. 如何将RecyclerView关联的SQLite数据传递到其他Fragment并更新后回显?
优惠活动
大模型
产品
解决方案
定价
更多

如何将RecyclerView关联的SQLite数据传递到其他Fragment并更新后回显?

RecyclerView绑定的SQLite数据跨Fragment传递与同步方案

核心实现逻辑:以本地SQLite作为唯一数据源,传递选中数据时用Bundle携带参数,更新完成后原Fragment主动拉取最新数据刷新列表,耦合度低且实现简单。

修改步骤

  • 先补全SQLiteHelper的更新数据方法,支持数据修改写入
  • 给RecyclerView适配器添加条目点击回调,点击时把选中的用户数据传到编辑Fragment
  • 原列表Fragment重写onResume生命周期方法,每次回到前台时自动拉取最新数据刷新列表
  • 编辑Fragment接收传递的用户参数,填充到输入框,修改完成后写入SQLite即可

1. 补充后的SQLiteHelper代码

package com.example.test_nav_drawer

import android.content.ContentValues
import android.content.Context
import android.database.Cursor
import android.database.sqlite.SQLiteDatabase
import android.database.sqlite.SQLiteOpenHelper
import java.lang.Exception

class SQLiteHelper(context: Context) :
    SQLiteOpenHelper(context, DATABASE_NAME, null, DATABASE_VERSION) {


    companion object {
        private const val DATABASE_VERSION = 1
        private const val DATABASE_NAME = "user.db"
        private const val TBL_USER = "tbl_user"
        private const val ID = "id"
        private const val NAME = "name"
        private const val EMAIL = "email"
        private const val PHONE = "phone"
        private const val ADDRESS = "address"

    }


    override fun onCreate(db: SQLiteDatabase?) {
        val createTblUser = ("CREATE TABLE " + TBL_USER + " ("
                + ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + NAME + " TEXT, "
                + EMAIL + " TEXT, " + PHONE + " TEXT, "
                + ADDRESS + " TEXT " + " )")
        db?.execSQL(createTblUser)
    }

    override fun onUpgrade(db: SQLiteDatabase?, oldVersion: Int, newVersion: Int) {
        db!!.execSQL("DROP TABLE IF EXISTS $TBL_USER")
        onCreate(db)
    }

    fun insertUser(usr: UserModel): Long {
        val db = this.writableDatabase
        val contentValues = ContentValues()
        // 主键如果是自增的话插入不用传ID,这里如果你的UserModel id是自增就去掉下面这行
        // contentValues.put(ID, usr.id)
        contentValues.put(NAME, usr.name)
        contentValues.put(EMAIL, usr.email)
        contentValues.put(PHONE, usr.phone)
        contentValues.put(ADDRESS, usr.address)

        val success = db.insert(TBL_USER, null, contentValues)
        db.close()
        return success
    }

    // 新增更新用户的方法
    fun updateUser(usr: UserModel): Int {
        val db = this.writableDatabase
        val contentValues = ContentValues()
        contentValues.put(NAME, usr.name)
        contentValues.put(EMAIL, usr.email)
        contentValues.put(PHONE, usr.phone)
        contentValues.put(ADDRESS, usr.address)
        // 按ID匹配要更新的条目
        val success = db.update(TBL_USER, contentValues, "$ID=?", arrayOf(usr.id.toString()))
        db.close()
        return success
    }

    fun getAllUser(): ArrayList<UserModel> {
        val usrList: ArrayList<UserModel> = ArrayList()
        val selectQuery = "SELECT * FROM $TBL_USER"
        val db = this.readableDatabase

        val cursor: Cursor?

        try {
            cursor = db.rawQuery(selectQuery, null)
        } catch (e: Exception) {
            e.printStackTrace()
            db.execSQL(selectQuery)
            return ArrayList()
        }

        var id: Int
        var name: String
        var email: String
        var phone: String
        var address: String
        if (cursor.moveToFirst()) {
            do {
                id = cursor.getInt(cursor.getColumnIndexOrThrow("id"))
                name = cursor.getString(cursor.getColumnIndexOrThrow("name"))
                email = cursor.getString(cursor.getColumnIndexOrThrow("email"))
                phone = cursor.getString(cursor.getColumnIndexOrThrow("phone"))
                address = cursor.getString(cursor.getColumnIndexOrThrow("address"))

                val usr =
                    UserModel(id = id, name = name, email = email, phone = phone, address = address)
                usrList.add(usr)
            } while (cursor.moveToNext())
        }
        cursor.close()
        return usrList
    }
}

2. 添加点击回调后的UserdbAdapter代码

package com.example.test_nav_drawer.ui.adapter

import android.content.Context
import android.view.LayoutInflater
import android.view.View
import android.view.ViewGroup
import android.widget.Button
import android.widget.TextView
import androidx.recyclerview.widget.RecyclerView
import com.example.test_nav_drawer.R
import com.example.test_nav_drawer.UserModel

class UserdbAdapter(
    context: Context,
    var usrList: ArrayList<UserModel> = ArrayList(),
    // 新增条目点击回调接口
    private val onItemClick: (UserModel) -> Unit
): RecyclerView.Adapter<UserdbAdapter.UserdbViweHolder>() {

    fun addItems(items: ArrayList<UserModel>){
        this.usrList = items
        notifyDataSetChanged()
    }

    override fun onCreateViewHolder(parent: ViewGroup, viewType: Int) = UserdbViweHolder(
        LayoutInflater.from(parent.context).inflate(R.layout.card_items_usr_frag1, parent, false)
    )

    override fun onBindViewHolder(holder: UserdbViweHolder, position: Int) {
        val usr = usrList[position]
        holder.bindView(usr)
        // 条目点击事件绑定
        holder.itemView.setOnClickListener {
            onItemClick.invoke(usr)
        }
    }

    override fun getItemCount(): Int {
        return usrList.size
    }


    class UserdbViweHolder(var view: View) : RecyclerView.ViewHolder(view) {
        private var id = view.findViewById<TextView>(R.id.tvID)
        private var name = view.findViewById<TextView>(R.id.tvUserName)
        private var email = view.findViewById<TextView>(R.id.tvUsrEmail)
        private var phone = view.findViewById<TextView>(R.id.tvUsrPhone)
        private var address = view.findViewById<TextView>(R.id.tvUsrAddress)
        var btnDelete = view.findViewById<Button>(R.id.btnUsrDelete)

        fun bindView(usr: UserModel) {
            id.text = usr.id.toString()
            name.text = usr.name
            email.text = usr.email
            phone.text = usr.phone
            address.text = usr.address
        }
    }

}

3. 调整后的WorkFragment(承载RecyclerView的原Fragment)代码

package com.example.test_nav_drawer

import android.os.Bundle
import android.view.LayoutInflater
import android.view.View
import android.view.ViewGroup
import androidx.fragment.app.Fragment
import androidx.navigation.fragment.findNavController
import androidx.recyclerview.widget.LinearLayoutManager
import androidx.recyclerview.widget.RecyclerView
import com.example.test_nav_drawer.ui.adapter.UserdbAdapter

class WorkFragment : Fragment(R.layout.fragment_work) {

    private lateinit var recyclerView_User: RecyclerView
    private lateinit var sqLiteHelper: SQLiteHelper
    private lateinit var adapterdb: UserdbAdapter
    private lateinit var usrList : ArrayList<UserModel>


    override fun onCreateView(
        inflater: LayoutInflater,
        container: ViewGroup?,
        savedInstanceState: Bundle?
    ): View? {

        val v = inflater.inflate(R.layout.fragment_work, container, false)
        sqLiteHelper = SQLiteHelper(requireActivity())
        recyclerView_User = v.findViewById(R.id.recycler_view_frag1)
        recyclerView_User.setHasFixedSize(true)
        recyclerView_User.layoutManager = LinearLayoutManager(context)
        // 初始化适配器传入点击回调
        adapterdb = UserdbAdapter(requireContext(), usrList) { selectedUser ->
            // 点击条目跳转到编辑Fragment,携带选中的用户数据
            val bundle = Bundle()
            bundle.putParcelable("selected_user", selectedUser)
            // 如果你用的是Navigation组件就用这个跳转,不是的话换成自己的Fragment跳转逻辑
            findNavController().navigate(R.id.action_workFragment_to_timelineFragment, bundle)
        }
        recyclerView_User.adapter = adapterdb
        refreshList()
        return v
    }

    // 重写onResume,每次回到页面自动刷新列表
    override fun onResume() {
        super.onResume()
        refreshList()
    }

    // 拉取最新数据刷新列表
    private fun refreshList() {
        usrList = sqLiteHelper.getAllUser()
        adapterdb.addItems(usrList)
    }

}

注意:要让UserModel支持Bundle传递需要让它实现Parcelable接口,直接给类加@Parcelize注解即可,需要在gradle里开启kotlin安卓扩展

4. 调整后的TimelineFragment(编辑更新用的Fragment)代码

import android.os.Bundle
import android.widget.Button
import android.widget.EditText
import android.widget.Toast
import androidx.fragment.app.Fragment
import android.view.LayoutInflater
import android.view.View
import android.view.ViewGroup
import com.example.test_nav_drawer.R
import com.example.test_nav_drawer.SQLiteHelper
import com.example.test_nav_drawer.UserModel

class TimelineFragment : Fragment(R.layout.fragment_timeline) {
    private lateinit var evUsername: EditText
    private lateinit var evUserEmail: EditText
    private lateinit var evUserPhone: EditText
    private lateinit var evUserAddress: EditText
    private lateinit var btnAddDetails: Button
    private lateinit var sqLiteHelper: SQLiteHelper
    // 接收传递过来的选中用户
    private var selectedUser: UserModel? = null

    override fun onCreateView(
        inflater: LayoutInflater,
        container: ViewGroup?,
        savedInstanceState: Bundle?
    ): View? {
        val v = inflater.inflate(R.layout.fragment_timeline, container, false)
        // 接收传递的参数
        selectedUser = arguments?.getParcelable("selected_user")
        btnAddDetails = v.findViewById(R.id.btnAdd)
        evUsername = v.findViewById(R.id.etUserNameLogin)
        evUserEmail = v.findViewById(R.id.etUserEmailLogin)
        evUserPhone = v.findViewById(R.id.etUserPhoneLogin)
        evUserAddress = v.findViewById(R.id.etUserAddressLogin)
        sqLiteHelper = SQLiteHelper(requireActivity())
        
        // 如果是编辑模式,自动填充原有数据
        selectedUser?.let {
            evUsername.setText(it.name)
            evUserEmail.setText(it.email)
            evUserPhone.setText(it.phone)
            evUserAddress.setText(it.address)
            btnAddDetails.text = "保存修改"
        }

        btnAddDetails.setOnClickListener {
            if (selectedUser != null) {
                // 编辑模式:更新用户
                updateUser()
            } else {
                // 新增模式:添加用户
                addUser()
            }
            // 操作完成后返回上一个页面
            requireActivity().onBackPressed()
        }
        return v
    }

    private fun addUser() {
        val name = evUsername.text.toString()
        val email = evUserEmail.text.toString()
        val phone = evUserPhone.text.toString()
        val address = evUserAddress.text.toString()

        if (name.isEmpty() || email.isEmpty() || phone.isEmpty() || address.isEmpty()) {
            Toast.makeText(context, "请填写所有必填字段", Toast.LENGTH_SHORT).show()
            return
        }
        val usr = UserModel(name = name, email = email, phone = phone, address = address)
        val status = sqLiteHelper.insertUser(usr)
        if (status > -1) {
            Toast.makeText(context, "用户添加成功", Toast.LENGTH_SHORT).show()
        } else {
            Toast.makeText(context, "保存失败", Toast.LENGTH_LONG).show()
        }
    }

    private fun updateUser() {
        val name = evUsername.text.toString()
        val email = evUserEmail.text.toString()
        val phone = evUserPhone.text.toString()
        val address = evUserAddress.text.toString()

        if (name.isEmpty() || email.isEmpty() || phone.isEmpty() || address.isEmpty()) {
            Toast.makeText(context, "请填写所有必填字段", Toast.LENGTH_SHORT).show()
            return
        }
        val updatedUser = selectedUser!!.copy(
            name = name,
            email = email,
            phone = phone,
            address = address
        )
        val status = sqLiteHelper.updateUser(updatedUser)
        if (status > 0) {
            Toast.makeText(context, "用户修改成功", Toast.LENGTH_SHORT).show()
        } else {
            Toast.makeText(context, "修改失败", Toast.LENGTH_LONG).show()
        }
    }
}

内容的提问来源于stack exchange,提问作者Rohan Choudhary

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.10.10 20:21:00