if (sqlite3_open([[[[NSBundle mainBundle] pathForResource:@"wxs" ofType:@"db"] retain] fileSystemRepresentation], &database)==SQLITE_OK) { NSLog(@"open sqlite db ok."); } /// const char *selectSql="select * from t1"; sqlite3_stmt *statement; if (sqlite3_prepare_v2(database, selectSql, -1, &statement, nil)==SQLITE_OK) { NSLog(@"select ok."); } while (sqlite3_step(statement)==SQLITE_ROW) { int _lat=sqlite3_column_int(statement, 0); int _lng=sqlite3_column_int(statement, 1); NSLog(@"lat %i, lng %i",_lat,_lng); } sqlite3_finalize(statement);