// 插入語(yǔ)句
- (void)insertTable
{
 // 創(chuàng)建sql語(yǔ)句
 NSString *sql = @"insert into teacher(name,id) values(?,?)";
 // 不可變參數(shù)
// BOOL isOK = [QYSQLiteManager insertTableWithSqlString:sql andArray:@[@"小明",@115]];
 // 可變參數(shù)
 BOOL isOK = [QYSQLiteManager insertTableWithSqlString:sql andObjects:@"小明",@"115", nil];
 if (isOK) {
  NSLog(@"數(shù)據(jù)插入成功");
 } else {
  NSLog(@"數(shù)據(jù)插入失敗");
 }
}
// 查詢語(yǔ)句
- (void)selectTable
{
 NSString *sql = @"select * from teacher";
 [QYSQLiteManager selectTableWithSqlString:sql didFinishedBlock:^(NSArray *dataList, NSString *error) {
  NSLog(@"%@",dataList);
 } andObjects:nil];
}

// 修改表語(yǔ)句
- (void)alterTable
{
 NSString *sql = @"alter table teacher add column pwd integer";
 if([QYSQLiteManager alterTableWithSqlString:sql])
 {
  NSLog(@"修改成功");
 }
}

// 更新數(shù)據(jù)語(yǔ)句
- (void)updateTable
{
 NSString *sql = @"update teacher set name = ? where id = ?";
 if ([QYSQLiteManager updateTableWithSqlString:sql andArray:@[@"小明",@115]]) {
  NSLog(@"更新成功");
 }
}

for (int i = 0; i < column_count; i++) {
     // 獲取字段名
     char * keyName = (char *)sqlite3_column_name(stmt, i);
     NSString *key = [NSString stringWithUTF8String:keyName];
     if (sqlite3_column_type(stmt, i) == SQLITE_TEXT) { // 當(dāng)字段數(shù)據(jù)是“text”時(shí)
      // 獲取字段對(duì)應(yīng)的數(shù)據(jù)
      char *valueName = (char *)sqlite3_column_text(stmt, i);
      NSString *value = [NSString stringWithUTF8String:valueName];
      [dataDic setObject:value forKey:key];
     } else { // 當(dāng)字段數(shù)據(jù)是integer時(shí)
      int value = sqlite3_column_int(stmt, i);
      [dataDic setObject:@(value) forKey:key];
     }
    }