android sqlite blob,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

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," +

+ " name text not null unique)" ,

"insert into memes(img,name) values(BITMAP1,'1.jpg')",

"insert into memes(img,name) values(BITMAP2,'2.jpg')",

"insert into memes(img,name) values(BITMAP3,'3.jpg')"}

}

任何帮助将会很多,

谢谢,

Tulio Zahn