Android操作存放在assets文件夹下SQLite数据库的方法

package com.sin.android.database; 
import java.io.File; 
import java.io.FiLeoutputStream; 
import java.io.InputStream; 
import java.io.outputStream; 
import java.util.HashMap; 
import java.util.Map; 
import android.content.Context; 
import android.content.SharedPreferences; 
import android.content.res.AssetManager; 
import android.database.sqlite.sqliteDatabase; 
import android.util.Log; 
/** 
 * This is a Assets Database Manager 
 * Use it,you can use a assets database file in you application 
 * It will copy the database file to "/data/data/[your application package name]/database" when you first time you use it 
 * Then you can get a sqliteDatabase object by the assets database file
 * @author RobinTang 
 * @time 2012-09-20 
 * 
 * 
 * How to use: 
 * 1. Initialize AssetsDatabaseManager 
 * 2. Get AssetsDatabaseManager 
 * 3. Get a sqliteDatabase object through database file 
 * 4. Use this database object 
 * 
 * Using example: 
 * AssetsDatabaseManager.initManager(getApplication()); // this method is only need call one time 
 * AssetsDatabaseManager mg = AssetsDatabaseManager.getManager();  // get a AssetsDatabaseManager object 
 * sqliteDatabase db1 = mg.getDatabase("db1.db");  // get sqliteDatabase object,db1.db is a file in assets folder 
 * db1.??? // every operate by you want 
 * Of cause,you can use AssetsDatabaseManager.getManager().getDatabase("xx") to get a database when you need use a database 
 */ 
public class AssetsDatabaseManager { 
  private static String tag = "AssetsDatabase"; // for LogCat 
  private static string databasePath = "/data/data/%s/database"; // %s is packagename 
  // A mapping from assets database file to sqliteDatabase object 
  private Map<String,sqliteDatabase> databases = new HashMap<String,sqliteDatabase>(); 
  // Context of application 
  private Context context = null; 
  // Singleton Pattern 
  private static AssetsDatabaseManager mInstance = null; 
  /** 
   * Initialize AssetsDatabaseManager 
   * @param context,context of application 
   */ 
  public static void initManager(Context context){ 
    if(mInstance == null){ 
      mInstance = new AssetsDatabaseManager(context); 
    } 
  } 
  /** 
   * Get a AssetsDatabaseManager object 
   * @return,if success return a AssetsDatabaseManager object,else return null 
   */ 
  public static AssetsDatabaseManager getManager(){ 
    return mInstance; 
  } 
  private AssetsDatabaseManager(Context context){ 
    this.context = context; 
  } 
  /** 
   * Get a assets database,if this database is opened this method is only return a copy of the opened database 
   * @param dbfile,the assets file which will be opened for a database 
   * @return,if success it return a sqliteDatabase object else return null 
   */ 
  public sqliteDatabase getDatabase(String dbfilE) { 
    if(databases.get(dbfilE) != null){ 
      Log.i(tag,String.format("Return a database copy of %s",dbfilE)); 
      return (sqliteDatabasE) databases.get(dbfilE); 
    } 
    if(context==null) 
      return null; 
    Log.i(tag,String.format("Create database %s",dbfilE)); 
    String spath = getDatabaseFilepath(); 
    String sfile = getDatabaseFile(dbfilE); 
    File file = new File(sfilE); 
    SharedPreferences dbs = context.getSharedPreferences(AssetsDatabaseManager.class.toString(),0); 
    Boolean flag = dbs.getBoolean(dbfile,falsE); // Get Database file flag,if true means this database file was copied and valid
    if(!flag || !file.exists()){ 
      file = new File(spath); 
      if(!file.exists() && !file.mkdirs()){ 
        Log.i(tag,"Create \""+spath+"\" fail!"); 
        return null; 
      } 
      if(!copyAssetsToFilesystem(dbfile,sfilE)){ 
        Log.i(tag,String.format("Copy %s to %s fail!",dbfile,sfilE)); 
        return null; 
      } 
      dbs.edit().putBoolean(dbfile,truE).commit(); 
    } 
    sqliteDatabase db = sqliteDatabase.openDatabase(sfile,null,sqliteDatabase.NO_LOCALIZED_COLLATORS); 
    if(db != null){ 
      databases.put(dbfile,db); 
    } 
    return db; 
  } 
  private String getDatabaseFilepath(){ 
    return String.format(databasepath,context.getApplicationInfo().packageName); 
  } 
  private String getDatabaseFile(String dbfilE){ 
    return getDatabaseFilepath()+"/"+dbfile; 
  } 
  private Boolean copyAssetsToFilesystem(String assetsSrc,String des){ 
    Log.i(tag,"Copy "+assetsSrc+" to "+des); 
    InputStream istream = null; 
    OutputStream ostream = null; 
    try{ 
      AssetManager am = context.getAssets(); 
      istream = am.open(assetsSrc); 
      ostream = new FiLeoutputStream(des); 
      byte[] buffer = new byte[1024]; 
      int length; 
      while ((length = istream.read(buffer))>0){ 
        ostream.write(buffer,length); 
      } 
      istream.close(); 
      ostream.close(); 
    } 
    catch(Exception E){ 
      e.printStackTrace(); 
      try{ 
        if(istream!=null) 
          istream.close(); 
        if(ostream!=null) 
          ostream.close(); 
      } 
      catch(Exception eE){ 
        ee.printStackTrace(); 
      } 
      return false; 
    } 
    return true; 
  } 
  /** 
   * Close assets database 
   * @param dbfile,the assets file which will be closed soon 
   * @return,the status of this operating 
   */ 
  public Boolean closeDatabase(String dbfilE){ 
    if(databases.get(dbfilE) != null){ 
      sqliteDatabase db = (sqliteDatabasE) databases.get(dbfilE);
      db.close(); 
      databases.remove(dbfilE); 
      return true; 
    } 
    return false; 
  } 
  /** 
   * Close all assets database 
   */ 
  static public void closeAllDatabase(){ 
    Log.i(tag,"closeAllDatabase"); 
    if(mInstance != null){ 
      for(int i=0; i<mInstance.databases.size(); ++i){ 
        if(mInstance.databases.get(i)!=null){ 
          mInstance.databases.get(i).close(); 
        } 
      } 
      mInstance.databases.clear(); 
    } 
  } 
} 

// 初始化，只需要调用一次 
AssetsDatabaseManager.initManager(getApplication()); 
// 获取管理对象，因为数据库需要通过管理对象才能够获取 
AssetsDatabaseManager mg = AssetsDatabaseManager.getManager(); 
// 通过管理对象获取数据库 
sqliteDatabase db1 = mg.getDatabase("db1.db"); 
// 对数据库进行操作 
db1.execsql("insert into tb([ID],[content]) values(null,'db1');");