예제 #1
0
  private ArrayList<Film> creaListaFilm(String categoria) {
    ArrayList<Film> lista = new ArrayList<Film>();
    DbAdapterFilm dbHelper;
    Cursor cursor;

    Log.d("creaListaFilm", "sto per fare la roba sul bd");
    dbHelper = new DbAdapterFilm(getApplicationContext());

    Log.d("creaListaFilm", "apro il bd");
    dbHelper.open();
    Log.d("creaListaFilm", "ho aperto il bd");

    Log.d("creaListaFilm", "riempio il cursore");
    cursor = dbHelper.fetchContactsByFilter(categoria);
    Log.d("creaListaFilm", "selezionata la categoria " + categoria);
    int i = 0;
    while (cursor.moveToNext()) {
      lista.add(
          new Film(
              cursor.getInt(cursor.getColumnIndex(DbAdapterFilm.KEY_CONTACTID)),
              cursor.getString(cursor.getColumnIndex(DbAdapterFilm.KEY_TITLE)),
              cursor.getString(cursor.getColumnIndex(DbAdapterFilm.KEY_CATEGORY)),
              cursor.getInt(cursor.getColumnIndex(DbAdapterFilm.KEY_POINT)),
              cursor.getInt(cursor.getColumnIndex(DbAdapterFilm.KEY_IMAGE)),
              cursor.getString(cursor.getColumnIndex(DbAdapterFilm.KEY_NAMEIMAGE)),
              cursor.getString(cursor.getColumnIndex(DbAdapterFilm.KEY_GUESS))));
      Log.d("creaListaFilm", lista.get(i).toString());
      i++;
    }
    cursor.close();
    dbHelper.close();
    return lista;
  }
예제 #2
0
  private void updateFilm() {
    DbAdapterFilm dbHelper;

    dbHelper = new DbAdapterFilm(getApplicationContext());
    dbHelper.open();
    dbHelper.updateContact(
        film.getId(),
        film.getTitle(),
        film.getCategory(),
        film.getPoint(),
        film.getImage(),
        film.getNameImage(),
        film.getTitle());
    dbHelper.close();
  }