導入第三方：libsqlite3.tbd

gitHub

設置：-fno-objc-arc

設置路徑：進入沙河

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

    //拼接路徑

    NSString *path=[home stringByAppendingPathComponent:@"student.db"];

pragma mark --fmdb打開操作

   FMDatabase *fmdb=[[FMDatabase alloc]initWithPath:path];

    if ([_fmdb open]) {

        NSLog(@"打開成功");

    }else{

        NSLog(@"打開失敗”);

pragma mark -- fmdb 具體操作 增 刪 改 建表

    NSString *deleteSql2=@"delete from t_student where age = ?";

    [_fmdb executeUpdate:deleteSql2,@43];

pragma mark --FMDB 查詢

    //相當于直接返回一個句柄

    FMResultSet *resultSet=[_fmdb executeQuery:selectSql];

    //句柄不夠

    while ([resultSet next]) {

        int ID=[resultSet intForColumn:@"ID"];

        NSString *name=[resultSet stringForColumn:@"name"];

        int age=[resultSet intForColumn:@"age"];

        NSLog(@"ID  = %d ,name = %@, age = %d",ID,name,age);

    }

    //關(guān)閉句柄

    [resultSet close];

    }