안드로이드 - simple export/import of sqlite database

안드로이드 - simple export/import of sqlite database

String path = Environment.getExternalStorageDirectory().toString() + "/{appName}/";

public static String DB_FILEPATH = "/data/data/{package_name}/databases/database.db"; 
 
/** 
 * Copies the database file at the specified location over the current 
 * internal application database. 
 * */ 
public boolean importDatabase(String dbPath) throws IOException { 
 
    // Close the SQLiteOpenHelper so it will commit the created empty 
    // database to internal storage. 
    close(); 
    File newDb = new File(dbPath); 
    File oldDb = new File(DB_FILEPATH); 
    if (newDb.exists()) { 
        FileUtils.copyFile(new FileInputStream(newDb), new FileOutputStream(oldDb)); 
        // Access the copied database so SQLiteHelper will cache it and mark 
        // it as created. 
        getWritableDatabase().close(); 
        return true; 
    } 
    return false; 
} 

FileUtils

public class FileUtils { 
    /** 
     * Creates the specified <code>toFile</code> as a byte for byte copy of the 
     * <code>fromFile</code>. If <code>toFile</code> already exists, then it 
     * will be replaced with a copy of <code>fromFile</code>. The name and path 
     * of <code>toFile</code> will be that of <code>toFile</code>.<br/> 
     * <br/> 
     * <i> Note: <code>fromFile</code> and <code>toFile</code> will be closed by 
     * this function.</i> 
     *  
     * @param fromFile 
     *            - FileInputStream for the file to copy from. 
     * @param toFile 
     *            - FileInputStream for the file to copy to. 
     */ 
    public static void copyFile(FileInputStream fromFile, FileOutputStream toFile) throws IOException { 
        FileChannel fromChannel = null; 
        FileChannel toChannel = null; 
        try { 
            fromChannel = fromFile.getChannel(); 
            toChannel = toFile.getChannel(); 
            fromChannel.transferTo(0, fromChannel.size(), toChannel); 
        } finally { 
            try { 
                if (fromChannel != null) { 
                    fromChannel.close(); 
                } 
            } finally { 
                if (toChannel != null) { 
                    toChannel.close(); 
                } 
            } 
        } 
    } 
}