假定数据库中存在表 test_table(name,image), 下面代码将图片文件test.png的二进制数据写到sqlite数据库:
CHAR *name = "test";
NSString * nameString = [NSString stringWithCString:name encoding:NSUTF8StringEncoding];
NSString * filePath = [[NSBundle mainBundle] pathForResource:nameString ofType:@"png"];
IF ([[NSFileManager defaultManager] fileExistsAtPath:filePath])
{
NSData * imgData = UIImagePNGRepresentation([UIImage imageWithContentsOfFile:filePath]);
const CHAR * sequel = "insert into test_table(name,image) values(?,?)";
sqlite3_stmt * UPDATE;
IF (sqlite3_prepare_v2(DATABASE, sequel, -1, &UPDATE, NULL) == SQLITE_OK)
{
sqlite3_bind_text(UPDATE, 1, name, -1, NULL);
sqlite3_bind_blob(UPDATE, 2, [imgData bytes], [imgData LENGTH], NULL);