第三方数据库FMDB用法

需要导入fmdb
//获取文件路径
NSString
*doc=[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject];
NSString *fileName=[doc stringByAppendingPathComponent:@"student.sqlite"];
//获取数据库
FMDatabase *db=[FMDatabase databaseWithPath:fileName];
if ([db open]) {
BOOL result=[db executeUpdate:@"create table if not exists student (id integer primary key autoincrement,name varchar(20),pwd varchar(20))"];
if (result) {
NSLog(@"创建表成功");
}else
{ NSLog(@"创建表失败");
}
}
self.db=db;
}
-(void)touchesBegan:(NSSet<UITouch *> *)touches withEvent:(UIEvent *)event
{
添加信息
[self insert];
查询
[self query];
删除
[self delete];
修改
[self update];}
//增加信息
-(void)insert{
for (int i=0; i<10; i++)
{
NSString *name=[NSString stringWithFormat:@"zhang-%d",i]; NSString *pwd=[NSString stringWithFormat:@"%5d",i];
[self.db executeUpdate:@"insert into student(name,pwd) values(?,?);",name,pwd];
}}//查询
-(void)query{
FMResultSet *result=[self.db executeQuery:@"select *from student"]; while ([result next])
{ int a=[result intForColumn:@"id"];
NSString *name=[result stringForColumn:@"name"];
NSString *pwd=[result stringForColumn:@"pwd"];
NSLog(@"%d %@->%@",a,name,pwd);
}}
//删除
-(void)delete{
[self.db executeUpdate:@"delete from student where id=5"];}
//修改
-(void)update
{
[self.db executeUpdate:@"update student set name='过一会' where id=1"];
}