数据库sqilite学习二（FMDB的使用）

#pragma mark - 01、打开数据库并新建一个表
- (BOOL)openDatabase{
    //1.获得数据库文件的路径
    NSString *path = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES)lastObject];
    NSString *sqlFilePath = [path stringByAppendingPathComponent:@"1234.sqlite"];
    //2.获得数据库
    FMDatabase *db=[FMDatabase databaseWithPath:sqlFilePath];
    self.db=db;
    
    //3.打开数据库
    if ([db open]) {
        BOOL result= [db executeUpdate:@"create table if not exists t_student (id integer primary key autoincrement, name text, age integer,useid text);"];
        NSLog(@"新建t_student成功");
        return result;
    }
    return NO;
}


#pragma mark - 插入数据
 -(void)insert
 {
      for (int i = 0; i<self.DataArray.count; i++) {
      Student *s =self.DataArray[i];
          
      BOOL sucess=[self.db executeUpdateWithFormat:@"INSERT INTO t_student  (useid,name,age) VALUES (%@,%@,%@);",s.useid,s.name,@(s.age)];
          
    //BOOL sucess=[self.db executeUpdate:@"INSERT INTO t_student (useid,name,age) VALUES (?,?,?);",s.useid , s.name,@(s.age)];//不确定的参数用?来占位
          
    // BOOL sucess=[self.db  executeUpdate:@"INSERT INTO t_student (useid,name,age) VALUES (?,?,?);" withArgumentsInArray:@[s.useid,s.name,@(s.age)]];
          
          if (sucess) {
              NSLog(@"插入成功");
          }
     }
 }