如何根据当前日期过滤记录？

Question

我正在实现一个功能，我以字符串形式存储日期，并使用 LocalDate 函数获取字符串中的当前日期，因此我想比较两个日期，我想仅获取当前日期记录。未发现错误，但无法获取记录。  public ArrayList<Followup_Model> followup_reminder (ArrayList<Followup_Model> followup_Model_list) {    if (followup_Model_list == null) {        followup_Model_list = new ArrayList<>();    }    SQLiteDatabase sqLiteDatabase = this.getReadableDatabase();    DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyyy/MM/dd");    LocalDate localDate = LocalDate.now();    String Today = dtf.format(localDate);    Cursor followup_output = sqLiteDatabase.rawQuery("SELECT * FROM " + Table_Name_Followup +            " WHERE CREATEDBY = '1' AND CHECKED = '1' AND STARTDATE = " + Today +            " ORDER BY REMINDER ASC",null);

Answer 1

只需复制并粘贴即可。

public ArrayList<Followup_Model> followup_reminder (ArrayList<Followup_Model> 

 followup_Model_list) {

    if (followup_Model_list == null) {

        followup_Model_list = new ArrayList<>();

    }

    SQLiteDatabase sqLiteDatabase = this.getReadableDatabase();

    DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyyy/MM/dd");

    LocalDate localDate = LocalDate.now();

    String Today = dtf.format(localDate);

    Cursor followup_output = sqLiteDatabase.rawQuery("SELECT * FROM " + Table_Name_Followup +

            " WHERE CREATEDBY = '1' AND CHECKED = '1' AND STARTDATE = '" + Today + "'" +

            " ORDER BY REMINDER ASC",null);