sqlite3資料庫的操作（iphone開發）

　　下面是對sqlite3資料庫的操作，首先是要倒入類，最基本的，但不要忘記。我對資料庫的操作進行了單獨的處理，自己看著比較舒服，也好明白，需要用到時，直接調用久好了，也可以有代理，一直沒研究，日後好好看看，先總結這些，方便自己查看，忘記時找找，老不用會很快忘記，方便自己吧！

#import </usr/include/sqlite3.h>#define kFilename @"data.sqlite3" 1.開啟資料庫操作-(void)openDB {NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);    NSString *documentsDirectory = [paths objectAtIndex:0];NSString *dataFilePath =  [documentsDirectory stringByAppendingPathComponent:kFilename];if (sqlite3_open([dataFilePath UTF8String], &database) != SQLITE_OK) {sqlite3_close(database);}}2.建立表，結構，類型- (void)initDB {char *errorMsg;NSString *sql = @"CREATE TABLE IF NOT EXISTS USER (USER_ID INTEGER PRIMARY KEY,USERNAME TEXT,PASSWORD TEXT);";if (sqlite3_exec(database, [sql UTF8String], NULL, NULL, &errorMsg) != SQLITE_OK) {sqlite3_close(database);}}3.執行添加方法 - (void)insertUsername:(NSString *)username insertPassword:(NSString *)password {[self openDB];//調用開啟庫[self initDB];//調用建立表char *errorMsg;char *update = "INSERT OR REPLACE INTO USER (USERNAME,PASSWORD) VALUES (?,?);";//添加語句 NSString *sql = [NSString stringWithFormat:@"SELECT USERNAME,PASSWORD FROM USER"];//查詢語句 sql = @"DELETE FROM USER;";//刪除語句  sqlite3_stmt *statement;if (sqlite3_prepare_v2(database, update, -1, &statement, nil) == SQLITE_OK) {sqlite3_bind_text(statement, 1, [username UTF8String], -1, SQLITE_TRANSIENT);sqlite3_bind_text(statement, 2, [password UTF8String], -1, SQLITE_TRANSIENT);}if (sqlite3_step(statement) != SQLITE_DONE)NSAssert1(0,@"Error updating table:%s",errorMsg);sqlite3_finalize(statement);sqlite3_close(database);}