Hi, I am trying to save a row from a RecyclerView into a in a Database.
However I ran into some issues and would really appreciate it if you were
able to help me. As I said I am saving a row in a RecyclerView with the
click of a button. Each row has two TextView and two ImageView. Each row
also opens a separate that gives you more details about the row you
selected. The row that's saved will appear in a Fragment with a
RecyclerView. Currently my app is crashing and I am unable to save the row
because I am unable to locate a suitable solution to save the Images in the
Database. Thus far I read that I can save the images as a Blob but based on
my readings Blob takes up a lot of internal memory. I also read that I can
save the Images locally and refer to them via String path but the examples
that I have seen is of no help. Hence I am left to reply on the Blob
solution but it’s yet to work.
Please see the classes below:
ViewRecipe:
protected int icon, bookmark;
private String title, desp;
public ViewRecipe() {
super();
}
public ViewRecipe(int icon, String title, String desp,int bookmark) {
super();
this.setIcon(icon);
this.setBookmark(bookmark);
this.setTitle(title);
this.setDesp(desp);
}
public int getIcon() {
return icon;
}
public void setIcon(int icon) {
this.icon = icon;
}
public int getBookmark() {
return bookmark;
}
public void setBookmark(int bookmark) {
this.bookmark = bookmark;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getDesp() {
return desp;
}
public void setDesp(String desp) {
this.desp = desp;
}
@Override
public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result + icon;
return result;
}
@Override
public boolean equals(Object obj) {
if (this == obj)
return true;
if (obj == null)
return false;
if (getClass() != obj.getClass())
return false;
return true;
}
@Override
public String toString() {
return "ViewRecipe [icon=" + icon + ", bookmark=" + bookmark + ", title="
+ title + ", desp=" + desp + "]";
}
DBHelper:
public static final String DATABASE_NAME = "Recipe.db";
public static final String RECIPE_TABLE = "recipe_table";
public static final String RECIPE_ID = "RECIPE_ID";
public static final String RECIPE_ICON = "RECIPE_ICON";
public static final String RECIPE_TITLE = "RECIPE_TITLE";
public static final String RECIPE_DESCRIPTION = "RECIPE_DESCRIPTION";
public static final String RECIPE_FAVOURITE = "RECIPE_FAVOURITE";
public static final int DB_VERSION = 1;
public DBHelper(Context context) {
super(context, DATABASE_NAME, null, DB_VERSION);
}
@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
sqLiteDatabase.execSQL("create table " + RECIPE_TABLE + " (RECIPE_ICON
BLOB,RECIPE_TITLE TEXT PRIMARY KEY, RECIPE_DESCRIPTION TEXT,
RECIPE_FAVOURITE BLOB)");
}
@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
sqLiteDatabase.execSQL("DROP TABLE IF EXIST " + RECIPE_TABLE);
onCreate(sqLiteDatabase);
}
public void insertData(byte[] icon, String title, String desp, byte[]
fav)throws SQLiteException {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues contentValues = new ContentValues();
contentValues.put(RECIPE_ICON, icon);
contentValues.put(RECIPE_TITLE, title);
contentValues.put(RECIPE_DESCRIPTION, desp);
contentValues.put(RECIPE_FAVOURITE, fav);
db.insert(RECIPE_TABLE, null, contentValues);
db.close();
//long results=
//if (results == -1)
// return false;
//else
// return true;
}
public Cursor getAllData(SQLiteDatabase db) {
db = this.getReadableDatabase();
Cursor res = db.rawQuery("select * from " + RECIPE_TABLE, null);
//byte[] icon =res.getBlob(1);
//String title = res.getString(2);
//String desp = res.getString(3);
//byte[] fav = res.getBlob(4);
return res;
}
RecyclerAdapter:
private LayoutInflater mInflater;
private List<ViewRecipe> viewRecipes = Collections.emptyList();
private Context mContext;
private ClickedListener clickedListener;
private LongClickedListener longClickedListener;
private DBHelper mDBHelper;
public AdapterFavourite(Context context, List<ViewRecipe> data) {
this.mContext = context;
mInflater = LayoutInflater.from(context);
this.viewRecipes = data;
mDBHelper = new DBHelper(mContext);
}
@Override
public VHFavourite onCreateViewHolder(ViewGroup parent, int viewType) {
View v = mInflater.inflate(R.layout.item_recipe, parent, false);
VHFavourite layout = new VHFavourite(v);
return layout;
}
@Override
public void onBindViewHolder(VHFavourite holder, int position) {
ViewRecipe current = viewRecipes.get(position);
Picasso.with(mContext).load(viewRecipes.get(position).getIcon()).resize(80,
80).into(holder.icon);
holder.title.setText(current.getTitle());
holder.desp.setText(current.getDesp());
holder.favourite.setImageResource(current.getBookmark());
}
public void setClickedListener(ClickedListener clickedListener) {
this.clickedListener = clickedListener;
}
public void setLongClickedListener(LongClickedListener longClickedListener)
{
this.longClickedListener = longClickedListener;
}
@Override
public int getItemCount() {
return viewRecipes.size();
}
public class VHFavourite extends RecyclerView.ViewHolder implements
View.OnClickListener, View.OnLongClickListener {
private ImageView icon, favourite;
private TextView title, desp;
public VHFavourite(View itemView) {
super(itemView);
icon = (ImageView) itemView.findViewById(R.id.imgRecipeIC);
title = (TextView) itemView.findViewById(R.id.txtRecipeTitle);
desp = (TextView) itemView.findViewById(R.id.txtRecipeDesp);
favourite = (ImageView) itemView.findViewById(R.id.imgFavourite);
itemView.setOnClickListener(this);
favourite.setOnLongClickListener(this);
}
@Override
public void onClick(View view) {
if (clickedListener != null) {
clickedListener.itemClicked(view, getPosition());
}
}
@Override
public boolean onLongClick(View view) {
if (longClickedListener != null) {
longClickedListener.longClicked(view, getPosition());
}
// mDBHelper.insertData(icon.getBl.toString(), title.getText().toString(),
// desp.getText().toString(), favourite.getDrawable().toString());
boolean isInserted = true;
if (isInserted == true)
Toast.makeText(mContext, "Favorite Added", Toast.LENGTH_LONG).show();
else
Toast.makeText(mContext, "Favorite Removed", Toast.LENGTH_LONG).show();
return false;
}
}
public interface ClickedListener {
public void itemClicked(View view, int position);
}
public interface LongClickedListener {
public void longClicked(View view, int position);
}
Fragment That Shows the Data Saved:
public static final String ARG_ITEM_ID = "favorite_list";
private RecyclerView mRecycler;
private TextView txtFav;
private SharedPreference sharedPreference;
private DBHelper mDBHelper;
private List<ViewRecipe> favorites;
private AdapterRecipe mAdapter;
private AdapterFavourite adapter;
private LinearLayoutManager mLayout;
@Nullable
@Override
public View onCreateView(LayoutInflater inflater, @Nullable ViewGroup
container, @Nullable Bundle savedInstanceState) {
View layout = inflater.inflate(R.layout.frag_favourite, container, false);
mRecycler = (RecyclerView) layout.findViewById(R.id.recyclerFav);
txtFav = (TextView) layout.findViewById(R.id.txtFav);
DBFavRecipes();
return layout;
}
private void DBFavRecipes() {
mRecycler.setNestedScrollingEnabled(false);
mLayout = new LinearLayoutManager(getContext());
mRecycler.setHasFixedSize(true);
mRecycler.setItemAnimator(new DefaultItemAnimator());
mDBHelper = new DBHelper(getActivity());
SQLiteDatabase sqLiteDatabase = mDBHelper.getReadableDatabase();
Cursor cursor = mDBHelper.getAllData(sqLiteDatabase);
if (cursor.getCount() == 0) {
txtFav.setText(R.string.fav_unavailable);
return;
} else {
if (cursor != null) {
if (cursor.moveToFirst()) {
do {
ViewRecipe recipe = new ViewRecipe();
recipe.setIcon(cursor.getInt(0));
recipe.setTitle(cursor.getString(1));
recipe.setDesp(cursor.getString(2));
recipe.setBookmark(cursor.getInt(3));
favorites.add(recipe);
} while (cursor.moveToNext());
mDBHelper.close();
}
}
}
adapter = new AdapterFavourite(getContext(), favorites);
mRecycler.setAdapter(adapter);
mRecycler.setLayoutManager(mLayout);
}
The app crashed whenever it reaches recipe.setBookmark(cursor.getInt(3));
in the Fragment Class. I have tried everything and I am unable to solve
this issue and hope you can assist me please. Thanks for you help so far.
--
You received this message because you are subscribed to the Google Groups
"Android Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/android-developers.
To view this discussion on the web visit
https://groups.google.com/d/msgid/android-developers/6fafc24b-c731-4289-9a7c-db8176868ec3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
