转：Android SQLite 数据库 存取 BLOB 二进制 文件

nikoo

　　

原文地址，转载请说明：http://blog.sina.com.cn/s/blog_539070ad0100nesa.html

   Android开发时用到二进制数据（也可以理解为BYTE数组）的SQLite存取，可能会有人对存取如mp3、图片类文件困惑，其实mp3、图片类文件读到内存就可理解为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;