android - 我有一个 sqlite 表，我想在每个月底从该表中删除一行。有没有办法在Android中做到这一点

Question

我有一个 SQLite 表，我想在每个月底运行一个查询以从表中删除一行，有没有办法这样做？

标签： androiddatabasesqlite

Answer 1

To delete a row just use:

    db.delete(String table, 
            String whereClause, 
            String[] whereArgs)

ex.

    db.delete("yourTable", "yourRow", null);

https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase#delete(java.lang.String,%20java.lang.String,%20java.lang.String[])

Now to recognize the day of the month use Calendar class:

Calendar calendar = Calendar.getInstance();
int dayOfTheMonth = calendar.get(Calendar.DAY_OF_MONTH);

https://developer.android.com/reference/java/util/Calendar#DAY_OF_MONTH