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

原文地址，转载请说明：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;