IOS学习札记28—SQLite3第三方库之FMDB

IOS学习笔记28—SQLite3第三方库之FMDB

FMResultSet还支持以下方式获取值：

• intForColumn:
• longForColumn:
• longLongIntForColumn:
• boolForColumn:
• doubleForColumn:
• stringForColumn:
• dateForColumn:
• dataForColumn:
• dataNoCopyForColumn:
• UTF8StringForColumnIndex:
• objectForColumn:

  
  

  
  

  
  

  -(void)executeDBOperation{ //获取Document文件夹下的数据库文件，没有则创建 NSString *docPath = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) objectAtIndex:0]; NSString *dbPath = [docPath stringByAppendingPathComponent:@"user.db"]; FMDatabaseQueue *databaseQueue = [FMDatabaseQueue databaseQueueWithPath:dbPath]; [databaseQueue inDatabase:^(FMDatabase *db){ [db executeUpdate:@"insert into user values (?,?,?)",@"Ren",@"Male",[NSNumber numberWithInt:20]]; }]; [databaseQueue close];}
  

  欢迎关注我的新浪微博和我交流：@唐韧_Ryan

  
  

  
  

  1楼wangqiuyun前天 00:43

  顶起！