ios图片存入数据库_iOS下用sqlite数据库存储图片

在iOS下用sqlite数据库存储图片，先把你的图片转换成 NSData 形式，然后在数据库添加一行 blob

数据，代码如下(data就是图片) ：

NSMutableString *insertSql = [[NSMutableString alloc]

initWithString:@”INSERT INTO “];

[insertSql appendString:BLOB];

[insertSql appendString:@" ("];

[insertSql appendString:BLOB_DATA];

[insertSql appendString:@") VALUES(?1)"];

sqlite3_stmt *insert_statement = nil;

sqlite3 *database = 你的数据库;

if (sqlite3_prepare_v2(database, [insertSql UTF8String], -1,

&insert_statement, NULL) == SQLITE_OK) {

sqlite3_bind_blob(insert_statement, 1, [data bytes], [data length],

NULL);

if(sqlite3_step(insert_statement) != SQLITE_DONE) {

NSLog(@”Db error %s”, sqlite3_errmsg(database));

}

} else {

NSLog(@”Db error %s”, sqlite3_errmsg(database));

}

sqlite3_finalize(insert_statement);

[insertSql release];

原贴：http://heidianfeng.blog.163.com/blog/static/6184345620114164373763/