iPhone-SDK 的最佳 SQLite 3 教程在哪里 [关闭]

iPhone-SDK 的最佳 SQLite 3 教程

objective-c
sqlite3 *db;
NSString *databasePath = [[NSBundle mainBundle] pathForResource:@"mydatabase" ofType:@"sqlite"];
if (sqlite3_open([databasePath UTF8String], &db) == SQLITE_OK) {
    NSLog(@"数据库打开成功");
} else {
    NSLog(@"数据库打开失败");
}

objective-c
if (sqlite3_close(db) == SQLITE_OK) {
    NSLog(@"数据库关闭成功");
} else {
    NSLog(@"数据库关闭失败");
}

objective-c
NSString *createTableSQL = @"CREATE TABLE IF NOT EXISTS user (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, age INTEGER)";
if (sqlite3_exec(db, [createTableSQL UTF8String], NULL, NULL, NULL) == SQLITE_OK) {
    NSLog(@"表创建成功");
} else {
    NSLog(@"表创建失败");
}

objective-c
NSString *dropTableSQL = @"DROP TABLE IF EXISTS user";
if (sqlite3_exec(db, [dropTableSQL UTF8String], NULL, NULL, NULL) == SQLITE_OK) {
    NSLog(@"表删除成功");
} else {
    NSLog(@"表删除失败");
}

objective-c
// 插入数据
NSString *insertSQL = @"INSERT INTO user (name, age) VALUES ('张三', 20)";
if (sqlite3_exec(db, [insertSQL UTF8String], NULL, NULL, NULL) == SQLITE_OK) {
    NSLog(@"数据插入成功");
} else {
    NSLog(@"数据插入失败");
}
// 查询数据
NSString *querySQL = @"SELECT * FROM user";
sqlite3_stmt *statement;
if (sqlite3_prepare_v2(db, [querySQL UTF8String], -1, &statement, NULL) == SQLITE_OK) {
    while (sqlite3_step(statement) == SQLITE_ROW) {
        int userId = sqlite3_column_int(statement, 0);
        char *name = (char *)sqlite3_column_text(statement, 1);
        int age = sqlite3_column_int(statement, 2);
        NSLog(@"用户ID：%d，姓名：%s，年龄：%d", userId, name, age);
    }
    sqlite3_finalize(statement);
} else {
    NSLog(@"数据查询失败");
}
// 更新数据
NSString *updateSQL = @"UPDATE user SET age = 25 WHERE name = '张三'";
if (sqlite3_exec(db, [updateSQL UTF8String], NULL, NULL, NULL) == SQLITE_OK) {
    NSLog(@"数据更新成功");
} else {
    NSLog(@"数据更新失败");
}
// 删除数据
NSString *deleteSQL = @"DELETE FROM user WHERE name = '张三'";
if (sqlite3_exec(db, [deleteSQL UTF8String], NULL, NULL, NULL) == SQLITE_OK) {
    NSLog(@"数据删除成功");
} else {
    NSLog(@"数据删除失败");
}