市区级联下拉菜单

市区级联下拉框  还不是很完美 但是凑合用了。

主要是查询数据库，fmdb这个开源库很好用啊

#import "GetdataFromDBTool.h"

#import "FMDB.h"

@implementation GetdataFromDBTool

+(NSMutableArray*)getArrayByString:(NSString*)str{

    NSMutableArray *array=[NSMutableArraynew];

    NSString *dbpath = [[NSBundlemainBundle]

                        pathForResource:@"area"

                        ofType:@"db"];

    FMDatabase *db = [FMDatabasedatabaseWithPath:dbpath];

    if (![dbopen]) {

        returnnil;

    }

    longlong parentcode = 0;

     NSString* sql=[NSStringstringWithFormat:@"SELECT * FROM tn_Areas where Name='%@'and Depth=2",str];

    FMResultSet *s1 = [dbexecuteQuery:sql];

    while ([s1next]) {

        //retrieve values for each record

        NSLog(@"db...%@",s1);

        parentcode=[s1 longLongIntForColumn:@"AreaCode"];

    

    }

    NSString* sql1=[NSStringstringWithFormat:@"SELECT * FROM tn_Areas where ParentCode=%@ and Depth=3",[[NSNumbernumberWithLongLong:parentcode] stringValue]];

    FMResultSet *s = [dbexecuteQuery:sql1];

    while ([snext]) {

                NSLog(@"db...%@",s);

        NSString* name=[sstringForColumn:@"Name"];

        [array addObject:name];

        

    }

    

    return array;

}

+(longlong)getAreaCodeByString:(NSString*)str{

    NSString *dbpath = [[NSBundlemainBundle]

                        pathForResource:@"area"

                        ofType:@"db"];

    FMDatabase *db = [FMDatabasedatabaseWithPath:dbpath];

    if (![dbopen]) {

        return0;

    }

    longlong areaCode = 0;

    NSString* sql=[NSStringstringWithFormat:@"SELECT * FROM tn_Areas where Name='%@'and Depth=3",str];

    FMResultSet *s1 = [dbexecuteQuery:sql];

    while ([s1next]) {

        //retrieve values for each record

        NSLog(@"db...%@",s1);

        areaCode=[s1 longLongIntForColumn:@"AreaCode"];

        

    }

    

    return areaCode;

}