1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
| #include <iostream> #include <string> #include <errno.h> #include <assert.h> #include <sqlite3.h>
static int callback(void*, int nCount, char** pValue, char** pName) { std::string s; for (int i = 0;i < nCount;i++) { s += pName[i]; s += ":"; s += pValue[i]; s += "\n"; } std::cout << s; return 0; }
int main(int argc, char** argv) { std::cout << "sqlite3 version : " << SQLITE_VERSION << std::endl << std::endl;
sqlite3* db; int nResult = sqlite3_open("db_test_case.sqlite3", &db); if (nResult != SQLITE_OK) { std::cout << "open db_test_case.sqlite3 fault:" << sqlite3_errmsg(db) << std::endl; return 1; } else { std::cout << "open db_test_case.sqlite3 success" << std::endl; }
char* errmsg; nResult = sqlite3_exec(db, "CREATE TABLE IF NOT EXISTS ADB(name char(50),code char(100))", NULL, NULL, &errmsg); if (nResult != SQLITE_OK) { sqlite3_close(db); std::cout << "error: code:" << nResult << "|error:" << errmsg << std::endl; sqlite3_free(errmsg); return 2; }
if ((nResult = sqlite3_exec(db, "INSERT INTO ADB VALUES('key1','1111');", NULL, NULL, &errmsg)) != SQLITE_OK || (nResult = sqlite3_exec(db, "INSERT INTO ADB VALUES('key2','2222');", NULL, NULL, &errmsg)) != SQLITE_OK || (nResult = sqlite3_exec(db, "INSERT INTO ADB VALUES('key3','3333');", NULL, NULL, &errmsg)) != SQLITE_OK || (nResult = sqlite3_exec(db, "INSERT INTO ADB VALUES('key4','4444');", NULL, NULL, &errmsg)) != SQLITE_OK || (nResult = sqlite3_exec(db, "INSERT INTO ADB VALUES('key5','5555');", NULL, NULL, &errmsg)) != SQLITE_OK || (nResult = sqlite3_exec(db, "INSERT INTO ADB VALUES('key6','6666');", NULL, NULL, &errmsg)) != SQLITE_OK) { sqlite3_close(db); std::cout << "error: code:" << nResult << "|error:" << errmsg << std::endl; sqlite3_free(errmsg); return 3; }
nResult = sqlite3_exec(db, "SELECT * FROM ADB WHERE name='key5'", callback, NULL, &errmsg); if (nResult != SQLITE_OK) { sqlite3_close(db); std::cout << "error:" << errmsg << std::endl; sqlite3_free(errmsg); return 4; }
sqlite3_close(db); return 0; }
|