首页 > 代码库 > 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; @endUserDB.m
// // UserDB.m // SqliteDemo // // Created by 赵超 on 14-8-27. // Copyright (c) 2014年 赵超. All rights reserved. // #import "UserDB.h" @implementation UserDB static 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
IOS Sqlite用户界面增删改查案例
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。