TShopping

標題: Using your own SQLite database in Android applications [打印本頁]

---

作者: woff    時間: 2013-10-11 12:49
標題: Using your own SQLite database in Android applications
Most all of the Android examples and tutorials out there assume you want to create and populate your database at runtime and not to use and access an independent, preloaded database with your Android application.The method I'm going to show you takes your own SQLite database file from the "assets" folder and copies into the system database path of your application so the SQLiteDatabase API can open and access it normally.

1. Preparing the SQLite database file.
Assuming you already have your sqlite database created, we need to do some modifications to it.
If you don't have a sqlite manager I recommend you to download the opensource SQLite Database Browser available for Win/Linux/Mac.
Open your database and add a new table called "android_metadata", you can execute the following SQL statement to do it:

• 1. CREATE TABLE "android_metadata" ("locale" TEXT DEFAULT 'en_US')

  複製代碼
  
  Now insert a single row with the text 'en_US' in the "android_metadata" table:
  

• 1. INSERT INTO "android_metadata" VALUES ('en_US')

  複製代碼
  
  Then, it is necessary to rename the primary id field of your tables to "_id" so Android will know where to bind the id field of your tables.
  You can easily do this with SQLite Database Browser by pressing the edit table button , then selecting the table you want to edit and finally selecting the field you want to rename.
  

After renaming the id field of all your data tables to "_id" and adding the "android_metadata" table, your database it's ready to be used in your Android application.

Modified database

Note: in this image we see the tables "Categories" and "Content" with the id field renamed to "_id" and the just added table "android_metadata".
2. Copying, opening and accessing your database in your Android application.
Now just put your database file in the "assets" folder of your project and create a Database Helper class by extending the SQLiteOpenHelper class from the "android.database.sqlite" package.
Make your DataBaseHelper class look like this:

1. 
   
2. public class DataBaseHelper extends SQLiteOpenHelper{
   
3. 
   
4.     //The Android's default system path of your application database.
   
5.     private static String DB_PATH = "/data/data/YOUR_PACKAGE/databases/";
   
6.     private static String DB_NAME = "myDBName";
   
7.     private SQLiteDatabase myDataBase;
   
8.     private final Context myContext;
   
9. 
   
10.     /**
    
11.      * Constructor
    
12.      * Takes and keeps a reference of the passed context in order to access to the application assets and resources.
    
13.      * @param context
    
14.      */
    
15.     public DataBaseHelper(Context context) {
    
16.             super(context, DB_NAME, null, 1);
    
17.             this.myContext = context;
    
18.     }        
    
19. 
    
20.   /**
    
21.      * Creates a empty database on the system and rewrites it with your own database.
    
22.      * */
    
23.     public void createDataBase() throws IOException{
    
24.             boolean dbExist = checkDataBase();
    
25.             if(dbExist){
    
26.                     //do nothing - database already exist
    
27.             }else{
    
28.                     //By calling this method and empty database will be created into the default system path
    
29.                     //of your application so we are gonna be able to overwrite that database with our database.
    
30.                     this.getReadableDatabase();
    
31. 
    
32.                     try {
    
33.                             copyDataBase();
    
34.                     } catch (IOException e) {
    
35.                             throw new Error("Error copying database");
    
36.                     }
    
37.             }
    
38.     }
    
39. 
    
40.     /**
    
41.      * Check if the database already exist to avoid re-copying the file each time you open the application.
    
42.      * @return true if it exists, false if it doesn't
    
43.      */
    
44.     private boolean checkDataBase(){
    
45.             SQLiteDatabase checkDB = null;
    
46.             try{
    
47.                     String myPath = DB_PATH + DB_NAME;
    
48.                     checkDB = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);
    
49.             }catch(SQLiteException e){
    
50.                     //database does't exist yet.
    
51.             }
    
52.             if(checkDB != null){
    
53.                     checkDB.close();
    
54.             }
    
55.             return checkDB != null ? true : false;
    
56.     }
    
57. 
    
58.     /**
    
59.      * Copies your database from your local assets-folder to the just created empty database in the
    
60.      * system folder, from where it can be accessed and handled.
    
61.      * This is done by transfering bytestream.
    
62.      * */
    
63.     private void copyDataBase() throws IOException{
    
64.             //Open your local db as the input stream
    
65.             InputStream myInput = myContext.getAssets().open(DB_NAME);
    
66.             // Path to the just created empty db
    
67.             String outFileName = DB_PATH + DB_NAME;
    
68. 
    
69.             //Open the empty db as the output stream
    
70.             OutputStream myOutput = new FileOutputStream(outFileName);
    
71. 
    
72.             //transfer bytes from the inputfile to the outputfile
    
73.             byte[] buffer = new byte[1024];
    
74.             int length;
    
75.             while ((length = myInput.read(buffer))>0){
    
76.                     myOutput.write(buffer, 0, length);
    
77.             }
    
78.             //Close the streams
    
79.             myOutput.flush();
    
80.             myOutput.close();
    
81.             myInput.close();
    
82.     }
    
83. 
    
84.     public void openDataBase() throws SQLException{
    
85.             //Open the database
    
86.             String myPath = DB_PATH + DB_NAME;
    
87.             myDataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);
    
88.     }
    
89. 
    
90.     @Override
    
91.     public synchronized void close() {
    
92.             if(myDataBase != null)
    
93.                     myDataBase.close();
    
94.             super.close();
    
95.     }
    
96. 
    
97.     @Override
    
98.     public void onCreate(SQLiteDatabase db) {
    
99.     }
    
100. 
     
101.     @Override
     
102.     public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
     
103.     }
     
104. 
     
105.     // Add your public helper methods to access and get content from the database.
     
106.     // You could return cursors by doing "return myDataBase.query(....)" so it'd be easy
     
107.     // to you to create adapters for your views.
     
108. 
     

複製代碼

That's it.
Now you can create a new instance of this DataBaseHelper class and call the createDataBase() and openDataBase() methods. Remember to change the "YOUR_PACKAGE" to your application package namespace (i.e: com.examplename.myapp) in the DB_PATH string.

        

1. DataBaseHelper myDbHelper = new DataBaseHelper();
   
2.         myDbHelper = new DataBaseHelper(this);
   
3. 
   
4.         try {
   
5.                 myDbHelper.createDataBase();
   
6.         } catch (IOException ioe) {
   
7.                 throw new Error("Unable to create database");
   
8.         }
   
9. 
   
10.         try {
    
11.                 myDbHelper.openDataBase();
    
12.         }catch(SQLException sqle){
    
13.                 throw sqle;
    
14.         }
    
複製代碼

This article has also been translated into Serbo-Croatian by Anja Skrba from Webhostinggeeks.com.

轉帖於：http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/

---

歡迎光臨 TShopping (http://www.tshopping.com.tw/)

Powered by Discuz! X3.2