FMDB是一个很好用并且使用很广泛的iOS开源数据库操作库,可以让我们更方便的操作数据库
下面来看一下怎么使用
1.把第三方库倒入工程中
2.让倒入的.m文件支持arc(1.打开:你的target - Bulid Phases -Compile Sources。2.双击对应的*.m文件。3.在弹出的窗口中输入上面提到的标签 -fobjc-arc / -fno-objc-arc4.直接按Enter键保存) 输入 -fno-objc-arc
3.到入系统类库 libsql3.0
//创建数据表
FMDatabase * db = [FMDatabase databaseWithPath:[NSHomeDirectory() stringByAppendingPathComponent:@"Documents/test.sqlite"]];
NSLog(@"====%@",db);
if (![db open]){
[db close];
return nil;
}
if (![db tableExists:@"student"]){
[db executeUpdate:@"CREATE TABLE student (id integer PRIMARY KEY autoincrement,name text,num integer)"];
}
//增
[db executeUpdate:@"INSERT INTO student (name,num) VALUES (?,?)",student.s_name,[NSString stringWithFormat:@"%d",student.s_num]];
//删
[db executeUpdate:@"DELETE FROM student WHERE id=?",[NSString stringWithFormat:@"%d",student.s_id]];
//改
[db executeUpdate:@"UPDATE student SET name=?,num=? WHERE id=?",[NSString stringWithFormat:@"%@",student.s_name],[NSString stringWithFormat:@"%d",student.s_num],[NSString stringWithFormat:@"%d",student.s_id]];
//查
FMResultSet *resultSet = [db executeQuery:@"SELECT * FROM student"];
NSMutableArray *array = [[NSMutableArray alloc] initWithCapacity:0];
while ([resultSet next]){
Student *student = [[Student alloc] init];
student.s_name = [resultSet stringForColumn:@"name"];
NSLog(@"=====%@",student.s_name);
[array addObject:student];
}
不过我们在真实的开发环境中最好将一些基本的东西封装一下,最好是采用单例模式来封装。