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=sq......
阅读全文