这个SQLite查询返回一个计数为0＆hellip的游标;我知道它至少应该有1.有人可以看看吗？ （真的很快）
public Cursor fetchIsOverride(String username) {
int override = 1;
Cursor cursor = mDb.query(true, OVERRIDE_TABLE, new String[] {KEY_ROWID, KEY_USERNAME, KEY_ISOVERRIDE, KEY_FIRSTNAME, KEY_LASTNAME, KEY_EMAIL, KEY_HOMEPHONE, KEY_WORKPHONE, KEY_PICTURE}, KEY_USERNAME + "= '" + username +"' " + "AND " + KEY_ISOVERRIDE + "=" + override, null, null, null, null, null);
return cursor;
}
没有找到相关结果
已邀请:
4 个回复
犀寺扦
或字符串有任何标点符号，空格或其他异常字符，则可能需要对其进行转义。最好使用参数绑定apis而不是直接将字符串插入到SQL语句中。痰嫉
Cursor cursor = mDb.query(true, OVERRIDE_TABLE, new String[] {KEY_ROWID, KEY_USERNAME, KEY_ISOVERRIDE, KEY_FIRSTNAME, KEY_LASTNAME, KEY_EMAIL, KEY_HOMEPHONE, KEY_WORKPHONE, KEY_PICTURE}, KEY_USERNAME + "== '" + username +"' " + "AND " + KEY_ISOVERRIDE + "==" + override, null, null, null, null, null);慷祈霖黑
while(moveToNext()) { //stuff }械怒等
do { // Get the field values name = c.getString(nameColumn); TvXmlData.append("n" +name ); website = c.getString(websiteColumn); TvXmlData.append("n " + website ); categoty = c.getString(categoryColumn); TvXmlData.append("n " + categoty ); } while (c.moveToNext()); } c.close(); db.close();