Android Open Source - nextep Database Helper

• Back to Development/tv  ↑

From Project

Back to project page nextep.

License

The source code is released under:

Copyright (c) 2013 Jason Costabile jasoncostabile.com The above copyright notice shall be included in all copies or substantial portions of the Software.

Java Source Code

package com.jasoncostabile.nextep;
//  w  w w .  j  ava2s  . c  o  m
import java.util.ArrayList;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

//reference: http://www.codeproject.com/Articles/119293/Using-SQLite-Database-with-Android

public class DatabaseHelper extends SQLiteOpenHelper {
  static final String dbName = "NextEpDB";
  static final String showTable = "Shows";
  static final String colID = "ShowID";
  static final String colTitle = "Title";
  static final String colIcon = "Icon";
  static final String colNextEpSeason = "NextEpSeason";
  static final String colNextEpisode = "NextEpisode";
  static final String colNextAirdate = "NextAirdate";    //stored as milliseconds since Jan. 1, 1970
  static final String colSortKey = "SortKey";

  public DatabaseHelper(Context context) {
    super(context, dbName, null, 1);  //increment database version number when a DB upgrade is required.
                      //onUpgrade() will be invoked.
  }

  public void onCreate(SQLiteDatabase db) {
     db.execSQL("CREATE TABLE " + showTable + " ( "
         + colID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
         + colTitle + " TEXT, "
         + colIcon + " BLOB, "
         + colNextEpSeason + " INTEGER, "
         + colNextEpisode + " INTEGER, "
         + colNextAirdate + " INTEGER, "
         + colSortKey + " INTEGER "
         + ");");
  }

  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    db.execSQL("DROP TABLE IF EXISTS " + showTable);

    onCreate(db);
  }
  
  public void insert(Show show) {
    SQLiteDatabase db = this.getWritableDatabase();
    
    ContentValues cv = new ContentValues();
    cv.put(colTitle, show.title);
    cv.put(colIcon, show.icon);
    cv.put(colNextEpSeason, show.nextEpSeason);
    cv.put(colNextEpisode, show.nextEpisode);
    cv.put(colNextAirdate, show.nextAirdate);
    cv.put(colSortKey, show.sortKey);
    db.insert(showTable, colID, cv);

    db.close();
  }
  
  public int update(Show show)
  {
    SQLiteDatabase db = this.getWritableDatabase();
    
    ContentValues cv = new ContentValues();

    cv.put(colTitle, show.title);
    cv.put(colIcon, show.icon);
    cv.put(colNextEpSeason, show.nextEpSeason);
    cv.put(colNextEpisode, show.nextEpisode);
    cv.put(colNextAirdate, show.nextAirdate);
    cv.put(colSortKey, show.sortKey);
    return db.update(showTable, cv, colID+"=?", 
        new String[]{String.valueOf(show.ID)});   
  }
  
  public void delete(int showID)
  {
    SQLiteDatabase db = this.getWritableDatabase();
    
    db.delete(showTable, colID+"=?", new String[]{String.valueOf(showID)});
    
    db.close();
  }
  
  public ArrayList<Show> getShows()
  {
    SQLiteDatabase db = this.getReadableDatabase();
    
    Cursor c = db.query(showTable, null, null, null, null, null, null);
    
    int id = c.getColumnIndexOrThrow(colID);
    int title = c.getColumnIndexOrThrow(colTitle);
    int icon = c.getColumnIndexOrThrow(colIcon);
    int nextEpSeason = c.getColumnIndexOrThrow(colNextEpSeason);
    int nextEpisode = c.getColumnIndexOrThrow(colNextEpisode);
    int nextAirdate = c.getColumnIndexOrThrow(colNextAirdate);
    int sortKey = c.getColumnIndexOrThrow(colSortKey);
    ArrayList<Show> shows = new ArrayList<Show>();
    while (c.moveToNext()) {
      Show show = new Show(c.getString(title), c.getBlob(icon));
      show.ID = c.getInt(id);
      show.nextEpSeason = c.getInt(nextEpSeason);
      show.nextEpisode = c.getInt(nextEpisode);
      show.nextAirdate = c.getLong(nextAirdate);
      show.sortKey = c.getInt(sortKey);
      
      shows.add(show);
    }

    c.close();
    db.close();
    
    return shows;
  }
}

Java Source Code List

• Back to Development/tv  ↑