Пример #1
0
  @Override
  public int getPosition(Thread thread, User user) {
    SQLiteDatabase db = null;
    Cursor cursor = null;
    String[] columns = null;
    String selection = null;
    int pos = 0;
    String[] args = null;

    db = DatabaseHelper.getReadDatabase();
    columns = new String[] {Thread.Columns.FLOOR};
    selection =
        Thread.Columns.USER_ID
            + "=? AND "
            + Thread.Columns.SECTION_ID
            + "=? AND "
            + Thread.Columns.THREAD_ID
            + "=?";
    args =
        new String[] {
          Integer.toString(user.getUserId()),
          thread.getSection().getSectionId(),
          Integer.toString(thread.getThreadId())
        };

    cursor =
        db.query(Constants.APOLLO_DATA_TABLE_BOOKMARK, columns, selection, args, null, null, null);
    if (cursor != null) {
      for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {
        pos = cursor.getInt(0);
      }
      cursor.close();
    }
    db.close();
    return pos;
  }