Пример #1
0
  public ArrayList<SellInItemDTO> selectTemp() {
    ArrayList<SellInItemDTO> list = new ArrayList<SellInItemDTO>();

    Cursor cursor =
        this.db.query(
            TABLE_NAME,
            new String[] {"sellin_json,date,sell_in_date_time"},
            "uploaded=? AND user_id=?",
            new String[] {"0", Contents.getLogInfo().getUserId()},
            null,
            null,
            "id asc");
    if (cursor.moveToFirst()) {
      do {
        SellInItemDTO jd = new SellInItemDTO();
        jd.fromJSON(cursor.getString(0));
        jd.setDate(cursor.getString(1));
        jd.setSellInDateTime(cursor.getString(2));
        list.add(jd);
      } while (cursor.moveToNext());
    }
    if (cursor != null && !cursor.isClosed()) {
      cursor.close();
    }
    return list;
  }