利用Sqlite 的知识在数据库中建立表，并向表中添加数据。

IOS中数据持久化的方法之一就是利用数据库来实现了，而且使用起来很便捷，尤其是当程序中需要对数据进行筛选查询的时候使用起来尤其的方便。下面我就为大家分享一个程序就是利用数据库知识在数据库中新建一个学生信息表。，首先在Xcode5里面新建一个单视图工程，然后快速拖拽控件，并进行必要的关联。

如下图所示：

另外还要给大家分享一个数据库管理工具sqlite manager

下载地址

另外还要在工程中导入框架，如下图所示：

白色的那个。

具体的代码如下：

HHLAppDelegate.h和HHLAppDelegate.m没有做任何变化

HHLViewVController.h

#import <UIKit/UIKit.h>
#import <sqlite3.h>
@interface HHLViewController : UIViewController

{
    sqlite3 *_dataBase;
}

@property (strong,nonatomic) IBOutlet UITextField *nameField;
@property (strong,nonatomic) IBOutlet UITextField *ageField;
@property (strong,nonatomic) IBOutlet UITextField *adField;
@property (strong,nonatomic) IBOutlet UITextField *sexField;
@property (strong,nonatomic) IBOutlet UITextView *myTextView;

- (IBAction)saveBtn:(id)sender;

- (IBAction)readBtn:(id)sender;
//接口说明
//返回值：数据库创建是否成功
//
- (BOOL)initDatabase:(NSString *)dbName;
//创建表
- (BOOL) createChannelsTable;
//接口说明：
//返回值：插入数据是否成功
- (BOOL)insertOneChannel:(NSString *)name
                    cage:(int)age
                caddress:(NSString *)addr
                    csex:(NSString *)sex;//接口说明：
//返回值：可变数组（数组内存放多个字典，每个字典存储表中一行的数据）
- (NSMutableArray *)getAllDatas;
@end

HHLViewController.m

#import "HHLViewController.h"

@interface HHLViewController ()

@end

@implementation HHLViewController

- (void)viewDidLoad
{
    [super viewDidLoad];
	// Do any additional setup after loading the view,typically from a nib.
    [self initDatabase:@"hanhailong.db"];
    self.myTextView.editable = NO;
}

- (void)didReceiveMemoryWarning
{
    [super didReceiveMemoryWarning];
    // Dispose of any resources that can be recreated.
}




- (IBAction)saveBtn:(id)sender {
    
    NSString *pName = self.nameField.text;
    NSInteger nAge = [self.ageField.text intValue];
    NSString *pAddr = self.adField.text;
    NSString *pSex = self.sexField.text;
    //插入数据
    [self insertOneChannel:pName cage:nAge  caddress:pAddr csex:pSex];
    self.nameField.text = @"";
    self.ageField.text = @"";
    self.adField.text = @"";
    self.sexField.text = @"";
    
    
}

- (IBAction)readBtn:(id)sender {
    NSMutableString *pResultStr = [NSMutableString string];
    NSMutableArray *pArr = [self getAllDatas];
    
    for (int i = 0; i < [pArr count]; i++) {
        //每一行对应的字典
        NSMutableDictionary *pTempDic = [pArr objectAtIndex:i];
        [pResultStr appendFormat:@"%@",[pTempDic objectForKey:@"name"]];
        [pResultStr appendString:@"t"];
        [pResultStr appendFormat:@"%@",[NSString stringWithFormat:@"%@",[pTempDic objectForKey:@"age"]]];
        [pResultStr appendString:@"t"];
        [pResultStr appendFormat:@"%@",[pTempDic objectForKey:@"add"]];
        [pResultStr appendString:@"t"];
        [pResultStr appendFormat:@"%@",[pTempDic objectForKey:@"sex"]];
        [pResultStr appendString:@"n"];
        
    }
    self.myTextView.text = pResultStr;
}

- (BOOL)initDatabase:(NSString *)dbName
{
    

    NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,NSUserDomainMask,YES);
    NSString *filePath = [paths objectAtIndex:0];
    NSLog(@"%@",filePath);
    NSString *path = [filePath stringByAppendingPathComponent:dbName];
    
    if (sqlite3_open([path UTF8String],&_dataBase) != SQLITE_OK) {
        NSAssert(NO,@"打开数据库失败");
        return NO;
    }
    else{
        NSLog(@"打开数据库成功");
        //创建表
        //
        [self createChannelsTable];
        return YES;
    }
}

- (BOOL)createChannelsTable
{
char *sql = "CREATE TABLE  IF NOT EXISTS member(id integer  primary key autoincrement,name text,age integer,addr text,sex text)";
    sqlite3_stmt *stmt;
    if(sqlite3_prepare_v2(_dataBase,sql,-1,&stmt,nil)!=SQLITE_OK)
    {
        NSLog(@"编译失败");
        return NO;
        
    }
    
        NSLog(@"创建表的sql语句执行成功");
    int success = sqlite3_step(stmt);
    if (success != SQLITE_DONE) {
        NSLog(@"创建表失败");
        
        return NO;
    }
    
    NSLog(@"创建成功");
    return YES;
    
}

- (BOOL)insertOneChannel:(NSString *)name
                    cage:(int)age
                caddress:(NSString *)addr
                    csex:(NSString *)sex

{
    sqlite3_stmt *stmt;
    //插入数据sql语句
char *sql = "INSERT INTO member(name,age,addr,sex) VALUES(?,?,?)";
    int success = sqlite3_prepare_v2(_dataBase,nil);
    if (success != SQLITE_OK) {
        NSLog(@"插入数据的SQL语句编译失败");
        return NO;
    }
    NSLog(@"插入数据的SQL语句编译成功");
    //
    sqlite3_bind_text(stmt,1,[name UTF8String],nil);
    sqlite3_bind_int(stmt,2,age);
    sqlite3_bind_text(stmt,3,[addr UTF8String],nil);
    sqlite3_bind_text(stmt,4,[sex UTF8String],nil);
    //执行sql语句
    success = sqlite3_step(stmt);
    //释放句柄
    sqlite3_finalize(stmt);
    
    if (success == SQLITE_ERROR) {
        NSLog(@"数据加载失败");
        return NO;
    }
    NSLog(@"插入数据成功");
    return YES;
}

    
- (NSMutableArray *)getAllDatas
{
//可变数组，存放表种数据
    NSMutableArray *allDatas = [[[NSMutableArray alloc]init]autorelease];
    sqlite3_stmt *stmt= nil;
    char *sql = "SELECT *FROM member";
    if (sqlite3_prepare_v2(_dataBase,nil) !=SQLITE_OK) {
        NSLog(@"读取表中数据SQL语句编译失败");
        return nil;
    }
        NSLog(@"读取表中数据sql语句编译成功");
        while (sqlite3_step(stmt) == SQLITE_ROW)
        {
            NSMutableDictionary *pTempDic = [[NSMutableDictionary alloc]init];
            //获取第一列数据
            char *pName = (char *)sqlite3_column_text(stmt,1);
            //容错保护,如果获取到的数据为空,就不添加到字典中
            if (pName)
            {
                [pTempDic setObject:[NSString stringWithUTF8String:pName] forKey:@"name"];
            }
            //获取第二列数据
            NSInteger nAge = (int)sqlite3_column_int(stmt,2);
            if (nAge)
            {
                [pTempDic setObject:[NSNumber numberWithInt:nAge] forKey:@"age"];
            }
            //第三列数据
            char *pAddr = (char *)sqlite3_column_text(stmt,3);
            if (pAddr)
            {
                [pTempDic setObject:[NSString stringWithUTF8String:pAddr] forKey:@"add"];
            }
            //第四列数据
            char *pSex = (char *)sqlite3_column_text(stmt,4);
            if (pSex)
            {
                [pTempDic setObject:[NSString stringWithUTF8String:pSex] forKey:@"sex"];
            }
            //将存放每行数据的字典加入到数组中
            [allDatas addObject:pTempDic];
            [pTempDic release];
        }
        sqlite3_finalize(stmt);
        return allDatas;
        }
        
        //弹回键盘的方法
        - (void)touchesBegan:(NSSet *)touches withEvent:(UIEvent *)event
    {
        [self.view endEditing:YES];
    }
        


@end

这里只是简单的和大家分享一下，当然了大家如果想掌握牢固的话还要数据库的知识学习好。才可以的哦

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!