FMDB的用法相对简单，主要有几个步骤：初始化并打开数据库，创建表格，执行查询或更新语句，具体如下：
- 1，初始化并打开数据库
//1，初始化并打开数据库
NSString *path = [[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject] stringByAppendingPathComponent:@"company.sqlite"];
NSLog(@"%@",path);
_database = [[FMDatabase alloc] initWithPath:path];
[_database open];
- 2， 创建表格
//2, 创表
[_database executeUpdate:@"CREATE TABLE IF NOT EXISTS t_company (id interger PRIMARY KEY, name text NOT NULL)"];
- 3, 执行更新语句：包括增加，删除等除查询之外的所有其他操作
//3.1,增加数据
//方式一：无格式型
[_database executeUpdate:@"insert into t_company (name) values ('zhangdanfengzhangdanfeng')"];
//方式二：有格式
for (int i=0; i<100;i++) {
NSString *name = [NSString stringWithFormat:@"jiji-%d", arc4random_uniform(500)];
[_database executeUpdateWithFormat:@"insert into t_company (name) values (%@)",name];
}
//3.2,删除数据(删除名字中有问号的所有值)
[_database executeUpdate:@"delete from t_company where name like '%?%'"];
- 4, 执行查询语句
//4，查询数据，%是通配符，表示一个或者一个以上的任意值
FMResultSet *set = [_database executeQuery:@"select * from t_company where name like '%?%'"];
while (set.next) {
NSString *name = [set stringForColumn:@"name"];
NSLog(@"%@",name);
}
