Use Your Own SQLite in ANDROID Application or Using 'SQLite Asset Helper' to read your own databases stored in Asset folder

See more basics on Android along with interview questions

See SQLite tutorial here

Here we are going to deal with using our own databases. 

I have a database named 'mydatabase.sqlite', which consist of a set of name and age of 5 students.

Suppose I want to view the database, I can use SQLite database browser which you can download from here.
                                                  download browser.....

Through this browser we can view the databases, can even modify delete or create a new one.
'mydatabase.sqlite' with name and age of five students is browsed and viewed as shown below

public class SqliteAssetHelper extends ListActivity {

 private Cursor students;
 private MyDatabase db;

 @Override
 public void onCreate(Bundle savedInstanceState) {
  super.onCreate(savedInstanceState);

  db = new MyDatabase(this);
  students = db.getEmployees(); // you would not typically call this on the main thread

  ListAdapter adapter = new SimpleCursorAdapter(this, 
                  android.R.layout.simple_list_item_2, 
    students,
    new String[] {"name","age"}, //table values 
    new int[] {android.R.id.text1,android.R.id.text2});

  getListView().setAdapter(adapter);
 }

 @Override
 protected void onDestroy() {
  super.onDestroy();
  students.close();
  db.close();
 } }

In MyDatabase.java

public class MyDatabase extends SQLiteAssetHelper {

 private static final String DATABASE_NAME = "mydatabase";
 private static final int DATABASE_VERSION = 2;
 
 public MyDatabase(Context context) {
  super(context, DATABASE_NAME, null, DATABASE_VERSION); 
  }

 public Cursor getEmployees() {

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

  String [] sqlSelect = {"0 _id","name","age"}; 
  String sqlTables = "mytable";

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

  c.moveToFirst();
  return c;

 } }

TERIMA KASIH ATAS KUNJUNGAN SAUDARA
Semoga artikel ini bermanfaat bagi saudara. Jika ingin mengutip, baik itu sebagian atau keseluruhan dari isi artikel ini harap menyertakan link dofollow ke http://androidpopuler.blogspot.com/2013/04/use-your-own-sqlite-in-android.html. Terima kasih sudah singgah membaca artikel ini.