Access Database From Assets Folder In Android

How To Access Local DB From Assets Folder In Android

Step By Step  :

   1) Create Database .

   2) Check Database in local path or SD card path.

   3) Copy Database from Asset Folder.

   4) Open Database.

   5) Close Database.

1)   Create Database :

     Here Database Create means First Check database local path or SD Card Path(Which path for you given),Inside Create Database Checking and Copying database from asset folder.

For Example:

     public final void createDataBase() throws IOException {

                final boolean dbExist = checkDataBase();

                SQLiteDatabase db_Read = null;

                if (dbExist) {

                 //do nothing - database already exist

                } else {

                 //By calling this method and empty database will be created into the default system path

                 //of your application so we are gonna be able to overwrite that database with our database.

                 //By calling this method and empty database will be created into the default system path

                 //of your application so we are gonna be able to overwrite that database with our database.

                 db_Read = this.getReadableDatabase();

                 db_Read.close();

                 try {

                  copyDataBase();

                 } catch (IOException e) {

                  throw new Error("Error copying database");

                 }

                }

               }

2) Check Database local path or SD Card path :

     Its Used for check database which path you give.

For Example :

private boolean checkDataBase() {

                final File dbFile = new File(DB_PATH + DATABASE_NAME);

                return dbFile.exists();

               }

3) Copy Database from asset folder to Local path or SD Card Path :

        Its Copy Database from asset folder to local path any location, like SD card path.

For Example :

         private void copyDataBase() throws IOException {

                //Open your local db as the input stream

                final InputStream myInput = myContext.getAssets().open(DATABASE_NAME);

                // Path to the just created empty db

                final String outFileName = DB_PATH + DATABASE_NAME;

                //Open the empty db as the output stream

                final OutputStream myOutput = new FileOutputStream(outFileName);

                //transfer bytes from the inputfile to the outputfile

                final 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();

               }

4) Open Database :

     Its used for database read and write permission here.

For Example :

public final void openDataBase()  {

              try

              {

                     //Open the database

                       final String myPath = DB_PATH + DATABASE_NAME;

                          DataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READWRITE);

              }

              catch(Exception ex)

              {

                     ex.printStackTrace();

              }

5) Close Database :

     Its used for close database finished all works(get data from database or insert or update or delete data from database) once finished you must call close database.

For Example :

public final synchronized void close() {

                if (DataBase != null)

                       DataBase.close();

                super.close();

               }