Add permissions in Manifest first
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" /><uses-permission android:name="android.permission.MOUNT_UNMOUNT_FILESYSTEMS" />
Then add the method in mainactivity
Sqlitedatabase dB; private final string database_path = android. OS. environment. getexternalstoragedirectory (). getabsolutepath () + "/vote"; private string database_filename = "db_vote.db"; // initialize the database private sqlitedatabase opendatabase () {try {string databasefilename = database_path + "/" + database_filename; file dir = new file (database_path); If (! Dir. exists () dir. mkdir (); If (! (New file (databasefilename )). exists () {inputstream is = getresources (). openrawresource (R. raw. db_vote); fileoutputstream Fos = new fileoutputstream (databasefilename); byte [] buffer = new byte [8192]; int COUNT = 0; while (COUNT = is. read (buffer)> 0) {FOS. write (buffer, 0, count);} FOS. close (); is. close ();} dB = sqlitedatabase. openorcreatedatabase (databasefilename, null); Return dB;} catch (exception e) {e. printstacktrace ();} return NULL ;}
Source: http://www.cnblogs.com/oldfeel/archive/2012/04/20/2458776.html