iOS 学习笔记17-FMDB 应用

先引入

建立一个数据库

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

    NSLog(@"%@",path);

    

    NSString *databasePath = [path stringByAppendingString:@"/DSN.sqlite"];

    

    

    /**

     *建立一个FMDB的数据库

     **/

    FMDatabase *db = [[FMDatabase alloc]initWithPath:databasePath];

    [db open];

 

 

//    /**

//     *创建表

//     **/

//    NSString *createTable = @"create table Student(id integer primary key autoincrement,name text,password text)";

//    [db executeUpdate:createTable];

 

 

 /**

     * 插入数据

     **/

    NSString *insertSql = @"insert into Student(name,password) values('dsn','123456')";

    BOOL b  = [db executeUpdate:insertSql];

    if (b) {

        NSLog(@"添加成功");

    }else{

        NSLog(@"添加失败");

    }

 

 

 

 /**

     *有参数, 有返回值，查找

     **/

    FMResultSet *set = [db executeQuery:@"select * from Student where name >?",@"dsn"];

    if (!set) {

        NSLog(@"查询失败");

    }else{

    while ([set next]) {

        int id = [set intForColumnIndex:0];

        NSString *name = [set stringForColumnIndex:1];

        NSString *password = [set stringForColumnIndex:2];

        NSLog(@"%d,  %@  ,%@",id,name,password);

    }

}

 

//    /**

//     *有参数，添加

//     **/

//    

//    for (int i = 0; i<5; i++) {

//        NSString *name = [NSString stringWithFormat:@"dsn%d",i+1];

//        NSString *password = [NSString stringWithFormat:@"%06d",arc4random()%100000];

//        

//       [db executeUpdate:@"insert into Student(name,password) values(?,?)",name,password];

//    }

//

 

 

 

 

  /**

//     *查询

//     **/

//    

//    NSString *selectSql = @"select * from Student";

//    FMResultSet *set = [db executeQuery:selectSql];

//    NSLog(@"%@",set);

//    while ([set next]) {

//        int stuId = [set intForColumnIndex:0];

//        NSString *stuName = [set stringForColumnIndex:1];

//        NSString *stuPass = [set stringForColumnIndex:2];

//        NSLog(@"stuId = %d,name = %@,pass =%@",stuId,stuName,stuPass);

//    }