我想从CalendarProvider API中查询日历。在我的应用程序的设置中,用户可以检查和取消检查他想要在我的应用程序中使用的日历。我使用的是一个表USEDCALENDARS,它得到列_id (int)、calendar_id (int)和used (int)。
现在,我想显示一个旋转器,它包含用户选择的每个可写日历。我的方法是:从USEDCALENDARS收集所有的calendar_ids,其中使用=1 (true)。然后使用收集到的ids查询CalendarProvider,作为查询。看我这里的密码。
//using a simple list as calendarIds because the code that collects the id is working perfectly
List<Long> calendarIds = Arrays.asList(1L,2L,3L);
String selection = Calendars._ID + " IN (?)";
String joinedCalendarIds = StringUtils.join(calendarIds, ", ");
String[] selectionArgs = new String[]{
joinedCalendarIds
};
return cr.query(Calendars.CONTENT_URI, GOOGLE_CALENDARS_PROJECTION, selection,selectionArgs, Calendars.CALENDAR_DISPLAY_NAME);这将返回一个空游标。但是如果您将代码的第一行与。List<Long> calendarIds = Arrays.asList(1L); (基本限制ids数量为1),将返回正确的日历。
我走错方向了吗?为什么这不管用?有没有更好的方法?
发布于 2017-07-14 04:06:40
我认为问题在于如何解决IN子句的参数化问题。
我按照以下代码做了一些测试(4):
String[] selectionargs = {"1","2","3"};
String[] oldselectionargs = {"1,2,3"};
SQLiteDatabase db = mydbhelper.getWritableDatabase();
String oldselection = "_id IN(?)";
String selection = "_id" + " IN (";
String selection4 = "_id IN (";
for (int i=0; i < selectionargs.length; i++) {
if (i > 0) {
selection = selection + ", ";
}
selection = selection + selectionargs[i];
}
selection = selection + ")";
String[] columns = {mydbhelper.MYFLOATCOL};
Cursor cursor = db.query(mydbhelper.TESTFLOATTABLE,columns,selection,null,null,null,null);
Log.d("DBIN","Cursor Count=" + cursor.getCount());
while (cursor.moveToNext()) {
Log.d("DBIN",cursor.getString(cursor.getColumnIndex(mydbhelper.MYFLOATCOL)));
}
Cursor cursor2 = db.query(mydbhelper.TESTFLOATTABLE,columns,oldselection,oldselectionargs,null,null,null);
Log.d("DBIN","Cursor Count=" + cursor2.getCount());
while (cursor2.moveToNext()) {
Log.d("DBIN",cursor2.getString(cursor2.getColumnIndex(mydbhelper.MYFLOATCOL)));
}
Cursor cursor3 = db.query(mydbhelper.TESTFLOATTABLE,columns,
"_id IN (" + oldselectionargs[0].toString() + ")",null,null,null,null);
Log.d("DBIN","Cursor Count=" + cursor3.getCount());
while (cursor3.moveToNext()) {
Log.d("DBIN",cursor3.getString(cursor3.getColumnIndex(mydbhelper.MYFLOATCOL)));
}
for (int i=0; i < selectionargs.length; i++) {
if (i > 0) {
selection4 = selection4 + ",";
}
selection4 = selection4 + "?";
}
selection4 = selection4 + ")";
Cursor cursor4 = db.query(mydbhelper.TESTFLOATTABLE,columns,selection4,selectionargs,null,null,null);
Log.d("DBIN","Cursor Count=" + cursor4.getCount());
while (cursor4.moveToNext()) {
Log.d("DBIN",cursor4.getString(cursor4.getColumnIndex(mydbhelper.MYFLOATCOL)));
}
cursor.close();
cursor2.close();
cursor3.close();
cursor4.close();上述程式码的输出如下:
07-14 13:55:54.717 23634-23634/? D/DBIN: Cursor Count=3
07-14 13:55:54.717 23634-23634/? D/DBIN: 100
07-14 13:55:54.717 23634-23634/? D/DBIN: 200
07-14 13:55:54.717 23634-23634/? D/DBIN: 300
07-14 13:55:54.718 23634-23634/? D/DBIN: Cursor Count=0
07-14 13:55:54.720 23634-23634/? D/DBIN: Cursor Count=3
07-14 13:55:54.720 23634-23634/? D/DBIN: 100
07-14 13:55:54.720 23634-23634/? D/DBIN: 200
07-14 13:55:54.720 23634-23634/? D/DBIN: 300
07-14 13:55:54.721 23634-23634/? D/DBIN: Cursor Count=3
07-14 13:55:54.721 23634-23634/? D/DBIN: 100
07-14 13:55:54.721 23634-23634/? D/DBIN: 200
07-14 13:55:54.721 23634-23634/? D/DBIN: 300因此,第一、第三和第四种方法工作(即游标、cursor3和cursor4返回期望值),第二次将"1,2,3“作为参数传递不起作用(即尝试的方式)。
selectionargs为null的选择中。.... IN (?,?,?),并使用最初定义的selectionargs数组。https://stackoverflow.com/questions/45086147
复制相似问题