#include <sqlite3.h>
1 2 3 4 5 6 7 8 9 10 11 12 | // This is the callback function to display the select data in the table static int callback(void *NotUsed, int argc, char **argv, char **szColName) { for(int i = 0; i < argc; i++) { std::cout << szColName[i] << " = " << argv[i] << std::endl; } std::cout << "\n"; return 0; } |
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 | int main() { sqlite3 *db; char *szErrMsg = 0; // open database int rc = sqlite3_open("askyb.db", &db); if(rc) { std::cout << "Can't open database\n"; } else { std::cout << "Open database successfully\n"; } // prepare our sql statements const char *pSQL[6]; pSQL[0] = "CREATE TABLE Employee(Firstname varchar(30), Lastname varchar(30), Age smallint)"; pSQL[1] = "INSERT INTO Employee(Firstname, Lastname, Age) VALUES ('Woody', 'Alan', 45)"; pSQL[2] = "INSERT INTO Employee(Firstname, Lastname, Age) VALUES ('Micheal', 'Bay', 38)"; pSQL[3] = "SELECT * FROM Employee"; // execute sql for(int i = 0; i < 4; i++) { rc = sqlite3_exec(db, pSQL[i], callback, 0, &szErrMsg); if(rc != SQLITE_OK) { std::cout << "SQL Error: " << szErrMsg << std::endl; sqlite3_free(szErrMsg); break; } } // close database if(db) { sqlite3_close(db); } return 0; } |
$ g++ SqliteSample.cpp -l sqlite3 -o SqliteSample


C++ SQLite Example in Linux