sqlite数据库

最新推荐文章于 2022-07-12 10:48:33 发布

xie_neu

最新推荐文章于 2022-07-12 10:48:33 发布

阅读量695

点赞数

分类专栏： ios开发技巧文章标签： sqlite

本文链接：https://blog.csdn.net/u013087068/article/details/43983413

版权

ios开发技巧专栏收录该内容

9 篇文章 0 订阅

订阅专栏

ios中通用的sqlite数据库的版本是sqlite3,它具有移植性强，可靠性高，小而容易使用等特点。在ios工程中如果需要使用sqlite数据库，那么需要添加库 sqlite3.dylib或者 sqlite3.0.dylib。

代码演示：

1、创建表：

-(void) createDB
{
    NSString *documentDirectory = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject];
    NSString *DBPath = [documentDirectory stringByAppendingString:@"DB"];
    if(sqlite3_open([DBPath UTF8String], &_db) != SQLITE_OK)
    {
        sqlite3_close(_db);
        NSLog(@"数据库打开失败");
    }else{
        char *err;
        NSString *createSQL = [NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS STU (NO TEXT primary key, name TEXT)"];
        if(sqlite3_exec(_db, [createSQL UTF8String], NULL, NULL, &err) != SQLITE_OK){
            sqlite3_close(_db);
            NSLog(@"创建表失败");
        }else {
            NSLog(@"创建表成功");
        }
        sqlite3_close(_db);
    }
}

2、查询数据

-(Stu *) findByNo:(Stu *) model{
    NSString *documentDirectory = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject];
    NSString *DBPath = [documentDirectory stringByAppendingString:@"DB"];
    if(sqlite3_open([DBPath UTF8String], &_db) != SQLITE_OK)
    {
        sqlite3_close(_db);
        NSLog(@"数据可打开失败");
    }else{
        NSString *qsql = @"select no, name from STU where no = ?";
        sqlite3_stmt *statement;
        //预处理
        if(sqlite3_prepare_v2(_db, [qsql UTF8String], -1, &statement, NULL) == SQLITE_OK){
            //绑定参数
            sqlite3_bind_text(statement, 1,"123" , -1, NULL);
        }
        //开始查询
        if(sqlite3_step(statement) == SQLITE_ROW){
            char *no = (char *)sqlite3_column_text(statement, 0);
            NSString *stringNO = [[NSString alloc]initWithUTF8String:no];

            char *name = (char *) sqlite3_column_text(statement, 1);
            NSString *stringName = [[NSString alloc] initWithUTF8String:name];

            Stu *s = [[Stu alloc]init];
            s.no = stringNO;
            s.name = stringName;

            sqlite3_finalize(statement);
            return s;

        }
    }
    return nil;
}

3、插入式数据

-(void) insertData{
    NSString *documentDirectory = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject];
    NSString *DBPath = [documentDirectory stringByAppendingString:@"DB"];
    if(sqlite3_open([DBPath UTF8String], &_db) != SQLITE_OK){
        sqlite3_close(_db);
        NSLog(@"打开表失败");
    }else{
         NSString *insetString = @"insert into STU(no,name) values(?,?)";
        sqlite3_stmt *statement;
        if(sqlite3_prepare_v2(_db, [insetString UTF8String], -1, &statement, NULL) == SQLITE_OK){
            sqlite3_bind_text(statement, 1, [@"123" UTF8String] , -1, NULL);
            sqlite3_bind_text(statement, 2, [@"xieguangqian" UTF8String], -1, NULL);
            if(sqlite3_step(statement) != SQLITE_OK){
                NSLog(@"插入数据成功");
            }else{
                NSLog(@"插入数据失败");
            }
            sqlite3_close(_db);
        }
    }
}

4、删除数据

-(void)remove{
    NSString *documentDirectory = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject];
    NSString *DBPath = [documentDirectory stringByAppendingString:@"DB"];

    if(sqlite3_open([DBPath UTF8String], &_db) != SQLITE_OK){
        sqlite3_close(_db);
        NSLog(@"--remove---打开数据库失败");
    }else {
        NSString *sqlde = @"delete from STU where no = ?";
        sqlite3_stmt *statement;
        if(sqlite3_prepare_v2(_db, [sqlde UTF8String], -1, &statement, NULL) == SQLITE_OK){
            sqlite3_bind_text(statement, 1, [@"123" UTF8String], -1, NULL);
            if(sqlite3_step(statement) == SQLITE_DONE){
                NSLog(@"已删除");
            }
        }
        sqlite3_close(_db);
    }
}

5 、修改数据

-(void) modify{
    NSString *documentDirectory = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject];
    NSString *DBPath = [documentDirectory stringByAppendingString:@"DB"];

    if(sqlite3_open([DBPath UTF8String], &_db) != SQLITE_OK){
        sqlite3_close(_db);
        NSLog(@"数据库打开失败");
    }else {
        NSString *modifySql = @"update STU set name = ? where no = ?";
        sqlite3_stmt *statement;
        if(sqlite3_prepare_v2(_db, [modifySql UTF8String], -1, &statement, NULL) == SQLITE_OK){
            sqlite3_bind_text(statement, 1, [@"zhangsisi" UTF8String], -1, NULL);
            sqlite3_bind_text(statement, 2, [@"123" UTF8String], -1, NULL);

            if(sqlite3_step(statement) != SQLITE_DONE){
                NSLog(@"修改失败");

            }
            sqlite3_finalize(statement);
            sqlite3_close(_db);
        }else{
            NSLog(@"12345");
        }
    }
}