SqLite使用query区间查询

    query("2021-12-1","2021-12-8");
    public Cursor query(String str1, String str2){  //str1 str2分别是区间的下限2021-12-1和上限2021-12-8
        String[] whereArgs={str1, str2};
        Cursor c = db.query("Blood", null, "date between ? and ?",whereArgs, null, null, null);
        do {
            //查询条件
            while (c.moveToNext()){
                int titleIndex = c.getColumnIndex("temperature");
                int titleIndex2 = c.getColumnIndex("time");
                int titleIndex3 = c.getColumnIndex("date");
                String title = c.getString(titleIndex);
                String title2 = c.getString(titleIndex2);
                String title3 = c.getString(titleIndex3);
                Log.d("TAGaa2","name"+title+"---"+title2+"--"+title3);
               // Log.d("TAGaa2",title+"-"+c);
            }
        }while(c.moveToNext());


        return c;
    }