目前RecyclerView.Adapter没有默认实现可用。
可能在官方发布中，Google会添加它。
由于当前RecyclerView不支持CursorAdapter，那么我们如何将RecyclerView与数据库一起使用呢？有什么建议吗？
使用RecyclerView和数据库
130
- LostPuppy
12个回答
101
如果您正在使用 CursorLoader 运行查询，并且想要使用 RecyclerView 而不是 ListView，您可以尝试使用我的 CursorRecyclerViewAdapter：RecyclerView中的CursorAdapter
- skyfishjy
10
92
我的解决方案是在recyclerView.Adapter实现中持有一个CursorAdapter成员。然后将创建新视图和将其绑定到游标适配器的所有处理都传递给它，类似于以下内容：
public class MyRecyclerAdapter extends Adapter<MyRecyclerAdapter.ViewHolder> {
// Because RecyclerView.Adapter in its current form doesn't natively
// support cursors, we wrap a CursorAdapter that will do all the job
// for us.
CursorAdapter mCursorAdapter;
Context mContext;
public MyRecyclerAdapter(Context context, Cursor c) {
mContext = context;
mCursorAdapter = new CursorAdapter(mContext, c, 0) {
@Override
public View newView(Context context, Cursor cursor, ViewGroup parent) {
// Inflate the view here
}
@Override
public void bindView(View view, Context context, Cursor cursor) {
// Binding operations
}
};
}
public static class ViewHolder extends RecyclerView.ViewHolder {
View v1;
public ViewHolder(View itemView) {
super(itemView);
v1 = itemView.findViewById(R.id.v1);
}
}
@Override
public int getItemCount() {
return mCursorAdapter.getCount();
}
@Override
public void onBindViewHolder(ViewHolder holder, int position) {
// Passing the binding operation to cursor loader
mCursorAdapter.getCursor().moveToPosition(position); //EDITED: added this line as suggested in the comments below, thanks :)
mCursorAdapter.bindView(holder.itemView, mContext, mCursorAdapter.getCursor());
}
@Override
public ViewHolder onCreateViewHolder(ViewGroup parent, int viewType) {
// Passing the inflater job to the cursor-adapter
View v = mCursorAdapter.newView(mContext, mCursorAdapter.getCursor(), parent);
return new ViewHolder(v);
}
}
- nbtk
25
17谢谢这个解决方案，它对我有用，我只需要在onBindViewHolder中添加一行代码：'mCursorAdapter.getCursor().moveToPosition(position)'，然后再调用mCursorAdapter的bindView()函数。 - user1071762
8为什么不使用Cursor而使用CursorAdapter？据我所知，您并没有使用CursorAdapter的任何功能。 - MyDogTom
14@MyDogTom - 我没有持有一个游标，因为当你完成后需要清除它，而将其设置为NULL是不够的。CursorAdapter可以完美地处理这个问题。 - nbtk
3@nbtk 我非常喜欢这个想法，自从那时以来我一直在尝试玩耍。我尝试了一些抽象化的方法并构建了一个库，虽然它还不完全符合我的期望但是它可以完成工作。你有兴趣看看吗？如果你有 Github 我很乐意将你列为灵感来源。https://github.com/androidessence/RecyclerViewCursorAdapter - AdamMc331
5要使用新数据刷新视图，请执行以下操作：
public void changeCursor(Cursor cursor){
mCursorAdapter.changeCursor(cursor);
notifyDataSetChanged();
} - Cijo显示剩余20条评论
47
由于您的问题说“如何使用 RecyclerView 与数据库”，而您没有具体说明您想要使用SQLite还是其他任何与 RecyclerView 相关的内容，因此我将为您提供一个高度优化的解决方案。我将使用 Realm 作为数据库，并让您在RecyclerView中显示所有数据。它还支持异步查询，而不需要使用Loaders或AsyncTask。
为什么选择 Realm？
第一步
添加 Realm 的 Gradle 依赖项，最新版本的依赖项可以在 这里 找到。
第二步
创建您的模型类，例如，假设您只需要显示一个字符串和一个时间戳，用作RecyclerView的itemId，那就创建一个名为 Data 的简单类。请注意，由于我继承了RealmObject，所以您的 Data 类将存储为表格，其中所有属性将存储为该表格 Data 的列。在我的示例中，我将数据文本标记为主键，因为我不希望字符串被添加超过一次。但是，如果您愿意有重复项，则将时间戳作为@PrimaryKey。您可以创建一个没有主键的表格，但是如果尝试在创建后更新行，则会出现问题。在撰写此答案时，Realm不支持组合主键。
import io.realm.RealmObject;
import io.realm.annotations.PrimaryKey;
public class Data extends RealmObject {
@PrimaryKey
private String data;
//The time when this item was added to the database
private long timestamp;
public String getData() {
return data;
}
public void setData(String data) {
this.data = data;
}
public long getTimestamp() {
return timestamp;
}
public void setTimestamp(long timestamp) {
this.timestamp = timestamp;
}
}
第三步
创建你的布局，确定一个单独行在 RecyclerView 中应该如何显示。我们适配器(Adapter)中的单独行项布局如下所示。
<?xml version="1.0" encoding="utf-8"?>
<FrameLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent">
<TextView
android:id="@+id/area"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:layout_gravity="center"
android:background="@android:color/white"
android:padding="16dp"
android:text="Data"
android:visibility="visible" />
</FrameLayout>
请注意，即使我有一个TextView，我仍然将FrameLayout保留为根。 我计划在此布局中添加更多项目，因此现在使其灵活 :)
对于那些好奇的人，这就是单个项目当前的外观。
步骤4
创建您的RecyclerView.Adapter实现。 在本例中，数据源对象是称为RealmResults的特殊对象，它基本上是一个LIVE ArrayList，换句话说，当从表中添加或删除项时，此RealmResults对象会自动更新。
import android.content.Context;
import android.support.v7.widget.RecyclerView;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.TextView;
import io.realm.Realm;
import io.realm.RealmResults;
import slidenerd.vivz.realmrecycler.R;
import slidenerd.vivz.realmrecycler.model.Data;
public class DataAdapter extends RecyclerView.Adapter<DataAdapter.DataHolder> {
private LayoutInflater mInflater;
private Realm mRealm;
private RealmResults<Data> mResults;
public DataAdapter(Context context, Realm realm, RealmResults<Data> results) {
mRealm = realm;
mInflater = LayoutInflater.from(context);
setResults(results);
}
public Data getItem(int position) {
return mResults.get(position);
}
@Override
public DataHolder onCreateViewHolder(ViewGroup parent, int viewType) {
View view = mInflater.inflate(R.layout.row_data, parent, false);
DataHolder dataHolder = new DataHolder(view);
return dataHolder;
}
@Override
public void onBindViewHolder(DataHolder holder, int position) {
Data data = mResults.get(position);
holder.setData(data.getData());
}
public void setResults(RealmResults<Data> results) {
mResults = results;
notifyDataSetChanged();
}
@Override
public long getItemId(int position) {
return mResults.get(position).getTimestamp();
}
@Override
public int getItemCount() {
return mResults.size();
}
public void add(String text) {
//Create a new object that contains the data we want to add
Data data = new Data();
data.setData(text);
//Set the timestamp of creation of this object as the current time
data.setTimestamp(System.currentTimeMillis());
//Start a transaction
mRealm.beginTransaction();
//Copy or update the object if it already exists, update is possible only if your table has a primary key
mRealm.copyToRealmOrUpdate(data);
//Commit the transaction
mRealm.commitTransaction();
//Tell the Adapter to update what it shows.
notifyDataSetChanged();
}
public void remove(int position) {
//Start a transaction
mRealm.beginTransaction();
//Remove the item from the desired position
mResults.remove(position);
//Commit the transaction
mRealm.commitTransaction();
//Tell the Adapter to update what it shows
notifyItemRemoved(position);
}
public static class DataHolder extends RecyclerView.ViewHolder {
TextView area;
public DataHolder(View itemView) {
super(itemView);
area = (TextView) itemView.findViewById(R.id.area);
}
public void setData(String text) {
area.setText(text);
}
}
}
notifyItemRemoved但是没有调用notifyItemInserted或notifyItemRangeChanged，因为没有直接的方法可以知道将项目插入到数据库中的哪个位置，因为Realm条目不以有序方式存储。 RealmResults对象会在从数据库添加、修改或删除新项时自动更新，因此我们在添加和插入批量条目时调用notifyDataSetChanged。这时，您可能会担心因为在notifyXXX方法的位置调用notifyDataSetChanged而不会触发动画。这正是为什么我让getItemId方法针对结果对象中每一行返回时间戳。如果您调用setHasStableIds(true)，然后覆盖getItemId以提供除位置之外的其他内容，则可以通过2步骤使用notifyDataSetChanged来实现动画。
第五步
让我们将RecyclerView添加到我们的Activity或Fragment中。在我的情况下，我正在使用一个Activity。包含RecyclerView的布局文件非常简单，看起来应该像这样。
<android.support.v7.widget.RecyclerView xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:app="http://schemas.android.com/apk/res-auto"
android:id="@+id/recycler"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:layout_margin="@dimen/text_margin"
app:layout_behavior="@string/appbar_scrolling_view_behavior" />
我已添加了app:layout_behavior，因为我的RecyclerView位于CoordinatorLayout中，出于简洁起见，我没有在此答案中发布它。
步骤 6
在代码中构建RecyclerView并提供其所需的数据。在onCreate中创建和初始化Realm对象，并像关闭SQLiteOpenHelper实例一样在onDestroy中关闭它。最简单的情况下，你的Activity内的onCreate看起来像这样。所有魔法都发生在initUi方法中。我在onCreate中打开了一个Realm实例。
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
mRealm = Realm.getInstance(this);
initUi();
}
private void initUi() {
//Asynchronous query
RealmResults<Data> mResults = mRealm.where(Data.class).findAllSortedAsync("data");
//Tell me when the results are loaded so that I can tell my Adapter to update what it shows
mResults.addChangeListener(new RealmChangeListener() {
@Override
public void onChange() {
mAdapter.notifyDataSetChanged();
Toast.makeText(ActivityMain.this, "onChange triggered", Toast.LENGTH_SHORT).show();
}
});
mRecycler = (RecyclerView) findViewById(R.id.recycler);
mRecycler.setLayoutManager(new LinearLayoutManager(this));
mAdapter = new DataAdapter(this, mRealm, mResults);
//Set the Adapter to use timestamp as the item id for each row from our database
mAdapter.setHasStableIds(true);
mRecycler.setAdapter(mAdapter);
}
注意，在第一步中，我以异步方式查询Realm从名为data的变量按名称排序的类中的所有对象。这给了我一个具有0个项的对象，我将其设置在上。我添加了以在数据从后台线程加载完成时通知我，并在其中调用与我的。我还调用了设置为true，以让实现跟踪添加、删除或修改的项目。我的的关闭了Realm实例。
@Override
protected void onDestroy() {
super.onDestroy();
mRealm.close();
}
这种方法initUi可以在您的Activity的onCreate或Fragment的onCreateView或onViewCreated中调用。注意以下几点。
第七步
BAM！无需使用CursorLoader、CursorAdapter、SQLiteOpenHelper，即可异步加载数据库中的数据到您的RecyclerView中，并带有动画效果。这里显示的GIF图像有些滞后，但是添加或删除项目时会发生动画效果。
- PirateApp
7
感谢提供全面的示例。我有几个问题。我想在 Realm 中存储位图，这是否可能？如果是，列类型将是什么，如何存储和检索它？ - Rakesh
1@Rakesh 永远不要将图像存储在任何数据库中，而应该将其存储在文件系统中，并将图像的 URI 存储在数据库中。 - PirateApp
感谢您的快速回复。我正在创建一款应用程序，希望在其中存储我的联系人图片。如果我将其存储在文件系统中，可能会有数百张图片。我该如何管理这些文件系统上的图片？ - Rakesh
9包括Realm插入性能图表的内容与关于RecyclerView的问题（通常涉及检索）并不相关。涉及RecyclerView的问题应关注其检索性能。 - JRaymond
“ContentProviders” - 为什么不呢？你可以在任何地方实现它，它只是ORM的一个超级简洁和干净的抽象。 - gor
显示剩余2条评论
1
你可以自己实现所有必需的方法。最近我通过复制粘贴来自CursorAdapter的代码，自己完成了自己的实现。
public class MyAdapter extends RecyclerView.Adapter<ViewHolder> {
protected boolean mDataValid;
protected boolean mAutoRequery;
protected Cursor mCursor;
protected Context mContext;
protected int mRowIDColumn;
protected ChangeObserver mChangeObserver;
protected DataSetObserver mDataSetObserver;
protected FilterQueryProvider mFilterQueryProvider;
public static final int FLAG_AUTO_REQUERY = 0x01;
public static final int FLAG_REGISTER_CONTENT_OBSERVER = 0x02;
public Cursor getCursor() {
return mCursor;
}
//Recommended
public MyAdapter(Context context, Cursor c, int flags) {
init(context, c, flags);
}
public MyAdapter(Context context, Cursor c) {
init(context, c, FLAG_AUTO_REQUERY);
}
public MyAdapter(Context context, Cursor c, boolean autoRequery) {
init(context, c, autoRequery ? FLAG_AUTO_REQUERY : FLAG_REGISTER_CONTENT_OBSERVER);
}
void init(Context context, Cursor c, int flags) {
if ((flags & FLAG_AUTO_REQUERY) == FLAG_AUTO_REQUERY) {
flags |= FLAG_REGISTER_CONTENT_OBSERVER;
mAutoRequery = true;
} else {
mAutoRequery = false;
}
boolean cursorPresent = c != null;
mCursor = c;
mDataValid = cursorPresent;
mContext = context;
mRowIDColumn = cursorPresent ? c.getColumnIndexOrThrow("_id") : -1;
if ((flags & FLAG_REGISTER_CONTENT_OBSERVER) == FLAG_REGISTER_CONTENT_OBSERVER) {
mChangeObserver = new ChangeObserver();
mDataSetObserver = new MyDataSetObserver();
} else {
mChangeObserver = null;
mDataSetObserver = null;
}
if (cursorPresent) {
if (mChangeObserver != null) c.registerContentObserver(mChangeObserver);
if (mDataSetObserver != null) c.registerDataSetObserver(mDataSetObserver);
}
}
// Create new views (invoked by the layout manager)
@Override
public ViewHolder onCreateViewHolder(final ViewGroup parent,
int viewType) {
// create a new view
final View view = LayoutInflater.from(parent.getContext())
.inflate(R.layout.list_item, parent, false);
// set the view's size, margins, paddings and layout parameters
ViewHolder vh = new ViewHolder(view, mCursor, new ViewHolder.IMyViewHolderClicks() {
@SuppressLint("NewApi")
@Override
public void onClick(Cursor cursor) {
Log.e("Item :", cursor.getString(cursor.getColumnIndex(MyDatabaseHelper.MW_NAAM)));
Intent intent = new Intent(TasksListFragment.this.getActivity(), DetailActivity.class);
intent.putExtra(DetailActivity.EXTRA_PARAM_ID, cursor.getLong(cursor.getColumnIndex(MyDatabaseHelper.MW_ID)));
ActivityOptions activityOptions = ActivityOptions.makeSceneTransitionAnimation(
TasksListFragment.this.getActivity(),
// Now we provide a list of Pair items which contain the view we can transitioning
// from, and the name of the view it is transitioning to, in the launched activity
new Pair<View, String>(
view.findViewById(R.id.imageview_item),
DetailActivity.VIEW_NAME_HEADER_IMAGE),
new Pair<View, String>(
view.findViewById(R.id.textview_name),
DetailActivity.VIEW_NAME_HEADER_TITLE)
);
// Now we can start the Activity, providing the activity options as a bundle
startActivity(intent, activityOptions.toBundle());
// END_INCLUDE(start_activity)
}
});
return vh;
}
// Replace the contents of a view (invoked by the layout manager)
@SuppressLint("NewApi")
@Override
public void onBindViewHolder(ViewHolder holder, int position) {
// - get element from your dataset at this position
// - replace the contents of the view with that element
final Cursor cursor = getItem(position);
holder.mTextView.setText(cursor.getString(cursor.getColumnIndex(MyDatabaseHelper.MW_NAAM)));
holder.mImageView.setTransitionName("grid:image:" + cursor.getLong(cursor.getColumnIndex(MyDatabaseHelper.MW_ID)));
holder.mTextView.setTransitionName("grid:name:" + cursor.getLong(cursor.getColumnIndex(MyDatabaseHelper.MW_ID)));
}
//@Override
// public View getView(int position, View view, ViewGroup viewGroup) {
// return view;
// }
// Return the size of your dataset (invoked by the layout manager)
@Override
public int getItemCount() {
return getCount();
}
public int getCount() {
if (mDataValid && mCursor != null) {
return mCursor.getCount();
} else {
return 0;
}
}
public Cursor getItem(int position) {
if (mDataValid && mCursor != null) {
mCursor.moveToPosition(position);
return mCursor;
} else {
return null;
}
}
@Override
public long getItemId(int position) {
if (mDataValid && mCursor != null) {
if (mCursor.moveToPosition(position)) {
return mCursor.getLong(mRowIDColumn);
} else {
return 0;
}
} else {
return 0;
}
}
public Cursor swapCursor(Cursor newCursor) {
if (newCursor == mCursor) {
return null;
}
Cursor oldCursor = mCursor;
if (oldCursor != null) {
if (mChangeObserver != null) oldCursor.unregisterContentObserver(mChangeObserver);
if (mDataSetObserver != null) oldCursor.unregisterDataSetObserver(mDataSetObserver);
}
mCursor = newCursor;
if (newCursor != null) {
if (mChangeObserver != null) newCursor.registerContentObserver(mChangeObserver);
if (mDataSetObserver != null) newCursor.registerDataSetObserver(mDataSetObserver);
mRowIDColumn = newCursor.getColumnIndexOrThrow("_id");
mDataValid = true;
// notify the observers about the new cursor
notifyDataSetChanged();
} else {
mRowIDColumn = -1;
mDataValid = false;
// notify the observers about the lack of a data set
notifyDataSetInvalidated();
}
return oldCursor;
}
public void changeCursor(Cursor cursor) {
Cursor old = swapCursor(cursor);
if (old != null) {
old.close();
}
}
public CharSequence convertToString(Cursor cursor) {
return cursor == null ? "" : cursor.toString();
}
public Cursor runQueryOnBackgroundThread(CharSequence constraint) {
if (mFilterQueryProvider != null) {
return mFilterQueryProvider.runQuery(constraint);
}
return mCursor;
}
public FilterQueryProvider getFilterQueryProvider() {
return mFilterQueryProvider;
}
public void setFilterQueryProvider(FilterQueryProvider filterQueryProvider) {
mFilterQueryProvider = filterQueryProvider;
}
protected void onContentChanged() {
if (mAutoRequery && mCursor != null && !mCursor.isClosed()) {
if (false) Log.v("Cursor", "Auto requerying " + mCursor + " due to update");
mDataValid = mCursor.requery();
}
}
private class ChangeObserver extends ContentObserver {
public ChangeObserver() {
super(new Handler());
}
@Override
public boolean deliverSelfNotifications() {
return true;
}
@Override
public void onChange(boolean selfChange) {
onContentChanged();
}
}
private class MyDataSetObserver extends DataSetObserver {
@Override
public void onChanged() {
mDataValid = true;
notifyDataSetChanged();
}
@Override
public void onInvalidated() {
mDataValid = false;
notifyDataSetInvalidated();
}
}
private final DataSetObservable mDataSetObservable = new DataSetObservable();
public void registerDataSetObserver(DataSetObserver observer) {
mDataSetObservable.registerObserver(observer);
}
public void unregisterDataSetObserver(DataSetObserver observer) {
mDataSetObservable.unregisterObserver(observer);
}
public void notifyDataSetInvalidated() {
mDataSetObservable.notifyInvalidated();
}
}
- Arno van Lieshout
6
这个类中的加载器在哪里？ - IgorGanapolsky
加载器将使用此适配器。请参阅http://developer.android.com/guide/components/loaders.html，了解如何使用加载器的示例。在此示例中，SimpleCursorAdapter将是MyAdapter。 - Arno van Lieshout
什么意思SimpleCursorAdapter？你正在扩展RecyclerView.Adapter。 - IgorGanapolsky
1我的意思是，如果你在示例中看到了SimpleCursorAdapter，你可以把MyAdapter放在那个位置。只要它有swapcursor方法和其他一些方法，无论你扩展哪个适配器都没有关系。 - Arno van Lieshout
与@nbtk上面的答案相比，似乎有点过度编码。 - eRaisedToX
仍然存在一个问题，即每次发生任何更改都需要使用
notifyDataSetChanged()。这会删除RecyclerView提供的自动动画，并且效率非常低下。你还不如使用ListView。 - SMBiggs1
- Jakob Eriksson
1
这是另一个答案，因为我不喜欢被接受的答案（在我看来使用不够直观）。
以下是我的实现，与 SimpleCursorAdapter 非常相似，并且部分灵感来自它：
public class RecyclerViewSimpleCursorAdapter extends RecyclerView.Adapter {
private int mLayout;
private Cursor mCursor;
private String[] mFrom;
private int[] mTo;
private boolean mAutoRequery;
private ContentObserver mContentObserver;
/**
* Standard constructor.
*
* @param layout resource identifier of a layout file that defines the views for this list item. The layout file should include at least those named views defined in "to"
* @param c The database cursor. Can be null if the cursor is not available yet.
* @param from A list of column names representing the data to bind to the UI. Can be null if the cursor is not available yet.
* @param to The views that should display column in the "from" parameter. These should all be TextViews and ImageViews. The first N views in this list are given the values of the first N columns in the from parameter. Can be null if the cursor is not available yet.
*/
public RecyclerViewSimpleCursorAdapter(int layout, Cursor c, String[] from, int[] to, boolean autoRequery) {
mLayout = layout;
mCursor = c;
mFrom = from;
mTo = to;
mAutoRequery = autoRequery;
if (mAutoRequery) {
initializeContentObserver();
}
}
@Override
public RecyclerView.ViewHolder onCreateViewHolder(ViewGroup parent, int viewType) {
return new RecyclerView.ViewHolder(
LayoutInflater.from(parent.getContext())
.inflate(mLayout, parent, false)
) {
};
}
@Override
public void onBindViewHolder(RecyclerView.ViewHolder holder, int position) {
mCursor.moveToPosition(position);
if (mFrom == null || mTo == null)
return;
for (int i = 0; i < mFrom.length && i < mTo.length; i++) {
String from = mFrom[i];
int columnIndex = mCursor.getColumnIndex(from);
String value = mCursor.getString(columnIndex);
View view = holder.itemView.findViewById(mTo[i]);
if (view instanceof TextView) {
((TextView) view).setText(value);
} else if (view instanceof ImageView) {
try {
((ImageView) view).setImageResource(Integer.parseInt(value));
} catch (NumberFormatException nfe) {
((ImageView) view).setImageURI(Uri.parse(value));
}
} else {
throw new IllegalStateException(view.getClass().getName() + " is not a view that can be bound by this RecyclerViewSimpleCursorAdapter");
}
}
}
@Override
public int getItemCount() {
return mCursor != null ? mCursor.getCount() : 0;
}
private void initializeContentObserver() {
mContentObserver = new ContentObserver(new Handler()) {
@Override
public boolean deliverSelfNotifications() {
return true;
}
@Override
public void onChange(boolean selfChange) {
notifyDataSetChanged();
}
};
mCursor.registerContentObserver(mContentObserver);
}
/**
* Change the underlying cursor to a new cursor. If there is an existing cursor it will be closed.
*
* @param cursor The new cursor to be used
*/
public void changeCursor(Cursor cursor) {
Cursor oldCursor = mCursor;
if (mAutoRequery) {
if (mCursor != null) {
mCursor.unregisterContentObserver(mContentObserver);
}
mContentObserver = new ContentObserver(new Handler()) {
@Override
public boolean deliverSelfNotifications() {
return true;
}
@Override
public void onChange(boolean selfChange) {
notifyDataSetChanged();
}
};
mCursor = cursor;
if (mCursor != null) {
mCursor.registerContentObserver(mContentObserver);
}
}
notifyDataSetChanged();
if (oldCursor != null && oldCursor != mCursor) {
oldCursor.close();
}
}
/**
* Change the cursor and change the column-to-view mappings at the same time.
*
* @param cursor The database cursor. Can be null if the cursor is not available yet.
* @param from A list of column names representing the data to bind to the UI. Can be null if the cursor is not available yet.
* @param to The views that should display column in the "from" parameter. These should all be TextViews or ImageViews. The first N views in this list are given the values of the first N columns in the from parameter. Can be null if the cursor is not available yet.
*/
public void changeCursorAndColumns(Cursor cursor, String[] from, int[] to) {
mFrom = from;
mTo = to;
changeCursor(cursor);
}
/**
* Returns the cursor.
* @return the cursor
*/
public Cursor getCursor() {
return mCursor;
}
}
你可以根据其他特定的用途进行修改，但是只要有光标，它就像
SimpleCursorAdapter 一样工作，只不过是在 RecyclerView 中。- Massimo
0
以下是我为RecyclerView实现的CursorAdapter。
它支持OnItemClickListener、OnLongItemClickListener、OnfooterClickListener、Sections和footer。不支持Header、onHeaderClickListner、快速滚动、粘性标头或粘性片段。
只需扩展此适配器并创建自己的适配器。覆盖提供的方法并从OnCursorLoadFinished方法传递游标。如果适配器已经创建，则使用swapCursor()进行替换。
只需扩展此适配器并创建自己的适配器。覆盖提供的方法并从OnCursorLoadFinished方法传递游标。如果适配器已经创建，则使用swapCursor()进行替换。
package com.tracker.paisa;
import android.database.Cursor;
import android.support.v7.widget.GridLayoutManager;
import android.support.v7.widget.RecyclerView;
import android.util.Log;
import android.util.SparseBooleanArray;
import android.view.ViewGroup;
import java.util.ArrayList;
import java.util.List;
/**
* @author Rahul Upadhyay (https://github.com/devDroidRaul)
* Supports footer
* Onitemclicklistener, OnItemLongClickListener, OnFooterClickListener
* Supports Sections.
*
* Does Not support,Header, OnHeaderClickListener, FastScroller, StickySection (this can b done with item decor)
* Pull requests are welcome for improvements.
*
* Override this to give logic to place subheaders between items.
* public abstract boolean onPlaceSubheaderBetweenItems(int position);
*
* create seperate viewHolders for item, subheaders and footer. and return required views.
*
* @Override below methods for individual item type.
* public abstract VH onCreateItemViewHolder(ViewGroup parent, int viewType);
* public abstract SH onCreateSubheaderViewHolder(ViewGroup parent, int viewType);
* public abstract FH onCreateFooterViewHolder(ViewGroup parent, int viewType);
*
* Bind your views with data here.
* @Override below methods to bind data to individual item types.
* public abstract void onBindSubHeaderViewHolder(SH holder, Cursor cursor);
* public abstract void onBindItemViewHolder(VH holder, Cursor cursor);
* public abstract void onBindFooterViewHolder(FH holder, int itemPosition);
*
* Item type -1,-2,-3 are reserved, kindly do not pass them in getItemViewType.
*/
public abstract class RecyclerViewCursorAdapter<SH extends RecyclerView.ViewHolder, VH extends RecyclerView.ViewHolder, FH extends RecyclerView.ViewHolder>
extends RecyclerView.Adapter<RecyclerView.ViewHolder> {
public static final String TAG = RecyclerViewCursorAdapter.class.getSimpleName();
private static final int TYPE_SECTION_HEADER = -1;
private static final int TYPE_MAIN_HEADER = -2;
private static final int TYPE_FOOTER = -3;
// private int headerLayout=0,viewLayout=0;
boolean createHeader;
private List<Integer> subheaderPositions = new ArrayList<>();
private Cursor mCursor;
private boolean mDataValid,footerRequired=false;
private int mRowIDColumn;
private SparseBooleanArray mSelectedItemsIds;
// public RecyclerViewCursorAdapter() { }
//constructor
public RecyclerViewCursorAdapter(Cursor c,boolean footerRequired) {
setHasStableIds(true);
swapCursor(c);
this.footerRequired = footerRequired;
this.mSelectedItemsIds = new SparseBooleanArray();
}
// interface for listning click on recycler view;
public interface OnItemClickedListener{
void OnItemClick(int id, Object data);
void onItemLongClick(int id);
}
OnItemClickedListener onItemClickedListener;
public void setOnItemClickedListener(OnItemClickedListener onItemClickedListener) {
this.onItemClickedListener = onItemClickedListener;
}
public interface OnFooterClickedListener{
void onFooterClick(Object data);
}
OnFooterClickedListener onFooterClickedListener;
public void setOnFooterClickedListener( OnFooterClickedListener onFooterClickedListener){
this.onFooterClickedListener = onFooterClickedListener;
}
public interface OnHeaderClickedListener{
void onHeaderClick(Object data);
}
OnHeaderClickedListener onHeaderClickedListener;
public void setOnHeaderClickedListener( OnHeaderClickedListener onHeaderClickedListener){
this.onHeaderClickedListener = onHeaderClickedListener;
}
private void initSubheaderPositions() {
subheaderPositions.clear();
if(getItemSize() != 0) {
//TODO:Handle This please.
//subheaderPositions.add(0);
} else {
return;
}
for(int i = 1; i < getItemSize(); i++) {
if(onPlaceSubheaderBetweenItems(i - 1)) {
subheaderPositions.add(i + subheaderPositions.size());
}
}
}
@Override
public void onAttachedToRecyclerView(RecyclerView recyclerView) {
initSubheaderPositions();
}
/**
* Called when adapter needs to know whether to place subheader between two neighboring
* items.
*
* @return true if you want to place subheader between two neighboring
* items.
*/
public abstract boolean onPlaceSubheaderBetweenItems(int position);
public abstract VH onCreateItemViewHolder(ViewGroup parent, int viewType);
public abstract SH onCreateSubheaderViewHolder(ViewGroup parent, int viewType);
public abstract FH onCreateFooterViewHolder(ViewGroup parent, int viewType);
public abstract void onBindSubHeaderViewHolder(SH holder, Cursor cursor);
public abstract void onBindItemViewHolder(VH holder, Cursor cursor);
public abstract void onBindFooterViewHolder(FH holder, int itemPosition);
public abstract int getItemSize();
/**
* Return the view type of the item at position for the purposes
* of view recycling.
* Don't return -1. It's reserved for subheader view type.
*/
public int getViewType(int position) {
return 0;
}
@Override
public final int getItemViewType(int position) {
if(isSubheaderOnPosition(position)) {
return TYPE_SECTION_HEADER;
} if(footerRequired && getCursor().getPosition()==(getCursor().getCount()-1)){
return TYPE_FOOTER;
}else {
return getViewType(position);
}
}
public boolean isFooterAdded(){
return footerRequired;
}
@Override
public final RecyclerView.ViewHolder onCreateViewHolder(ViewGroup parent, int viewType) {
Log.d("RVCA-OCVH","create viewholder");
if(viewType == TYPE_SECTION_HEADER) {
return onCreateSubheaderViewHolder(parent, viewType);
} if(footerRequired&&viewType == TYPE_FOOTER){
return onCreateFooterViewHolder(parent, viewType);
}else {
return onCreateItemViewHolder(parent, viewType);
}
}
@SuppressWarnings("unchecked")
@Override
public final void onBindViewHolder(RecyclerView.ViewHolder holder, int position) {
Log.d("RVCA-OBVH","bind viewholder");
Log.d("RVCA-OBVH","subheader position:"+isSubheaderOnPosition(position));
if(isSubheaderOnPosition(position)) {
if (!mDataValid) {
throw new IllegalStateException("Cannot bind viewholder when cursor is in invalid state.");
}
if (!mCursor.moveToPosition(getItemPositionForViewHolder(position))) {
throw new IllegalStateException("Could not move cursor to position " + getItemPositionForViewHolder(position) + " when trying to bind viewholder");
}
onBindSubHeaderViewHolder((SH)holder, mCursor);
}if(footerRequired && position==getItemCount()-1){
Log.d("RVCA-OBVH","bind footerHolder");
onBindFooterViewHolder((FH) holder,position);
} else {
if (!mDataValid) {
throw new IllegalStateException("Cannot bind viewholder when cursor is in invalid state.");
}
if (!mCursor.moveToPosition(getItemPositionForViewHolder(position))) {
throw new IllegalStateException("Could not move cursor to position " + getItemPositionForViewHolder(position) + " when trying to bind viewholder");
}
// if(!mCursor.isAfterLast()) {
// mCursor.moveToPosition(position);
onBindItemViewHolder((VH)holder, mCursor);
}
}
@Override
public final int getItemCount() {
return getItemSize() + subheaderPositions.size()+(footerRequired?1:0);
}
public void notifyDataChanged() {
initSubheaderPositions();
notifyDataSetChanged();
}
public void notifyItemInsertedAtPosition(int itemPosition) {
if (itemPosition == 0) {
if (getItemCount() == 1 || onPlaceSubheaderBetweenItems(itemPosition)) {
subheaderPositions.add(0, 0);
increaseSubheaderPositions(1, 2);
notifyItemRangeInserted(0, 2);
} else {
increaseSubheaderPositions(1, 1);
notifyItemInserted(1);
}
} else if (itemPosition == getItemSize() - 1) {
if (onPlaceSubheaderBetweenItems(itemPosition - 1)) {
subheaderPositions.add(getItemCount() - 1);
notifyItemRangeInserted(getItemCount() - 1, 2);
} else {
notifyItemInserted(getItemPositionInRecyclerView(itemPosition));
}
} else {
if (onPlaceSubheaderBetweenItems(itemPosition - 1) && onPlaceSubheaderBetweenItems(itemPosition)) {
final int itemPositionInRv = getItemPositionInRecyclerView(itemPosition - 1);
final int countOfSubheadersBeforePosition = getCountOfSubheadersBeforePosition(itemPositionInRv);
subheaderPositions.add(countOfSubheadersBeforePosition, itemPositionInRv + 1);
increaseSubheaderPositions(countOfSubheadersBeforePosition + 1, 2);
notifyItemRangeInserted(itemPositionInRv + 1, 2);
} else if (onPlaceSubheaderBetweenItems(itemPosition)){
final int itemPositionInRv = getItemPositionInRecyclerView(itemPosition - 1);
increaseSubheaderPositions(getCountOfSubheadersBeforePosition(itemPositionInRv), 1);
notifyItemInserted(itemPositionInRv + 1);
} else if (onPlaceSubheaderBetweenItems(itemPosition - 1)) {
final int itemPositionInRv = getItemPositionInRecyclerView(itemPosition);
increaseSubheaderPositions(getCountOfSubheadersBeforePosition(itemPositionInRv), 1);
notifyItemInserted(itemPositionInRv);
} else {
final int itemPositionInRv = getItemPositionInRecyclerView(itemPosition);
increaseSubheaderPositions(getCountOfSubheadersBeforePosition(itemPositionInRv), 1);
notifyItemInserted(itemPositionInRv);
}
}
}
public void notifyItemChangedAtPosition(int itemPosition) {
final int itemPositionInRv = getItemPositionInRecyclerView(itemPosition);
notifyItemChanged(itemPositionInRv);
}
public void notifyItemRemovedAtPosition(int itemPosition) {
final int itemPositionInRv = getItemPositionInRecyclerView(itemPosition);
for (int i = 1; i < subheaderPositions.size(); i++) {
final int subheaderPosition = subheaderPositions.get(i);
if (subheaderPosition > itemPositionInRv) {
final int previousSubheaderPosition = subheaderPositions.get(i - 1);
if (subheaderPosition - previousSubheaderPosition == 2) {
subheaderPositions.remove(subheaderPositions.indexOf(previousSubheaderPosition));
decreaseSubheaderPositions(subheaderPositions.indexOf(subheaderPosition), 2);
notifyItemRangeRemoved(itemPositionInRv - 1, 2);
} else {
decreaseSubheaderPositions(subheaderPositions.indexOf(subheaderPosition), 1);
notifyItemRemoved(itemPositionInRv);
}
return;
}
}
final int lastSubheaderPosition = subheaderPositions.get(subheaderPositions.size() - 1);
if (itemPositionInRv - lastSubheaderPosition == 1 && getItemCount() == itemPosition + subheaderPositions.size()) {
subheaderPositions.remove(subheaderPositions.size() - 1);
notifyItemRangeRemoved(itemPositionInRv - 1, 2);
} else {
notifyItemRemoved(itemPositionInRv);
}
}
public void setGridLayoutManager(final GridLayoutManager gridLayoutManager) {
gridLayoutManager.setSpanSizeLookup(new GridLayoutManager.SpanSizeLookup() {
@Override
public int getSpanSize(int position) {
if(subheaderPositions.contains(position)) {
return gridLayoutManager.getSpanCount();
} else {
return 1;
}
}
});
}
public boolean isSubheaderOnPosition(int position) {
return subheaderPositions.contains(position);
}
public int getCountOfSubheadersBeforePosition(int position) {
int count = 0;
for(int subheaderPosition : subheaderPositions) {
if(subheaderPosition < position) {
count++;
}
}
return count;
}
public int getItemPositionInRecyclerView(int position) {
int countOfItems = 0;
for (int i = 1; i < subheaderPositions.size(); i++) {
final int previousSubheaderPosition = subheaderPositions.get(i - 1);
final int nextSubheaderPosition = subheaderPositions.get(i);
countOfItems += nextSubheaderPosition - previousSubheaderPosition - 1;
if (countOfItems > position) {
return position + i;
}
}
return position + subheaderPositions.size();
}
public int getItemPositionForViewHolder(int viewHolderPosition) {
return viewHolderPosition - getCountOfSubheadersBeforePosition(viewHolderPosition);
}
private void decreaseSubheaderPositions(int startSubheaderPosition, int decreaseNum) {
for (int i = startSubheaderPosition; i < subheaderPositions.size(); i++) {
final int subheaderPosition = subheaderPositions.get(i);
subheaderPositions.set(i, subheaderPosition - decreaseNum);
}
}
private void increaseSubheaderPositions(int startSubheaderPosition, int increaseNum) {
for (int i = startSubheaderPosition; i < subheaderPositions.size(); i++) {
final int subheaderPosition = subheaderPositions.get(i);
subheaderPositions.set(i, subheaderPosition + increaseNum);
}
}
private List<Integer> getSubheaderPositions() {
return subheaderPositions;
}
public int getSubheaderCount() {
return subheaderPositions.size();
}
public void swapCursor(Cursor newCursor) {
Log.d("RVCA-SC","swap cursor");
if (newCursor == mCursor) {
Log.d("RVCA-SC","same cursor doing nothing");
return;
}
if (newCursor != null) {
Log.d("RVCA-SC","swap cursor not null");
mCursor = newCursor;
mRowIDColumn = mCursor.getColumnIndexOrThrow("_id");
mDataValid = true;
// notify the observers about the new cursor
notifyDataChanged();
} else {
Log.d("RVCA-SC","swap cursor null");
notifyItemRangeRemoved(0, getItemCount());
mCursor = null;
mRowIDColumn = -1;
mDataValid = false;
}
}
public Cursor getCursor(){
return mCursor ;
}
@Override
public long getItemId(int position) {
if (isSubheaderOnPosition(position))
return position;
else {
int cursorPosition = getItemPositionForViewHolder(position);
Cursor cursor = getCursor();
if (hasOpenCursor() && cursor.moveToPosition(cursorPosition)) {
return cursor.getLong(cursor.getColumnIndex("_id"));
}
return NO_CURSOR_POSITION;
}
}
public static final int NO_CURSOR_POSITION = -99;
protected boolean hasOpenCursor() {
Cursor cursor = getCursor();
if (cursor == null || cursor.isClosed()) {
swapCursor(null);
return false;
}
return true;
}
//Methods to do Selection
public void toggleSelection(int position) {
selectView(position, !mSelectedItemsIds.get(position));
}
//Remove selected selections
public void removeSelection() {
mSelectedItemsIds = new SparseBooleanArray();
notifyDataSetChanged();
}
//Put or delete selected position into SparseBooleanArray
public void selectView(int position, boolean value) {
if (value)
mSelectedItemsIds.put(position, value);
else
mSelectedItemsIds.delete(position);
// notifyItemChangedAtPosition(position);
notifyDataSetChanged();
}
//Get total selected count
public int getSelectedCount() {
return mSelectedItemsIds.size();
}
//Return all selected ids
public SparseBooleanArray getSelectedIds() {
return mSelectedItemsIds;
}
public void setSelectedItemIds(SparseBooleanArray selectedItemIds){
this.mSelectedItemsIds=selectedItemIds;
}
}
- Dev Raul
0
最简单的实现方法是在适配器中使用游标对象，并将游标传递给viewholder构造函数以修改视图，并在onBindViewholder中更改游标位置。
如果您正在使用游标加载器，请在onLoadfinished()中调用setCursor方法，并在onLoadReset()中传递null。
public class PetCursorRecyclerViewAdapter extends RecyclerView.Adapter<PetCursorRecyclerViewAdapter.ViewHolder> {
Cursor cursor = null;
Context context;
public PetCursorRecyclerViewAdapter(Context context) {
this.context = context;
}
public void setCursor(Cursor cursor) {
this.cursor = cursor;
notifyDataSetChanged();
}
@Override
public ViewHolder onCreateViewHolder(ViewGroup parent, int viewType) {
View v = LayoutInflater.from(context).inflate(R.layout.catalog_item, parent, false);
return new ViewHolder(v);
}
@Override
public void onBindViewHolder(ViewHolder holder, int position) {
this.cursor.moveToPosition(position);
holder.bindModel(this.cursor);
}
/* getItemCount() returns the count of videos from the Cursor, or 0 if the
Cursor is null (mimicking the behavior of CursorAdapter, which also treats
a null Cursor as merely being one that has no rows)*/
@Override
public int getItemCount() {
if (cursor == null) {
return 0;
} else {
return cursor.getCount();
}
}
public static class ViewHolder extends RecyclerView.ViewHolder {
private TextView name_tv, breed_tv;
public ViewHolder(View itemView) {
super(itemView);
name_tv = (TextView) itemView.findViewById(R.id.name_tv);
breed_tv = (TextView) itemView.findViewById(R.id.breed_tv);
}
public void bindModel(Cursor cursor) {
int name_index = cursor.getColumnIndexOrThrow(PetsContract.PetEntry.COLUMN_PET_NAME);
int breed_index = cursor.getColumnIndexOrThrow(PetsContract.PetEntry.COLUMN_PET_BREED);
name_tv.setText(cursor.getString(name_index));
String breed = cursor.getString(breed_index);
if (TextUtils.isEmpty(breed)) {
breed = "Unknown Breed";
}
breed_tv.setText(breed);
}
}
}
- KingKongCoder
0
终于我们有了一个针对数据库/网络的RecyclerView.Adapter实现。
它是用Android 架构组件实现的:
Room数据库: 在SQLite数据库之上的数据库层，处理您以前使用SQLiteOpenHelper处理的琐碎任务。作为访问底层SQLite数据库的访问点的数据库持有者。 Room数据库使用DAO向SQLite数据库发出查询。
ViewModel: 为UI提供数据。充当Repository和UI之间的通信中心。隐藏数据从UI来自的位置。 ViewModel实例在Activity / Fragment重建时仍然存在。
LiveData: 可以被观察的数据持有器类。始终保存/缓存数据的最新版本。当数据发生更改时，通知其观察者。 LiveData具有生命周期感知能力。 UI组件只观察相关数据，并且不会停止或恢复观察。 LiveData自动管理所有这些，因为它在观察时知道相关的生命周期状态更改。
- Leo240
0
从数据库中检索数据并存储在列表中后，可能应该是这样的：
dbHelper = new BooksDbAdapter(this);
dbHelper.open();
//Clean all data
dbHelper.deleteAllZist();
//Add some data
dbHelper.insertSomeRecords();
List<String> mylist = dbHelper.getArrayColumn(3);
将数据添加到recyclerview
list = new ArrayList<DataObject>();
Integer i=0;
for (String lst : mylist) {
list.add(i++, new DataObject(lst,
"The RecyclerView widget is a more advanced and flexible
version of ListView."));
}
recyclerView = (RecyclerView) findViewById(R.id.recyclerview);
recyclerView.setHasFixedSize(true);
myRecAdapter = new RecyclerviewAdapter(list, Zist1ChapterActivity.this);
- josef
网页内容由stack overflow 提供, 点击上面的可以查看英文原文，
原文链接
原文链接
- 相关问题
- 5 RecyclerView Adapter 和 RecyclerView LayoutManager 的职责和区别分别是什么？
- 70 使用GridLayoutManager和RecyclerView更改列数
- 4 使用RecyclerView加载图片和视频
- 4 使用SortedList和RecyclerView更改排序顺序
- 3 在ViewPager中使用RecyclerView和ExpandableListView
- 5 如何使用RecyclerView和CardView
- 65 RecyclerView和SwipeRefreshLayout
- 67 使用RecyclerView和CardView实现触摸反馈
- 13 使用RecyclerView和CardView
- 6 在另一个RecyclerView中使用RecyclerView
setHasStableIds(true)，则动画效果会很好。 - alders