How To Import And Export SQLite Database

Introduction

SQLite Importer Exporter

1. Open Android Studio and select Create a new project.
2. Name the project as you wish and select your activity template.
   
   

3. Click the “Finish” button to create a new project in Android Studio.

1. Open your app level build.gradle file and add the SQLiteToExcel library using the following line.
   1. compile 'com.ajts.androidmads.sqliteimpex:library:1.0.0'

2. Then click “Sync Now” to add the library.
3. Now open your Manifest File (AndroidManifest.xml) and the following permission.
   1. <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />

1. We have aware of the usage of SQLite in Android. If you want to know how to implement SQLite operations, click here.
2. The given codes in the link show how to create an implementation of SQLite in Android with “SQLiteOpenHelper” and how to perform the DB operations with SQLite. The above code will generate the SQLite databases and tables.

1. Open your java or any Activity to which you want to add the functionality and add the following lines to initialize the library. By using this, you can export the file to the default location.
   1. SQLiteImporterExporter sqLiteImporterExporter = new SQLiteImporterExporter(getApplicationContext(), "helloworld.db");

2. If you want to export the file in user preferred path, use the following.
   1. SqliteToExcel sqliteToExcel = new SqliteToExcel(this, "helloworld.db", directory_path);
   Here, “helloworld.db” is the name of the SQLite Database created in Android Application.

3. The library has the following listeners for Exporting and Importing in Android.
   1. // Listeners for Import and Export DB
   2. sqLiteImporterExporter.setOnImportListener(new SQLiteImporterExporter.ImportListener() {
   3. @Override
   4. public void onSuccess(String message) {
   5. Toast.makeText(getApplicationContext(), message, Toast.LENGTH_SHORT).show();
   6. }
   8. @Override
   9. public void onFailure(Exception exception) {
   10. Toast.makeText(getApplicationContext(), exception.getMessage(), Toast.LENGTH_SHORT).show();
   11. }
   12. });
   14. sqLiteImporterExporter.setOnExportListener(new SQLiteImporterExporter.ExportListener() {
   15. @Override
   16. public void onSuccess(String message) {
   17. Toast.makeText(getApplicationContext(), message, Toast.LENGTH_SHORT).show();
   18. }
   20. @Override
   21. public void onFailure(Exception exception) {
   22. Toast.makeText(getApplicationContext(), exception.getMessage(), Toast.LENGTH_SHORT).show();
   23. }
   24. });