c++写的sqlit数据库的实例程序

#include <iostream> #include <string> #include <sstream> #include "sqlite3.h" using namespace std; sqlite3 * pDB; int createTable() { char* errMsg; string dropTab = "drop table test_tab;"; string strSQL= "create table test_tab (f1 int, f2 long);"; //删掉已经存在的table int res= sqlite3_exec(pDB , dropTab.c_str() , 0 , 0 , &errMsg); if (res != SQLITE_OK) { cout << "执行SQL出错." << errMsg << endl; return -1; } //建立一个空table res = sqlite3_exec(pDB , strSQL.c_str() ,0 ,0, &errMsg); if (res != SQLITE_OK) { cout << "执行创建table的SQL出错." << errMsg << endl; return -1; } else { cout << "创建table的SQL成功执行."<< endl; } return 0; } int insert1() { char* errMsg; int res = sqlite3_exec(pDB,"begin transaction;",0,0, &errMsg); for (int i= 1; i < 10; ++i) { stringstream strsql; strsql << "insert into test_tab values("; strsql << i << ","<< (i+10) << ");"; string str = strsql.str(); res = sqlite3_exec(pDB,str.c_str(),0,0, &errMsg); if (res != SQLITE_OK) { cout << "执行SQL出错." << errMsg << endl; return -1; } } res = sqlite3_exec(pDB,"commit transaction;",0,0, &errMsg); cout << "SQL成功执行."<< endl; return 0; } //arg---数据表内的数据行数 //argv---行数据 //azColName---属性名 static int callback(void *NotUsed, int argc, char **argv, char **azColName) { for(int i = 0 ; i < argc ; i++) { //读的是一行数据？ cout << azColName[i] << " = " << (argv[i] ? argv[i] : "NULL") << ", " ; } cout<< "\n"; return 0; } int select1() { char* errMsg; string strSQL= "select * from test_tab;"; int res = sqlite3_exec(pDB, strSQL.c_str(), callback , 0 , &errMsg); if (res != SQLITE_OK) { cout << "执行SQL 出错." << errMsg << endl; return -1; } else { cout << "SQL成功执行."<< endl; } return 0; } int main(int argc, char* argv[]) { int res = sqlite3_open("D:\\sql.db", &pDB); if( res ){ cout << "Can't open database: "<< sqlite3_errmsg(pDB); sqlite3_close(pDB); return -1;//返回-1和0之间有什么区别吗？ } res = createTable(); if (res != 0) { return 0; } res = insert1(); if (res != 0) { return 0; } select1(); getchar(); return 0; }