开发中Android简易壁纸应用添加收藏按钮功能求助（SQLite+Picasso）

Hey there! Let's walk through adding the favorite feature to your wallpaper app step by step—since you're already using SQLite and Picasso, this should fit right into your existing setup.

Step 1: Update Your SQLite Database #

You have two solid options here depending on how you want to structure your data:

Option 1: Add a Favorite Flag to Your Existing Wallpaper Table #

This is the simplest approach for a small app. Just add a boolean-like column to your existing table to track favorite status:

-- Run this SQL to modify your existing wallpapers table
ALTER TABLE wallpapers ADD COLUMN is_favorite INTEGER DEFAULT 0;
-- 0 = not favorite, 1 = favorite

Option 2: Create a Separate Favorites Table #

If you want to keep your main wallpapers table clean or plan to add extra metadata for favorites later, use a dedicated table:

CREATE TABLE favorites (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    image_url TEXT UNIQUE NOT NULL -- Prevents duplicate entries for the same wallpaper
);

Step 2: Add Database Operation Methods (DAO Layer) #

Assuming you have a DBHelper class extending SQLiteOpenHelper, add these methods to handle favorite actions:

For Option 1 (Flag Column): #

// Toggle favorite status (switch between favorite and not favorite)
public void toggleFavorite(String imageUrl) {
    SQLiteDatabase db = this.getWritableDatabase();
    
    // Check current status
    Cursor cursor = db.rawQuery("SELECT is_favorite FROM wallpapers WHERE image_url = ?", new String[]{imageUrl});
    boolean isCurrentlyFavorite = false;
    if (cursor.moveToFirst()) {
        isCurrentlyFavorite = cursor.getInt(0) == 1;
    }
    cursor.close();
    
    // Update status
    ContentValues values = new ContentValues();
    values.put("is_favorite", isCurrentlyFavorite ? 0 : 1);
    db.update("wallpapers", values, "image_url = ?", new String[]{imageUrl});
    db.close();
}

// Check if a wallpaper is already favorited
public boolean isFavorite(String imageUrl) {
    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cursor = db.rawQuery("SELECT is_favorite FROM wallpapers WHERE image_url = ?", new String[]{imageUrl});
    boolean isFavorite = false;
    if (cursor.moveToFirst()) {
        isFavorite = cursor.getInt(0) == 1;
    }
    cursor.close();
    db.close();
    return isFavorite;
}

For Option 2 (Separate Table): #

// Add a wallpaper to favorites
public void addToFavorite(String imageUrl) {
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put("image_url", imageUrl);
    try {
        db.insertOrThrow("favorites", null, values);
    } catch (SQLiteConstraintException e) {
        // Ignore duplicate entries
    }
    db.close();
}

// Remove a wallpaper from favorites
public void removeFromFavorite(String imageUrl) {
    SQLiteDatabase db = this.getWritableDatabase();
    db.delete("favorites", "image_url = ?", new String[]{imageUrl});
    db.close();
}

// Check if a wallpaper is already favorited
public boolean isFavorite(String imageUrl) {
    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cursor = db.rawQuery("SELECT * FROM favorites WHERE image_url = ?", new String[]{imageUrl});
    boolean isFavorite = cursor.getCount() > 0;
    cursor.close();
    db.close();
    return isFavorite;
}

Step 3: Handle the Favorite Button in Your UI #

Whether you're adding the button to a RecyclerView list item or a wallpaper detail page, follow these steps:

1. Set Initial Button State
   When binding your wallpaper data, set the button icon based on the current favorite status:

   // Inside your RecyclerView.ViewHolder's bind method
   String imageUrl = wallpaperItem.getImageUrl();
   boolean isFav = dbHelper.isFavorite(imageUrl);
   // Replace with your actual drawable resources
   favoriteBtn.setImageResource(isFav ? R.drawable.ic_favorite_filled : R.drawable.ic_favorite_outline);
   

2. Add Click Listener to Toggle Favorites
   Always run database operations off the main thread to avoid ANRs! Here's how to do it with a thread and runOnUiThread:

   favoriteBtn.setOnClickListener(v -> {
       new Thread(() -> {
           boolean newFavStatus = !isFav;
           
           // Update database
           if (newFavStatus) {
               dbHelper.addToFavorite(imageUrl); // Use toggleFavorite() for Option 1
           } else {
               dbHelper.removeFromFavorite(imageUrl);
           }
           
           // Update UI on main thread
           ((Activity) context).runOnUiThread(() -> {
               isFav = newFavStatus;
               favoriteBtn.setImageResource(isFav ? R.drawable.ic_favorite_filled : R.drawable.ic_favorite_outline);
               Toast.makeText(context, isFav ? "Added to favorites" : "Removed from favorites", Toast.LENGTH_SHORT).show();
               // If in a list, update your dataset and refresh the item
               wallpaperItem.setIsFavorite(isFav);
               notifyItemChanged(position);
           });
       }).start();
   });
   

   If you're using Kotlin, Coroutines make this cleaner:

   favoriteBtn.setOnClickListener {
       lifecycleScope.launch(Dispatchers.IO) {
           val newState = !isFav
           if (newState) dbHelper.addToFavorite(imageUrl)
           else dbHelper.removeFromFavorite(imageUrl)
           
           withContext(Dispatchers.Main) {
               isFav = newState
               favoriteBtn.setImageResource(if (isFav) R.drawable.ic_favorite_filled else R.drawable.ic_favorite_outline)
               Toast.makeText(context, if (isFav) "Added to favorites" else "Removed from favorites", Toast.LENGTH_SHORT).show()
           }
       }
   }
   

Step 4: Load & Display Favorite Wallpapers #

Create a favorites page and fetch the saved wallpapers from your database:

// Fetch all favorite wallpaper URLs (Option 2 example)
public List<String> getFavoriteWallpapers() {
    List<String> favoriteUrls = new ArrayList<>();
    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cursor = db.rawQuery("SELECT image_url FROM favorites", null);
    
    if (cursor.moveToFirst()) {
        do {
            favoriteUrls.add(cursor.getString(cursor.getColumnIndexOrThrow("image_url")));
        } while (cursor.moveToNext());
    }
    
    cursor.close();
    db.close();
    return favoriteUrls;
}

Then load the images with Picasso just like you do for your main wallpaper list:

Picasso.get().load(imageUrl).into(wallpaperImageView);

Key Tips to Keep in Mind #

• Never Run DB Operations on the Main Thread: This causes app freezes (ANRs). Use threads, Coroutines, or AsyncTask to handle background work.
• Use Reliable Unique Identifiers: If your wallpapers have unique IDs, use those instead of URLs for more reliable database queries.
• Keep UI & Database in Sync: Always update your UI immediately after modifying the database to avoid mismatched states.

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