原始查询(查询，选择参数) [英] rawQuery(query, selectionArgs)

问题描述

我想使用选择查询从表中检索数据.我发现，SQLiteDatabase 类的 rawQuery(query, selectionArgs) 方法来检索数据.但是我不知道 query 和 selectionArgs 应该如何传递给 rawQuery 方法?

I want to use select query for retrieving data from table. I have found, rawQuery(query, selectionArgs) method of SQLiteDatabase class to retrieve data. But I don't know how the query and selectionArgs should be passed to rawQuery method?

推荐答案

rawQuery("SELECT id, name FROM people WHERE name = ? AND id = ?", new String[] {"David", "2"});

您传递的字符串数组的元素数量与?"的数量相同

You pass a string array with an equal number of elements as you have "?"

这篇关于原始查询(查询，选择参数)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！