fmdb常用操作代码详解手机开发

-(NSString *)databaseFilePath 
{ 
    //获取数据库路经 
    NSString *url = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES)lastObject]; 
    NSString *fileName = [url stringByAppendingPathComponent:@"sqlTJL.sqlite"]; 
    return fileName; 
} 
  
-(void)fmdbData 
{ 
      
    //获取数据库 
    _db = [FMDatabase databaseWithPath:[self databaseFilePath]]; 
    //打开数据库 
    if ([_db open]) { 
    //建表 
        BOOL result = [_db executeUpdate:@"CREATE TABLE IF NOT EXISTS TJL_student(name text)"]; 
        if (result) { 
            NSLog(@"建表成功"); 
        }else{ 
            NSLog(@"建表失败"); 
        } 
        [_db close]; 
    } 
} 
  
//插入数据 
-(void)insetsqlto:(NSString *)string 
{ 
    [_db open]; 
    if ([_db open]) { 
        BOOL res = [_db executeUpdate:@"insert into TJL_student (name) VALUES(?)", string]; 
        if (!res) { 
            NSLog(@"error"); 
        }else{ 
            NSLog(@"success to insert"); 
        } 
        [_db close]; 
    } 
} 
//删除数据 
-(void)deleteopen:(NSString *)dataName 
{ 
    if ([_db open]) { 
        NSString *deleteSql = [NSString stringWithFormat:@"delete from TJL_student %@",dataName]; 
        BOOL res = [_db executeUpdate:deleteSql]; 
        if (!res) { 
            NSLog(@"error when delete db table"); 
        }else{ 
            NSLog(@"success to delete db table"); 
        } 
        [_db open]; 
    } 
} 
  
//修改数据 
-(void)updataName:(NSString *)string 
{ 
    if ([_db open]) { 
        NSString *updatesql = [NSString stringWithFormat:@"UPDATE TJL_student'%@'",string]; 
        BOOL RES = [_db executeUpdate:updatesql]; 
        if (!RES) { 
            NSLog(@"error when update db table"); 
        }else{ 
            NSLog(@"success to insert db able"); 
        } 
        [_db close]; 
    } 
} 
  
//查询数据 
-(void)seacher:(NSString *)seaharName 
{ 
    if ([_db open]) { 
        FMResultSet *rs = [_db executeQuery:@"SELECT * FROM TJL_student"]; 
        while ([rs next]) { 
            _Devices = [rs stringForColumn:@"name"]; 
            NSLog(@"is text---->>> %@",[rs stringForColumn:@"name"]); 
        } 
    } 
}