Android sqlite中的WHERE IN子句? [英] WHERE IN clause in Android sqlite?

问题描述

我无法在WHERE IN子句上使用Android SQLite数据库.

I can't get WHERE IN clause to work on android SQLite database.

有什么办法可以在android中执行这样的语句吗? :

Is there any way to execute a statement like this in android? :

SELECT body FROM table1 WHERE title IN ('title1', 'title2', 'title3')

推荐答案

您可以使用TextUtils.join(",", parameters)利用sqlite绑定参数，其中parameters是具有"?"占位符的列表，结果字符串类似"?,?,..,?".

You can use TextUtils.join(",", parameters) to take advantage of sqlite binding parameters, where parameters is a list with "?" placeholders and the result string is something like "?,?,..,?".

这是一个小例子:

Set<Integer> positionsSet = membersListCursorAdapter.getCurrentCheckedPosition();
List<String> ids = new ArrayList<>();
List<String> parameters = new ArrayList<>();
for (Integer position : positionsSet) {
    ids.add(String.valueOf(membersListCursorAdapter.getItemId(position)));
    parameters.add("?");
}
getActivity().getContentResolver().delete(
    SharedUserTable.CONTENT_URI,
    SharedUserTable._ID + " in (" + TextUtils.join(",", parameters) + ")",
    ids.toArray(new String[ids.size()])
);

这篇关于Android sqlite中的WHERE IN子句?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！