sqlite3_demo

//记得先导入第三方类 sqlite3

#import <UIKit/UIKit.h>

#import <sqlite3.h>

@interface ViewController : UIViewController

{

    sqlite3 *_dataBase;

}

@property (retain, nonatomic) IBOutlet UITextView *textView;

@property (retain, nonatomic) IBOutlet UITextField *textFieldName;

@property (retain, nonatomic) IBOutlet UITextField *textFieldAge;

@property (retain, nonatomic) IBOutlet UITextField *textFieldSex;

@property (retain, nonatomic) IBOutlet UITextField *textFieldiID;

- (IBAction)saveButton:(id)sender;

- (IBAction)getButton:(id)sender;

- (BOOL)initDataBase:(NSString *)dbName;

- (BOOL)creatChannelsTable;

- (BOOL) insertOneChannel:(NSString *)name

                    cAge:(NSInteger )age

                 caddress:(NSString *)addr

                     cSex:(NSString *)sex;

//返回值 可变数组 （数组内存放多个字典 每个字典存储表中的一行的数据）

- (NSMutableArray *)getAlldata;

@end

#import "ViewController.h"

@interface ViewController ()

@end

@implementation ViewController

- (void)viewDidLoad

{

    [super viewDidLoad];

    //调用函数

    [self initDataBase:@"member.db"];

}

- (IBAction)saveButton:(id)sender

{