然后以下必须返回存储在数据库中的用户密码
public String getPasswordByUsername(String userName)
{
SQLiteDatabase db = this.getReadableDatabase();
String selectQuery = "SELECT * FROM " + TABLE_USERS + " WHERE "
+ KEY_USERS_USERNAME + " = " + userName;
Cursor cursor = db.rawQuery(selectQuery, null);
if (cursor.getCount() < 1) {
cursor.close();
return "NOT EXIST";
}
cursor.moveToFirst();
String password = cursor.getString(cursor.getColumnIndex("password"));
cursor.close();
return password;
}
当我尝试获取用户“ w”的密码时,得到:
12-24 10:54:23.639: E/AndroidRuntime(11237): FATAL EXCEPTION: main
12-24 10:54:23.639: E/AndroidRuntime(11237): Process: com.example.doit, PID: 11237
12-24 10:54:23.639: E/AndroidRuntime(11237): android.database.sqlite.SQLiteException: no such column: w (code 1): , while compiling: SELECT password FROM users WHERE username = w
如何获取正确的密码?谢谢你。
更改" = " + userName
为:" = '" + username+ "'"
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句