IOS开源框架FMDB的简单使用

1 创建数据库

 NSString *filename = [[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject] stringByAppendingPathComponent:@"xxx.sqlite"];

FMDatabase *db = [FMDatabase databaseWithPath:filename];

2 打开数据库 

   [db open ];

3 创建table 

 NSString *sql=@"create table ...";

4 插入数据

  NSString *sql=@"insert into ....";

[db executeUpdate:sql] ;

5 更新数据 

[db exeUpdate:sql ];

6 查询数据<span style="font-family: Arial, Helvetica, sans-serif;">FMResultSet *set=[db  executeQuery:sql];</span>

// 遍历结果集 

while(set.next())

{

}

[set close];