如何将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
相关产品推荐
相关产品推荐

