Android房间-退还最近30天(1个月)- java

import androidx.room.Room;
import androidx.room.RoomDatabase;
import androidx.room.Database;
import androidx.room.Entity;
import androidx.room.PrimaryKey;
import androidx.room.Query;
import androidx.room.Dao;
import androidx.room.Insert;
import androidx.room.Delete;

import java.util.Date;
import java.util.List;

@Entity
class MyEntity {
    @PrimaryKey
    public int id;
    public String data;
    public Date timestamp;
}

@Dao
interface MyDao {
    @Query("SELECT * FROM MyEntity WHERE timestamp >= :startDate")
    List<MyEntity> getEntitiesSinceDate(Date startDate);

    @Delete
    void deleteEntities(List<MyEntity> entities);
}

@Database(entities = {MyEntity.class}, version = 1)
abstract class MyDatabase extends RoomDatabase {
    public abstract MyDao myDao();
}

// 在使用的地方调用以下代码
Date startDate = new Date(System.currentTimeMillis() - 30 * 24 * 60 * 60 * 1000); // 获取30天前的日期
MyDatabase db = Room.databaseBuilder(getApplicationContext(), MyDatabase.class, "my-database").build();
List<MyEntity> entities = db.myDao().getEntitiesSinceDate(startDate);
db.myDao().deleteEntities(entities);