开发场景:服务器给了一个db的数据做城市选择...很无奈,但是还是贴出来 处理完成后是个dic 请自己保存为想要的格式。
代码:
//查询数据
-(NSArray *)SelectData
{
NSString *DataBasePath = [[NSBundle mainBundle] pathForResource:@"tpshop2" ofType:@"db"];
sqlite3_open(DataBasePath.UTF8String, &_db);
NSString * string = [NSString stringWithFormat:@"SELECT * FROM sp_address"];
sqlite3_stmt * stmt = NULL;
sqlite3_prepare_v2(_db, string.UTF8String, -1, &stmt, NULL);
NSMutableArray *arr = [NSMutableArray array];
while (sqlite3_step(stmt) == SQLITE_ROW)
{
const char * keyid = (const char *)sqlite3_column_text(stmt, 0);
const char * name = (const char *)sqlite3_column_text(stmt,