我想从数据库中比较用户名和密码(如果存在),而不是成功,如果不抛出错误,我要使用SQLiteOpenHelper来完成一项任务,我现在可以从数据库中获取一个字段,我该如何检索多个字段
public UserInfo get_user_by_id(String id) {
SQLiteDatabase db = this.getReadableDatabase();
UserInfo userInfo = null;
Cursor cursor = db.query(TABLE_NAME, new String[]{COLUMN_APP_ID}, COLUMN_APP_ID + "=?", new String[]{id + ""}, null, null, null);
while (cursor.moveToNext()) {
//userInfo.setAppId(cursor.getString(cursor.getColumnIndex(COLUMN_APP_ID)));
userInfo = new UserInfo(cursor.getString(cursor.getColumnIndex(COLUMN_APP_ID)));
}
请事先帮助我
从您的方法get_user_by_id()中返回UserInfo的列表。
public ArrayList<UserInfo> get_user_by_id(String id) {
ArrayList<UserInfo> listUserInfo = new ArrayList<UserInfo>();
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.query(TABLE_NAME, new String[]{COLUMN_APP_ID}, COLUMN_APP_ID + "=?", new String[]{id + ""}, null, null, null);
if (cursor != null) {
while (cursor.moveToNext()) {
UserInfo userInfo = new UserInfo();
userInfo.setAppId(cursor.getString(cursor.getColumnIndex(COLUMN_APP_ID)));
// HERE YOU CAN MULTIPLE RECORD AND ADD TO LIST
listUserInfo.add(userInfo);
}
}
return listUserInfo;
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句