先看看网上找的例子代码:
写入:
NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
NSString *dataPath = [[paths objectAtIndex:0] stringByAppendingPathComponent:@”sqlite.sqlite”];
NSData *image=UIImagePNGRepresentation([UIImage imageNamed:@"01_02.png"]);
NSString *aaa=[[NSString alloc]initWithFormat:@”update cards set c_image=? where id=1″];
sqlite3 *database;
if (sqlite3_open([dataPath UTF8String], &database) == SQLITE_OK){
sqlite3_stmt * compliedStatement;
sqlite3_prepare(database,[aaa UTF8String],-1,&compliedStatement,0);
sqlite3_bind_blob(compliedStatement, 1, [image bytes], [image length], NULL);
int result=sqlite3_step(compliedStatement);
if (result==SQLITE_DONE) {
}
sqlite3_finalize(compliedStatement);
}
sqlite3_close(database);
[aaa release];
读取: