1.案例简单介绍
![](https://img-my.csdn.net/uploads/201408/27/1409142204_6255.gif)
2.项目project文件夹
//
// 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 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