FMDB_MoreListTest-

对数据库中的数据进行：增删改查，操作。并且：给数据表绑定触发器，监听数据的，增加／修改／删除操作。

// 创建日志数据表 [db executeUpdate:@"create table IF NOT EXISTS SYSTEM_SYNC_LOG( PK_VAL VARCHAR(50) not null, T_NAME VARCHAR(50) not null, ACTION VARCHAR(10) not null, CREATE_DATE TIMESTAMP DEFAULT CURRENT_TIMESTAMP, primary key (PK_VAL, T_NAME)); create unique index SYSTEM_SYNC_LOG_PK on SYSTEM_SYNC_LOG ( PK_VAL ASC, T_NAME ASC );"];

// 查询所有的系统日志

(NSMutableArray *)searchAllSYSTEM_SYNC_LOG { NSMutableArray *arrM = [NSMutableArray array]; [self.queue inTransaction:^(FMDatabase *db, BOOL *rollback) {

  NSString *sql1 = @"SELECT * FROM 'SYSTEM_SYNC_LOG' JOIN 'T_Person' ON SYSTEM_SYNC_LOG.PK_VAL = T_Person.personId";
  FMResultSet *rs = [db executeQuery:sql1];
  while ([rs next]) {
      
      int personId = [rs intForColumn:@"personId"];
      NSString *personName = [rs stringForColumn:@"personName"];
      int age = [rs intForColumn:@"age"];
      NSString *phoneNo = [rs stringForColumn:@"phoneNo"];
      int companyId = [rs intForColumn:@"companyId"];
      NSString * createDate = [rs stringForColumn:@"CREATE_DATE"];
      
      if ([phoneNo isEqualToString:@""] || [phoneNo isEqualToString:@"(null)"]) {
          phoneNo = @"0";
      }
      if ([personName isEqualToString:@""] || [personName isEqualToString:@"(null)"]) {
          personName = @"0";
      }
      if ([[NSString stringWithFormat:@"%d", age] isEqualToString:@""] || [[NSString stringWithFormat:@"%d", age] isEqualToString:@"(null)"]) {
          age = 0;
      }
      
      NSDictionary *dict = @{@"personId" : @(personId),
                             @"personName" : personName,
                             @"age" : @(age),
                             @"phoneNo" : phoneNo,
                             @"companyId" : @(companyId),
                             @"createDate" : createDate
                             };
      [arrM addObject:dict];
  }
  
  
  NSString *sql2 = @"SELECT * FROM 'SYSTEM_SYNC_LOG' WHERE ACTION = 'D'";
  FMResultSet *rs1 = [db executeQuery:sql2];
  while ([rs1 next]) {
      NSString * t_name = [rs1 stringForColumn:@"T_NAME"];
      
      NSString * action = [rs1 stringForColumn:@"ACTION"];
      
      NSString * namelistId = [rs1 stringForColumn:@"PK_VAL"];
      
      NSString * createDate = [rs1 stringForColumn:@"CREATE_DATE"];
      
      NSDictionary * dict=@{
                            @"tableName":t_name
                            ,@"action":action
                            ,@"namelistId":namelistId
                            ,@"createDate":createDate
                            };
      [arrM addObject:dict];
  }
  
  
  NSString *sql3 = @"SELECT * FROM 'SYSTEM_SYNC_LOG' JOIN 'T_Company' ON SYSTEM_SYNC_LOG.PK_VAL = T_Company.companyId";
  FMResultSet *rs3 = [db executeQuery:sql3];
  while ([rs3 next]) {
      
      int companyId = [rs3 intForColumn:@"companyId"];
      NSString *companyName = [rs3 stringForColumn:@"companyName"];
      NSString * createDate = [rs3 stringForColumn:@"CREATE_DATE"];
      
      NSDictionary *dict = @{@"companyId" : @(companyId),
                             @"companyName" : companyName,
                             @"createDate" : createDate
                             };
      [arrM addObject:dict];
  }

}];

return arrM; }

//删除日志表

(void)deleteAllSYSTEM_SYNC_LOG { [self.queue inTransaction:^(FMDatabase *db, BOOL *rollback) {
```
  [db executeUpdate:@"DELETE FROM SYSTEM_SYNC_LOG"];
```
}];

} @end

YangZhen5352/FMDB_MoreList

FMDB_MoreListTest-