SQLite reads the database contents

1. Open an existing database.

Open Database

-(BOOL ) opendb

{// Red Section modified to its own database path

return (sqlite_ok = = Sqlite3_open([@ "/users/apple/ Desktop/text/black/black/province_city_zone.db" utf8string], &db));

}

2. Use the Select field from the table string sql to get the table and use it.

　　

SQLITE_OK = = sqlite3_prepare_v2(db, SQL. Utf8string,-1, &stmt, NULL

Then use

while (sqlite_row = = sqlite3_step(stmt)) {

(index = = 0) {

Const unsigned char *name = sqlite3_column_text(stmt, 0);

int ids = sqlite3_column_int(stmt, 1);

int sort = sqlite3_column_int(stmt, 2);

Get the data and save it.

}

Compare the image. Today, we mainly read the data from a well-written database (with information about the provinces and cities).

SQLite reads the database contents