Android Open Source - sqlite Cnt Db Adapter

• Back to SQLite/example  ↑

From Project

Back to project page sqlite.

License

The source code is released under:

GNU General Public License

Java Source Code

package edu.cs4730.lvcursordemo;
/*from  ww  w .  jav  a 2s. c o  m*/
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class CntDbAdapter {
  public static final String KEY_ROWID = "_id";
  public static final String KEY_CODE = "code";
  public static final String KEY_NAME = "name";
  public static final String KEY_CONTINENT = "continent";
  public static final String KEY_REGION = "region";

  private static final String TAG = "CountriesDbAdapter";
  private DatabaseHelper mDbHelper;
  private SQLiteDatabase mDb;

  private static final String DATABASE_NAME = "World";
  private static final String SQLITE_TABLE = "Country";
  private static final int DATABASE_VERSION = 1;

  private final Context mCtx;

  private static final String DATABASE_CREATE =
      "CREATE TABLE if not exists " + SQLITE_TABLE + " (" +
          KEY_ROWID + " integer PRIMARY KEY autoincrement," +
          KEY_CODE + "," +
          KEY_NAME + "," +
          KEY_CONTINENT + "," +
          KEY_REGION + "," +
          " UNIQUE (" + KEY_CODE +"));";



  private static class DatabaseHelper extends SQLiteOpenHelper {

    DatabaseHelper(Context context) {
      super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }


    @Override
    public void onCreate(SQLiteDatabase db) {
      Log.w(TAG, DATABASE_CREATE);
      db.execSQL(DATABASE_CREATE);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
      Log.w(TAG, "Upgrading database from version " + oldVersion + " to "
          + newVersion + ", which will destroy all old data");
      db.execSQL("DROP TABLE IF EXISTS " + SQLITE_TABLE);
      onCreate(db);
    }
  }
  public CntDbAdapter(Context ctx) {
    this.mCtx = ctx;
  }

  public CntDbAdapter open() throws SQLException {
    mDbHelper = new DatabaseHelper(mCtx);
    mDb = mDbHelper.getWritableDatabase();
    return this;
  }

  public void close() {
    if (mDbHelper != null) {
      mDbHelper.close();
    }
  }

  public long createCountry(String code, String name,
      String continent, String region) {

    ContentValues initialValues = new ContentValues();
    initialValues.put(KEY_CODE, code);
    initialValues.put(KEY_NAME, name);
    initialValues.put(KEY_CONTINENT, continent);
    initialValues.put(KEY_REGION, region);

    return mDb.insert(SQLITE_TABLE, null, initialValues);
  }

  public boolean deleteAllCountries() {

    int doneDelete = 0;
    doneDelete = mDb.delete(SQLITE_TABLE, null , null);
    Log.w(TAG, Integer.toString(doneDelete));
    return doneDelete > 0;

  }

  public Cursor fetchCountriesByName(String inputText) throws SQLException {
    Log.w(TAG, inputText);
    Cursor mCursor = null;
    if (inputText == null  ||  inputText.length () == 0)  {
      mCursor = mDb.query(SQLITE_TABLE, new String[] {KEY_ROWID,
          KEY_CODE, KEY_NAME, KEY_CONTINENT, KEY_REGION},
          null, null, null, null, null);

    }
    else {
      mCursor = mDb.query(true, SQLITE_TABLE, new String[] {KEY_ROWID,
          KEY_CODE, KEY_NAME, KEY_CONTINENT, KEY_REGION},
          KEY_NAME + " like '%" + inputText + "%'", null,
          null, null, null, null);
    }
    if (mCursor != null) {
      mCursor.moveToFirst();
    }
    return mCursor;

  }

  public Cursor fetchAllCountries() {

    Cursor mCursor = mDb.query(SQLITE_TABLE, new String[] {KEY_ROWID,
        KEY_CODE, KEY_NAME, KEY_CONTINENT, KEY_REGION},
        null, null, null, null, null);

    if (mCursor != null) {
      mCursor.moveToFirst();
    }
    return mCursor;
  }
  

  public void insertSomeCountries() {

    createCountry("AFG","Afghanistan","Asia","Southern and Central Asia");
    createCountry("ALB","Albania","Europe","Southern Europe");
    createCountry("DZA","Algeria","Africa","Northern Africa");
    createCountry("ASM","American Samoa","Oceania","Polynesia");
    createCountry("AND","Andorra","Europe","Southern Europe");
    createCountry("AGO","Angola","Africa","Central Africa");
    createCountry("AIA","Anguilla","North America","Caribbean");

  }
  
    /*
     * These two are for the Expandable List View demo piece.
     */
  public Cursor fetchGroup() {
    //Return ID and continent information, but all of it.
    Cursor mCursor = mDb.query(SQLITE_TABLE, new String[] {KEY_ROWID, KEY_CONTINENT},
        null, null, null, null, null);

    if (mCursor != null) {
      mCursor.moveToFirst();
    }
    return mCursor;
  }
  
  public Cursor fetchChild(String inputText) {
    //fetching all the children for a group header, based on continent.
    
    Cursor mCursor = mDb.query(true, SQLITE_TABLE, new String[] {KEY_ROWID,
        KEY_CODE, KEY_NAME, KEY_REGION},
        KEY_CONTINENT + " = '" + inputText + "'", null,
        null, null, null, null);

    if (mCursor != null) {
      mCursor.moveToFirst();
    }
    return mCursor;
  }
  
}

Java Source Code List

• Back to SQLite/example  ↑