数据库FMDB（一个db管理者，创建多张表）

1）使用方法

//①创建TIRE_INFO数据库
[DB createTabAtSqliteWithTableName:TIRE_INFO];

//②插入数据
NSDictionary *dic = @{@"power":@"89",
                      @"value":@"2.5",
                      @"pos":@"T2",
                      @"temperature":@"24",
                      @"time":@"2019-08-15",
                      @"vin":@"QSCVHUGIOKWMLWEZ"
                      };
[DB executeUpdateMessageOfTableWithTableName:TIRE_INFO andDictionary:dic];

//③查询某个条件下的相关数据
[DB executeQueryGroupOfTableWithTableName:TIRE_INFO andValue:@"T2"];
[DB executeQueryGroupOfTableWithTableName:TIRE_INFO andValue:@"QSCVHUGIOKWMLWEZ"];

//查询表格中所有数据
[DB executeQueryAllDataOfTableWithTableName:TIRE_INFO];

//④删除某个条件下的一条数据
[DB deleteNumberOfMessageWithTableName:TIRE_INFO andVin:@"QSCVHUGIOKWMLWEZ" andValue:@"T2"];
//删除某张表所有数据
[DB deleteTableAtSqliteWithTableName:TIRE_INFO];

2）相关Demo

demo地址