////  ViewController.m//  图片存取////  Created by apple on 14-8-28.//  Copyright (c) 2014年 apple. All rights reserved.//#import "ViewController.h"#import <sqlite3.h>@interface ViewController ()            @end@implementation ViewController            - (void)viewDidLoad {    [super viewDidLoad];    NSString *imagePath=[[NSBundle mainBundle]pathForResource:@"20140727_4a88ec45b0ba50d4f06015b18521e12b" ofType:@"png"];    NSData *imageData=http://www.mamicode.com/UIImagePNGRepresentation([UIImage imageWithContentsOfFile:imagePath]);    NSString *bdPath=[NSHomeDirectory() stringByAppendingPathComponent:@"/Documents/image.bd"];    NSLog(@"%@",bdPath);        sqlite3 *imageDatabase;    int ret=sqlite3_open([bdPath UTF8String],&imageDatabase);    if (ret!=SQLITE_OK) {        NSLog(@"open failed");        return;    }        NSString *sql=@"CREATE TABLE IF NOT EXISTS history (hid integer primary key autoincrement not null, name text,image blob)";    sqlite3_stmt *stmt;    ret=sqlite3_prepare(imageDatabase, [sql UTF8String], -1, &stmt, NULL);    if (ret!=SQLITE_OK) {        NSLog(@"prepare  failed");                sqlite3_close(imageDatabase);        return;    }        //执行SQL语句        ret = sqlite3_step(stmt);        if (ret != SQLITE_DONE) {            NSLog(@"step failed!");                //终止会话            sqlite3_finalize(stmt);            sqlite3_close(imageDatabase);            return;        }            sqlite3_finalize(stmt);        NSString *insertSQL2 = @"INSERT INTO history (name,image) VALUES(?,?)";    sqlite3_stmt *stmt2;    ret = sqlite3_prepare_v2(imageDatabase, [insertSQL2 UTF8String], -1, &stmt2, NULL);    if (ret != SQLITE_OK) {        NSLog(@"prepare stmt2 failed");        sqlite3_close(imageDatabase);        return;    }        NSString *name = @"赵柳";        //给会话绑定数据    sqlite3_bind_text(stmt2, 1, [name UTF8String], -1, NULL);    sqlite3_bind_blob(stmt2, 2, [imageData bytes], [imageData length], NULL);    ret = sqlite3_step(stmt2);    if (ret != SQLITE_DONE) {        NSLog(@"insert stmt2 failed");        sqlite3_finalize(stmt2);        sqlite3_close(imageDatabase);        return;    }    else {        int count = sqlite3_changes(imageDatabase);        NSLog(@"insert success: %d", count);    }    sqlite3_close(imageDatabase);        //取图片    NSString *select = @"SELECT * FROM history where name=?";    sqlite3_stmt *stmtGet;    ret = sqlite3_prepare_v2(imageDatabase, [select UTF8String], -1, &stmtGet, NULL);    if (ret != SQLITE_OK) {        NSLog(@"prepare stmt2 failed");        sqlite3_close(imageDatabase);        return;    }    else    {        NSString *name=@"赵柳";        sqlite3_bind_text(stmtGet, 1,[name UTF8String], -1, NULL);        if (sqlite3_step(stmtGet)==SQLITE_ROW) {            int byte=sqlite3_column_bytes(stmtGet, 2);            Byte *imgByte=(Byte *)sqlite3_column_blob(stmtGet, 2);            NSData *imgData=http://www.mamicode.com/[NSData dataWithBytes:imgByte length:byte];            UIImageView *imageView=[[UIImageView alloc]initWithFrame:CGRectMake(100, 100, 100, 100)];            imageView.backgroundColor=[UIColor redColor];            imageView.image=[UIImage imageWithData:imgData];            [self.view addSubview:imageView];        }        sqlite3_close(imageDatabase);    }    //    NSString *name = @"赵柳";        }- (void)didReceiveMemoryWarning {    [super didReceiveMemoryWarning];    // Dispose of any resources that can be recreated.}@end