iOS中SQLite的操作方法

// 插入语句
- (void)insertTable
{
 // 创建sql语句
 NSString *sql = @"insert into teacher(name,id) values(&＃63;,&＃63;)";
 // 不可变参数
// BOOL isOK = [QYSQLiteManager insertTableWithSqlString:sql andArray:@[@"小明",@115]];
 // 可变参数
 BOOL isOK = [QYSQLiteManager insertTableWithSqlString:sql andObjects:@"小明",@"115", nil];
 if (isOK) {
  NSLog(@"数据插入成功");
 } else {
  NSLog(@"数据插入失败");
 }
}
// 查询语句
- (void)selectTable
{
 NSString *sql = @"select * from teacher";
 [QYSQLiteManager selectTableWithSqlString:sql didFinishedBlock:^(NSArray *dataList, NSString *error) {
  NSLog(@"%@",dataList);
 } andObjects:nil];
}

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

// 更新数据语句
- (void)updateTable
{
 NSString *sql = @"update teacher set name = &＃63; where id = &＃63;";
 if ([QYSQLiteManager updateTableWithSqlString:sql andArray:@[@"小明",@115]]) {
  NSLog(@"更新成功");
 }
}

for (int i = 0; i