Android Open Source - android-sqlite-asset-helper My Database

• Back to SQLite/Helper  ↑

From Project

Back to project page android-sqlite-asset-helper.

License

The source code is released under:

Apache License

Java Source Code

package com.example;
//from w w w .  j  a v a 2s  . co  m
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteQueryBuilder;

import com.readystatesoftware.sqliteasset.SQLiteAssetHelper;

public class MyDatabase extends SQLiteAssetHelper {

  private static final String DATABASE_NAME = "northwind.db";
  private static final int DATABASE_VERSION = 2;
  
  public MyDatabase(Context context) {
    super(context, DATABASE_NAME, null, DATABASE_VERSION);  
    
    // you can use an alternate constructor to specify a database location
    // (such as a folder on the sd card)
    // you must ensure that this folder is available and you have permission
    // to write to it
    //super(context, DATABASE_NAME, context.getExternalFilesDir(null).getAbsolutePath(), null, DATABASE_VERSION);

        // call this method to force a database overwrite every time the version number increments:
        //setForcedUpgrade();

    // call this method to force a database overwrite if the version number
    // is below a certain threshold:
    //setForcedUpgrade(2);
  }

  public Cursor getEmployees() {

    SQLiteDatabase db = getReadableDatabase();
    SQLiteQueryBuilder qb = new SQLiteQueryBuilder();

    String [] sqlSelect = {"0 _id", "FullName"}; 
    String sqlTables = "Employees";

    qb.setTables(sqlTables);
    Cursor c = qb.query(db, sqlSelect, null, null,
        null, null, null);

    c.moveToFirst();
    return c;

  }

}

Java Source Code List

• Back to SQLite/Helper  ↑