¡@

Home 

2014/10/15 ¤U¤È 10:05:21

iphone Programming Glossary: compiledstmt

store and retrieve image into sqlite database for iphone

http://stackoverflow.com/questions/8728834/store-and-retrieve-image-into-sqlite-database-for-iphone

documentdir documentpath objectAtIndex 0 dbPath documentdir stringByAppendingPathComponent dbName sqlite3_stmt compiledStmt if sqlite3_open dbPath UTF8String database SQLITE_OK NSLog @ Name @ Company @ URL @ model.personName model.companyName model.imgurl.. const char insertSQL insert or ignore into Persons PersonName CompanyName ImgUrl UserImage values sqlite3_bind_text compiledStmt 1 model.personName UTF8String 1 SQLITE_TRANSIENT sqlite3_bind_text compiledStmt 2 model.companyName UTF8String 1 SQLITE_TRANSIENT.. UserImage values sqlite3_bind_text compiledStmt 1 model.personName UTF8String 1 SQLITE_TRANSIENT sqlite3_bind_text compiledStmt 2 model.companyName UTF8String 1 SQLITE_TRANSIENT sqlite3_bind_text compiledStmt 3 model.imgurl UTF8String 1 SQLITE_TRANSIENT..