IOS Sqlite用户界面增删改查案例

妖狐艹你老母 2022-08-11 13:30 160阅读 0赞

### 1.案例简介 ###

对SQLite操作进行了简单的封装，将对数据表操作转变成对对象的操作，并通过UI界面完成对用户表的增、删、改、查，运行界面如下图所示

![1409142204_6255.gif][]a

### 2.项目工程目录 ###

![Center][]

UserModel类为用户对象模型，与数据库表中字段一一对应

BaseDB类为对sqlite简单封装，抽象出对数据库操作的三个方法，具体内容看 [http://blog.csdn.net/whzhaochao/article/details/38865535][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 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][http_download.csdn.net_detail_whzhaochao_7829829]

[1409142204_6255.gif]: https://img-my.csdn.net/uploads/201408/27/1409142204_6255.gif
[Center]: /images/20220810/8ac661d60f38477e87af90c6e0258d3c.png
[http_blog.csdn.net_whzhaochao_article_details_38865535]: http://blog.csdn.net/whzhaochao/article/details/38865535
[http_download.csdn.net_detail_whzhaochao_7829829]: http://download.csdn.net/detail/whzhaochao/7829829