iPhone學(xué)習(xí) Sqlite數(shù)據(jù)庫(kù)讀寫(xiě)圖片實(shí)例
iPhone學(xué)習(xí) Sqlite數(shù)據(jù)庫(kù)讀寫(xiě)圖片實(shí)例是本文要介紹的內(nèi)容,內(nèi)容不多,基本是基于代碼實(shí)現(xiàn),我們來(lái)看內(nèi)容講解。用 iPhone 的 sqlite 數(shù)據(jù)庫(kù)讀寫(xiě)圖片,先把你的圖片轉(zhuǎn)換成 NSData 形式,然后在數(shù)據(jù)庫(kù)添加一行 blob 數(shù)據(jù),代碼如下(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 = 你的數(shù)據(jù)庫(kù);
 - 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];
 
小結(jié):iPhone學(xué)習(xí) Sqlite數(shù)據(jù)庫(kù)讀寫(xiě)圖片實(shí)例的內(nèi)容介紹完了,希望本文對(duì)你有所幫助!















 
 
 

 
 
 
 