sqlite数据库

     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");
        }
    }
}