android – SQLite – 是否可以通过insert语句插入BLOB？

我正在开发一个 Android应用程序,我正在使用一个sqlite数据库来存储一些位图.当用户安装应用程序时,我想要自动插入一些图像.

我正在使用sqliteOpenHelper类：

public class DatabaseHelper extends sqliteOpenHelper {

...

DatabaseHelper(Context context,String nameOfDB,int version,String[] scriptsqlCreate,String scriptsqlDelete) {
    super(context,nameOfDB,null,version);

    this.scriptsqlCreate = scriptsqlCreate;
    this.scriptsqldelete = scriptsqldelete;
}

@Override
public void onCreate(sqliteDatabase db) {
    int numScripts = scriptsqlCreate.length;
    for(int i = 0; i<numScripts; i++){
    Log.i(tag,"CreaTing database,execuTing script " + i);
    db.execsql(scriptsqlCreate[i]);
    }
}
}

…

我想传递一个常量到上面显示的scriptsqlCreate参数,就像这样：

private static final String[] SCRIPT_DATABASE_CREATE = {
   "create table memes(  id INTEGER PRIMary key autoincrement," + 
                     + " img blob not null," + 
                     + " @R_548_4687@t not null uniquE)","insert into memes(img,Name) values(BITMAP1,'1.jpg')",Name) values(BITMAP2,'2.jpg')",Name) values(BITMAP3,'3.jpg')"}    

}

任何帮助将会很多,

谢谢,
Tulio Zahn

insert into memes(img,Name) values(X'0102030405060708090a0b0c0d0e0f','1.jpg')

sqliteStatement p = sqlite.compileStatement("insert into memes(img,Name) values(?,?)");

byte[] data = loadData("1.jpg");
p.bindBlob(1,data);
p.bindString(2,"1.jpg");
p.execute();

byte[] data = loadData("2.jpg");
p.bindBlob(1,"2.jpg");
p.execute();