【转】Android SQLite 数据库 存取 BLOB 二进制 文件
原文地址，转载请说明：http://blog.sina.com.cn/s/blog_539070ad0100nesa.html
?? Android开发时用到二进制数据（也可以理解为BYTE数组）的SQLite存取，可能会有人对存取如mp3、图片类文件困惑，其实p3、图片类文件读到内存就可理解为BYTE数组，只要在下面的基础上增加将文件读到BYTE数组就可以了，其他操作是相同的(在网上搜了一段代码放下面了)。
??写此文的目的是方便自己今后查询，当然碰巧方便了其他人就当我奉献了：）
package com.Jung.DH;
?
import java.io.ByteArrayOutputStream;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.util.Log;
?
// 数据操作类
public class testSeedDB {
??? private Context mContext = null;?
??? private testDBHelper mDBHelper = null;?
??? private SQLiteDatabase mTestDatabase = null;?
?
??? private static final String DATABASE_NAME = "DHSeedData.db";??
??? private static final int DATABASE_VERSION = 1;??
??? private static final String TABLE_SEED = "TBseed";??
??? private static final String TABLE_INFO = "TBinfo"; ?
?
??? // 构造函数，一个引用类的Context作为参数
??? public testSeedDB(Context context){?
??????? mContext = context;?
??? }
??? // 打开数据库??
??? public void open(){
??? ????mDBHelper = new testDBHelper(mContext,DATABASE_NAME, null, DATABASE_VERSION);?
??? ????mTestDatabase = mDBHelper.getWritableDatabase();?
??? ????Log.i("testSeedDB", "open");
??? }?
??? // Close the database
??? public void close(){?
??? ?????mDBHelper.close();?
??? } ?
???
??? public void CreateSeedTable() {??
??? // 创建数据表是先删除以前的，以免出错
??? ???String sql = "drop table "+ TABLE_SEED;
??? try {
??? ??? mTestDatabase.execSQL(sql);
??? } catch (SQLException e) {
??? }???
??? // second create table
??????? sql = "CREATE TABLE IF NOT EXISTS " + TABLE_SEED??
??????????????? + " (ID INTEGER PRIMARY KEY, ToyID INTEGER,ToySeed BLOB,ToyMemo TEXT);";??
??????? try {??
??????? mTestDatabase.execSQL(sql);??
??????? } catch (SQLException ex) {??
??????? }??
??? Log.i("testSeedDB", "CreateSeedTable");
??? }??????
??? public void CreateInfoTable() {??
??? // first delete old table
??? String sql = "drop table"+ TABLE_INFO;
??? try {
??? ??? mTestDatabase.execSQL(sql);
??? } catch (SQLException e) {
??? }???
??? // second create table
??? sql = "CREATE TABLE IF NOT EXISTS " + TABLE_INFO??
??????????????? + " (ToyID INTEGER PRIMARY KEY,ToySeed BLOB,ToyMemo TEXT not null);";??
??????? try {??
??????? mTestDatabase.execSQL(sql);??
??????? } catch (SQLException ex) {??
??????? }??
??? }??????
???
??? public void CleanSeedTable() {??
??????? try {??
??????? mTestDatabase.delete(TABLE_SEED, null, null);??
??????? } catch (SQLException e) {??
??????? }?
??? Log.i("testSeedDB", "ClearSeedTable");????????
??? }??????
???
??? public void insertSeedItem(long ToyID, byte[]ToySeed) {??
??? String sqlstr = "insert into " + TABLE_SEED + " (ToyID, ToySeed,ToyMemo) values (?,?,?);";
??? Object[] args = new Object[]{ToyID,ToySeed,null};
??????? try{
??????? mTestDatabase.execSQL(sqlstr,args);??
??????? } catch (SQLException ex) {??
??????? }??
??? Log.i("testSeedDB", "insertSeedItem");????????
???????
??? }?????
?
??? public byte[] GetSeedItem(long ToyID) {??
??? Cursor cur;
??????? byte[] strSeed = null;
???
??????? String col[] = {"ToyID", "ToySeed" ,"ToyMemo"};
??????? String strToy = "ToyID=" +? new Integer((int) ToyID).toString();
??????? try{
??????? cur = mTestDatabase.query(TABLE_SEED, col, strToy, null, null, null, null);
??????????? cur.moveToFirst();
??????????? strSeed = cur.getBlob(1);
??????? } catch (SQLException ex) {??
??????? }??
?? ? ? ?if (cur !=null) cur.close;
??? ????Log.i("testSeedDB", strToy);????????
??????? return strSeed;
??? }?????
?
? ?// 数据操作的基础类，作为数据操作的内嵌子类
??? public class testDBHelper extends SQLiteOpenHelper {
??? public testDBHelper(Context context, String name, CursorFactory factory,
?????????? int version) {
??? ??? super(context, name, factory, version);
??? ??? // TODO Auto-generated constructor stub
??? }
?
??? @Override
??? public voidonCreate(SQLiteDatabase db) {
??? ??? // TODO Auto-generated method stub
??? }
??? ? @Override
??? public voidonUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
??? ??? // TODO Auto-generated method stub
??? }
??? }? // end of testDBHelper
}
// 读文件到 BYTE 来自网上未验证
//http://www.a3gs.com/BookViews.asp?InfoID=2865&ClassID=935
?
导入包：
?
import?java.io.File;
import?java.io.FileInputStream;
import?java.io.IOException;
import?java.io.InputStream;
?
<span styl
