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);