从SQLite数据库检索多个领域，这些领域

Question

我想从比较数据库的用户名和密码进行比较，如果存在比它的成功如果不是抛出错误我使用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))); 
      } 

请帮我提前

Answer 1

从你的方法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; 
} 

Answer 2

使用SQLite查询这样的感谢....

String query ="SELECT * FROM table_name WHERE username=username_value & password=password_value"; 

Cursor cursor = database.rawQuery(query,null); 

    if (cursor != null) { 
     // success 
    }else{ 
    // fail 
}