[Android] Android Read SQLite database From Assets Folder

Android Read SQLite database From Assets Folder

Dharmendra Singh February 2, 2017 0

In this tutorial you will learn,  how can you read SQLite Database from assets folder? Some times you have a SQLite database file and want to read in your app. So this tutorial explain you about it.

In this example we need a .sqlite file and we put this file inside assets folder. Now lets start this example

Create activity_main.xml file

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
 xmlns:tools="http://schemas.android.com/tools"
 android:id="@+id/activity_main"
 android:layout_width="match_parent"
 android:layout_height="match_parent">
<ScrollView
 android:layout_width="match_parent"
 android:layout_height="match_parent"
 android:layout_margin="10dp">
<LinearLayout
 android:layout_width="match_parent"
 android:layout_height="wrap_content"
 android:orientation="vertical">
<TextView
 android:id="@+id/readTV"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:text="Hello World!" />
 </LinearLayout>
 </ScrollView>
</RelativeLayout>

Add mydb.sqlite file inside assets folder.

Create model class Contact.java file 

package com.androideve.assetsdata;

public class Contact {

public int id;
 public String name = "";
 public String hint = "";

public Contact(int id, String name, String hint) {
 this.id = id;
 this.name = name;
 this.hint = hint;
 }

public int getId() {
 return id;
 }
public void setId(int id) {
 this.id = id;
 }
public String getName() {
 return name;
 }
public void setName(String name) {
 this.name = name;
 }
public String getHint() {
 return hint;
 }
public void setHint(String hint) {
 this.hint = hint;
 }
}

Create SQLite database helper class SqlLiteDbHelper.java file

package com.androideve.assetsdata;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.ArrayList;

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

public class SqlLiteDbHelper extends SQLiteOpenHelper {

private static final int DATABASE_VERSION = 1;
 private static final String DATABASE_NAME = "mydb.sqlite";
 private static final String DB_PATH_SUFFIX = "/databases/";
 static Context ctx;
public SqlLiteDbHelper(Context context) {
 super(context, DATABASE_NAME, null, DATABASE_VERSION);
 ctx = context;
 }
public ArrayList<Contact> getDetails() {
 SQLiteDatabase db = this.getReadableDatabase();
 ArrayList<Contact> contList = new ArrayList<>();
 Cursor cursor = db.rawQuery("SELECT * FROM demo", null);
 if (cursor != null) {
 while (cursor.moveToNext()) {
Contact cont = new Contact(cursor.getInt(0), cursor.getString(1), cursor.getString(2));
 contList.add(cont);
}
 cursor.close();
 db.close();
 }
 return contList;
 }
public void CopyDataBaseFromAsset() throws IOException {
InputStream myInput = ctx.getAssets().open(DATABASE_NAME);
// Path to the just created empty db
 String outFileName = getDatabasePath();

// if the path doesn't exist first, create it
 File f = new File(ctx.getApplicationInfo().dataDir + DB_PATH_SUFFIX);
 if (!f.exists())
 f.mkdir();

// Open the empty db as the output stream
 OutputStream myOutput = new FileOutputStream(outFileName);

// transfer bytes from the inputfile to the outputfile
 byte[] buffer = new byte[1024];
 int length;
 while ((length = myInput.read(buffer)) > 0) {
 myOutput.write(buffer, 0, length);
 }
// Close the streams
 myOutput.flush();
 myOutput.close();
 myInput.close();

}
private static String getDatabasePath() {
 return ctx.getApplicationInfo().dataDir + DB_PATH_SUFFIX
 + DATABASE_NAME;
 }
public SQLiteDatabase openDataBase() throws SQLException {
 File dbFile = ctx.getDatabasePath(DATABASE_NAME);
if (!dbFile.exists()) {
 try {
 CopyDataBaseFromAsset();
 System.out.println("Copying sucess from Assets folder");
 } catch (IOException e) {
 throw new RuntimeException("Error creating source database", e);
 }
 }
return SQLiteDatabase.openDatabase(dbFile.getPath(), null, SQLiteDatabase.NO_LOCALIZED_COLLATORS | SQLiteDatabase.CREATE_IF_NECESSARY);
 }
@Override
 public void onCreate(SQLiteDatabase db) {
}
@Override
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 }
}

Create MainActivity.java file to retrieve data from Database

package com.androideve.assetsdata;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.widget.TextView;
import java.util.ArrayList;

public class MainActivity extends AppCompatActivity {

TextView readTV;
 SqlLiteDbHelper dbHelper;
 ArrayList<Contact> contList;

@Override
 protected void onCreate(Bundle savedInstanceState) {
 super.onCreate(savedInstanceState);
 setContentView(R.layout.activity_main);

readTV = (TextView) findViewById(R.id.readTV);
 contList = new ArrayList<>();
 contList.clear();
 dbHelper = new SqlLiteDbHelper(this);
 dbHelper.openDataBase();
 contList = dbHelper.getDetails();
 String msg ="";
 for(int i=0;i<contList.size();i++){

Contact cont = contList.get(i);
 msg = msg+cont.getId()+" "+cont.getName()+" "+cont.getHint()+"\n\n\n";
 readTV.setText(msg);
 }
 }
}

Happy Coding !

<Reference>

http://androideve.com/2017/02/android-read-sqlite-databse-assets-folder/