![]() ~Database~ |
Sqlite wrapped: a C++ wrapper for the Sqlite database C API[ About | Download | Examples | Diagram | Tutorial | License (GPL) ]Examples#include <stdio.h> #include <stdlib.h> #include <sqlite3.h> #include <string> #include "Database.h" #include "Query.h" int main() { Database db( "database_file.db" ); Query q(db); q.execute("delete from user"); q.execute("insert into user values(1,'First Person')"); q.execute("insert into user values(2,'Another Person')"); q.get_result("select num,name from user"); while (q.fetch_row()) { long num = q.getval(); std::string name = q.getstr(); printf("User#%ld: %s\n", num, name.c_str() ); } q.free_result(); } |