本篇文章主要介绍了"FMDB的使用"，主要涉及到方面的内容，对于IOS开发感兴趣的同学可以参考一下：
使用数据库个人比较推荐使用FMDB对数据库封装操作，这样简化操作步骤，用起来十分方便。github:https://github.com/ccgus/fmdb创...
使用数据库个人比较推荐使用FMDB对数据库封装操作，这样简化操作步骤，用起来十分方便。github:https://github.com/ccgus/fmdb创建表FMDatabase*db = [FMDatabasedatabaseWithPath:[NSHomeDirectory()stringByAppendingString:@"/tem.db"]];
打开数据库
if([dbopen]) {创建表语句 NSString*sqlCreateTable = [NSStringstringWithFormat:@"CREATE TABLE IF NOT EXISTS '%@' ('%@'
INTEGER PRIMARY KEY AUTOINCREMENT, '%@' TEXT, '%@' INTEGER, '%@' TEXT)",@"user",@"ID",@"NAME",@"AGE",@"ADDRESS"];执行SQL语句 BOOLisOK = [dbexecuteUpdate:sqlCreateTable];
if(isOK) {
NSLog(@"create ok!");
}else{
NSLog(@"not ok!"); }关闭数据库 [dbclose]; }插入数据 if([dbopen]) {
NSString*insertSql1= [NSStringstringWithFormat:
@"INSERT INTO '%@' ('%@', '%@', '%@') VALUES ('%@', '%d', '%@')",
@"user",@"NAME",@"AGE",@"ADDRESS",@"李四",13,@"济南"];
BOOLisinsert = [dbexecuteUpdate:insertSql1];
if(isinsert) {
NSLog(@"插入成功！");
}else{
NSLog(@"插入失败！");
}
[dbclose]; }修改数据if([dbopen]) {
NSString*updateSql = [NSStringstringWithFormat:
@"UPDATE %@ SET %@ = '%@' WHERE %@ = '%@'",
@"user",@"AGE",@130,@"ID",@"1"];
BOOLisupdate = [dbexecuteUpdate:updateSql];
if(isupdate) {
NSLog(@"修改成功！");
}else{
NSLog(@"修改失败！");
}
[dbclose]; }删除数据if([dbopen]){
NSString*deleteSql = [NSStringstringWithFormat:
@"delete from %@ where %@ = '%@'",
@"user",@"ID",@"3"];
BOOLres = [dbexecuteUpdate:deleteSql];
if(res) {
NSLog(@"删除成功！");
}else{
NSLog(@"删除失败！");
}
[dbclose]; }查看数据库if([dbopen]) {
NSString* sql = [NSStringstringWithFormat:
@"SELECT * FROM %@",@"user"];执行查询语句 FMResultSet* rs = [dbexecuteQuery:sql];判断时候有下一个 while([rsnext]) { 取数据按照给定的列的名字
intId = [rsintForColumn:@"ID"];
NSString* name = [rsstringForColumn:@"NAME"];
NSString* age = [rsstringForColumn:@"AGE"];
NSString* address = [rsstringForColumn:@"ADDRESS"];
NSLog(@"id = %d, name = %@, age = %@ address = %@", Id, name, age, address);
}
[dbclose]; }
以上就介绍了FMDB的使用，包括了方面的内容，希望对IOS开发有兴趣的朋友有所帮助。
本文网址链接：http://www.codes51.com/article/detail_139531.html
