1,导入第三方头文件

#import "FMDB.h"

//定义全局变量

@implementation InputInformationViewController

{

    UITextField *_accountField;//帐号输入框

    UITextField *_passwordsField;//密码输入框

    FMDatabase *db;//数据库

}

 

//获取数据库

            NSString *doc = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask , YES) lastObject];

            NSLog(@"%@",doc);

            NSString *fileName = [doc stringByAppendingPathComponent:@"information.sqlite"];

            //获取数据库

            db = [FMDatabase databaseWithPath:fileName];

            if ([db open]) {

                //创表

                BOOL result = [db executeUpdate:@"CREATE TABLE IF NOT EXISTS M_Information (id integer PRIMARY KEY AUTOINCREMENT, account NOT NULL,passwords text NOT NULL);"];

                if (result) {

                    NSLog(@"创表成功");

                }else{

                    NSLog(@"创表失败");

                }

            }

            

            //获取数据

            NSString *account = _accountField.text;

            NSString *passwords = _passwordsField.text;

            if([db executeUpdate:@"INSERT INTO M_Information(account,passwords) VALUES(?,?);",account,passwords]){

                NSLog(@"111");

            };

            //[db executeQueryWithFormat:@"INSERT INTO M_Information(account,passwords)VALUES(%@,%@);",account,passwords];

            [self query];//执行查询语句

 

//查询语句函数

   ViewController *VC = [[ViewController alloc]init];

    VC.dataArray = [[NSMutableArray alloc]init];

    //执行查询语句

    FMResultSet *resultSet = [db executeQuery:@"SELECT * FROM M_Information"];

   //遍历结果集

    while ([resultSet next]) {

        //传递数据库中的数据

        InformationModel *model = [[InformationModel alloc]init];

        model.myAccount = [resultSet stringForColumn:@"account"];

        model.myPasswords = [resultSet stringForColumn:@"passwords"];

        [VC.dataArray addObject:model];

    }