C++使用SQLite实例

#include "SQLite.h" static int UserResult(void *NotUsed, int argc, char **argv, char **azColName) { for(int i = 0 ; i < argc ; i++) { cout<<azColName[i]<<" = "<<(argv[i] ? argv[i] : "NULL")<<", "; } cout<<endl; return 0; } SQLite::SQLite(void) { } SQLite::~SQLite(void) { } bool SQLite::CreatDB(const char* BDpath) { int nRes = sqlite3_open(BDpath, &pDB); if (nRes==SQLITE_OK) // Successful result { return true; } return false; } bool SQLite::CreatTable(const char* tablename ,const string columnane[],int count) { string tablenamestr(tablename); string strSql =""; strSql += "create table "; strSql += tablenamestr; strSql += "("; for(int i=0;i<count;i++) { string name(columnane[i]); if (i!=0) { strSql+=","; } strSql += name; } strSql += ")"; char* cErrMsg; int nRes = sqlite3_exec(pDB , strSql.c_str() ,0 ,0, &cErrMsg); if (nRes != SQLITE_OK) { cout<<"add user fail: "<<cErrMsg<<endl; return false; } return true; } //增加用户 bool SQLite::AddUser(const string& sName, const string& sAge) { string strSql = ""; strSql += "insert into user(name,age)"; strSql += "values('"; strSql += sName; strSql += "',"; strSql += sAge; strSql += ");"; char* cErrMsg; int nRes = sqlite3_exec(pDB , strSql.c_str() ,0 ,0, &cErrMsg); if (nRes != SQLITE_OK) { cout<<"add user fail: "<<cErrMsg<<endl; return false; } else { cout<<"add user success: "<<sName.c_str()<<"\t"<<sAge.c_str()<<endl; } return true; } //删除用户 bool SQLite::DeleteUser(const string& sName) { return true; } //修改用户 bool SQLite::ModifyUser(const string& sName, const string& sAge) { return true; } //查找用户 bool SQLite::SelectUser() { char* cErrMsg; int res = sqlite3_exec(pDB, "select * from user;", UserResult , 0 , &cErrMsg); if (res != SQLITE_OK) { cout<<"select fail: "<<cErrMsg<<endl; return false; } return true; }