項(xiàng)目中需要獲取所有城市
先找到一個(gè)db文件搀菩，可以去網(wǎng)上搜一個(gè)db文件呕臂，下載地址http://download.csdn.net/detail/u010827511/5446157
使用了FMDB第三方
需要添加庫(kù)文件 targets——>Build Phases——>Link Binary With Libraries
+libsqlites.tbd
#pragma mark ---- 獲取城市信息
- (void)loadAddress {
NSString *str = [[NSBundle mainBundle] resourcePath];
NSString *databasePath = [str stringByAppendingPathComponent:@"address.db"];
NSMutableArray *address = [[NSMutableArray alloc] initWithCapacity:35];
FMDatabase *fmdb = [FMDatabase databaseWithPath:databasePath];
[fmdb open];
NSString *sql = [NSString stringWithFormat:@"SELECT * FROM tbl_helper_locations WHERE parent_id = 0"];
FMResultSet *rs = [fmdb executeQuery:sql];
while ([rs next]) {
NSString *addressName = [rs stringForColumn:@"name"];
NSMutableArray *atomicArr = [[NSMutableArray alloc] init];
NSString *atomicId = [rs stringForColumn:@"id"];
NSString *sqlStr = [NSString stringWithFormat:@"SELECT * FROM tbl_helper_locations WHERE parent_id = %@", atomicId];
FMResultSet *resultSet = [fmdb executeQuery:sqlStr];
while ([resultSet next]) {
NSString *atomicStr = [resultSet stringForColumn:@"name"];
[atomicArr addObject:atomicStr];
}
if (atomicArr.count) {
[address addObject:@{addressName: atomicArr}];
}
}
// 得到所有省市的數(shù)組
_address = address.mutableCopy;
}
