如何将通知保存到我的android应用程序以及如何检索数据

// 创建数据库和表结构的帮助类
public class DatabaseHelper extends SQLiteOpenHelper {
    private static final String DATABASE_NAME = "notifications.db";
    private static final int DATABASE_VERSION = 1;
    private static final String TABLE_NAME = "notifications";
    private static final String COLUMN_ID = "_id";
    private static final String COLUMN_TITLE = "title";
    private static final String COLUMN_CONTENT = "content";
    private static final String COLUMN_TIME = "time";

    public DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String createTableQuery = "CREATE TABLE " + TABLE_NAME + " (" +
                COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                COLUMN_TITLE + " TEXT, " +
                COLUMN_CONTENT + " TEXT, " +
                COLUMN_TIME + " TEXT)";
        db.execSQL(createTableQuery);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 升级数据库时的操作，可以根据需要进行处理
    }
}

// 将通知保存到数据库
public void saveNotification(Context context, String title, String content, String time) {
    DatabaseHelper dbHelper = new DatabaseHelper(context);
    SQLiteDatabase db = dbHelper.getWritableDatabase();

    ContentValues values = new ContentValues();
    values.put(DatabaseHelper.COLUMN_TITLE, title);
    values.put(DatabaseHelper.COLUMN_CONTENT, content);
    values.put(DatabaseHelper.COLUMN_TIME, time);

    db.insert(DatabaseHelper.TABLE_NAME, null, values);
    db.close();
}

// 从数据库中检索通知数据
public List<Notification> getNotifications(Context context) {
    List<Notification> notifications = new ArrayList<>();
    DatabaseHelper dbHelper = new DatabaseHelper(context);
    SQLiteDatabase db = dbHelper.getReadableDatabase();

    String[] columns = {DatabaseHelper.COLUMN_TITLE, DatabaseHelper.COLUMN_CONTENT, DatabaseHelper.COLUMN_TIME};
    Cursor cursor = db.query(DatabaseHelper.TABLE_NAME, columns, null, null, null, null, null);

    if (cursor.moveToFirst()) {
        do {
            String title = cursor.getString(cursor.getColumnIndex(DatabaseHelper.COLUMN_TITLE));
            String content = cursor.getString(cursor.getColumnIndex(DatabaseHelper.COLUMN_CONTENT));
            String time = cursor.getString(cursor.getColumnIndex(DatabaseHelper.COLUMN_TIME));

            Notification notification = new Notification(title, content, time);
            notifications.add(notification);
        } while (cursor.moveToNext());
    }

    cursor.close();
    db.close();

    return notifications;
}