IOS Sqlite使用者介面增刪改查案例

IOS Sqlite使用者介面增刪改查案例
1.案例簡介對SQLite操作進行了簡單的封裝，將對資料表操作轉變成對對象的操作，並通過UI介面完成對使用者表的增、刪、改、查，運行介面如所示a
2.項目工程目錄

UserModel類為使用者物件模型，與資料庫表中欄位一一對應BaseDB類為對sqlite簡單封裝，抽象出對資料庫操作的三個方法，具體內容看http://blog.csdn.net/whzhaochao/article/details/38865535博文UserDB繼承於BaseDB，主要是完成UserModel對象的增、刪、改、查，其內容如下UserDB.h

////  UserDB.h//  SqliteDemo////  Created by 趙超 on 14-8-27.//  Copyright (c) 2014年 趙超. All rights reserved.//#import "BaseDB.h"#import "UserModel.h"@interface UserDB : BaseDB{    }//單例+(id)shareUserDB;//建立User表-(void)creatTableWithDataBaseName:(NSString*) dbName;//增加一個UserModel-(BOOL)addUser:(UserModel*)userModel dbName:(NSString*)dbName;//修改一個UserModel-(BOOL)updateUser:(UserModel*)userModel dbName:(NSString*)dbName;//查詢所有-(NSArray*)findAllUser:(NSString*)dbName;//刪除一個對象-(BOOL) deleteUser:(UserModel*)userModel dbName:(NSString*)dbName;@end

UserDB.m

////  UserDB.m//  SqliteDemo////  Created by 趙超 on 14-8-27.//  Copyright (c) 2014年 趙超. All rights reserved.//#import "UserDB.h"@implementation UserDBstatic UserDB * db;+(id) shareUserDB{    if (db==nil) {        db= [[UserDB alloc] init];    }    return  db;}-(void)creatTableWithDataBaseName:(NSString*) dbName{    NSString *sql=@"create table user( userName text primary key,passWord text, userEmail text)";    [self createTable:sql dataBaseName:dbName];    }-(BOOL) deleteUser:(UserModel*)userModel dbName:(NSString*)dbName{        NSString *sql=@"delete from user where userName =?";        NSArray *params=@[ userModel.userName];     return  [self execSql:sql parmas:params dataBaseName:dbName];}-(BOOL)addUser:(UserModel *)userModel dbName:(NSString *)dbName{    NSString *sql=@"insert into user (userName,passWord,userEmail) values (?,?,?)";    NSArray *params=@[userModel.userName,userModel.passWord,userModel.userEmail];    return  [self execSql:sql parmas:params dataBaseName:dbName];}-(NSArray*) findAllUser:(NSString *)dbName{    NSString *sql=@"select userName,passWord,userEmail from user";    NSArray *result= [self selectSql:sql parmas:nil dataBaseName:dbName];    NSMutableArray *users=[NSMutableArray array];    for (NSDictionary *dic in result) {        UserModel *user=[[UserModel alloc] init];        user.userName=[dic objectForKey:@"userName"];        user.passWord=[dic objectForKey:@"passWord"];        user.userEmail=[dic objectForKey:@"userEmail"];        [users addObject:user];    }        return users;    }-(BOOL)updateUser:(UserModel *)userModel dbName:(NSString *)dbName{    NSString *sql=@"update user set userName=?,passWord=?,userEmail=? where userName=?";    NSArray *params=@[userModel.userName,userModel.passWord,userModel.userEmail,userModel.userName];        return [self execSql:sql parmas:params dataBaseName:dbName];    }@end

MainViewController是使用者顯示所有使用者列表AddViewController用於增加和修改使用者介面的顯示完整項目代碼下載http://download.csdn.net/detail/whzhaochao/7829829