一 使用原生库
1 新建或插入
sqlite3 *db; if (sqlite3_open(@"xx.db", &db) != SQLITE_OK ) { return; } sqlite3_stmt *dbps; int dbrc; NSString *sql = @""; const char *sqlChar = [sql UTF8String]; dbrc = sqlite3_prepare_v2(db, sqlChar, -1, &dbps, NULL); dbrc = sqlite3_step(dbps); if(dbrc != SQLITE_DONE){ NSLog(@"exec sql error!,sql:%@,error code:%d.",sql,dbrc); } sqlite3_finalize(dbps); sqlite3_close(db);
2 查询
sqlite3 *db; int dbrc; sqlite3_stmt *dbps; if (sqlite3_open(@"xx.db", &db) != SQLITE_OK ) { NSLog(@"couldnet't open db:"); return; } NSString *sql = @"select * from sqlite3_master "; const char *sqlChar = [sql UTF8String]; dbrc = sqlite3_prepare_v2 (db, sqlChar, -1, &dbps, NULL); while ((dbrc = sqlite3_step (dbps)) == SQLITE_ROW) { NSLog([[NSString alloc] initWithUTF8String:(char*) sqlite3_column_text(dbps, 0)]); } sqlite3_finalize(dbps); sqlite3_close(db);
二 使用CSqliteDatabase
待续
1 楼 LinuxFans 2011-03-24
不错的总结