vs2013 SQLite数据库增删改查

代码：Database2.7z

Database.h:

#pragma once

#include<string>
#include<vector>
#include<Windows.h>
#include<tchar.h>
#include<iostream>

#include"sqlite3.h"

using namespace std;

class Database{
public:
    Database();
    ~Database();
    bool initDatabase();//打开数据库，成功返回true
    bool createTable(std::string tablename);//在数据库中创建一个表
    void showData();//输出数据库中的数据
    bool insertDatabase(string tablename, string name, string number);
    bool queryDatabase(string tableName);
    void dropTable(string tableName);
    void deleteData(string tableName);
    void changeData(string tableName);

private:
    sqlite3* db;
    sqlite3_stmt* stmt;
};

static int callback(void* data, int argc, char** argv, char** azColName);

Database.cpp:

#pragma once

#include"Database.h"

vector<string> vstr;
vector<string> vnumber;

static int callback(void* data, int argc, char** argv, char** azColName){
    for (int i = 0; i < argc; i++){
        switch (i + 1){
        case 0:
            break;//id已弃用
        case 1:
            vstr.push_back(string(argv[i])); break;
        case 2:
            vnumber.push_back(string(argv[i])); break;
        default:
            break;
        }
    }
    return 0;
}

Database::Database(){

}

Database::~Database(){

}

bool Database::initDatabase(){
    int rc = sqlite3_open("TestDB.db", &db);
    if (rc){
        MessageBox(NULL, _T("数据库打开失败！"), 0, 0);
        return false;
    }
    return true;
}

bool Database::createTable(std::string tablename){
    string sql = "CREATE TABLE TEST ( "    
        "NAME TEXT NOT NULL,"    
        "NUMBER TEXT NOT NULL)";
    char* zErrMsg = 0;
    int rc = sqlite3_exec(db, sql.c_str(), callback, 0, &zErrMsg);
    if (rc != SQLITE_OK){
        return false;
    }
    return true;
}

void Database::showData(){
    if (vstr.size() == 0){
        cout << "数据库中没有数据！
";
        return;
    }
    for (vector<string>::iterator i = vstr.begin(); i != vstr.end(); i++){
        cout << i->data() << "  ";
    }
    cout << "
";
    for (int i = 0; i < vnumber.size(); i++){
      cout << vnumber[i] << "  ";
    }
    cout << "
";
}

bool Database::insertDatabase(string tablename, string name, string number){
    string sql = "INSERT INTO " +
        tablename +
        " ( NAME, NUMBER)" +
        " VALUES('" +
        name +
        "','" +
        number +
        "');";
    char* zErrMsg = 0;
    int rc = sqlite3_exec(db, sql.c_str(), callback, 0, &zErrMsg);
    if (rc != SQLITE_OK){
        MessageBox(NULL, sql.c_str(), NULL, NULL);
        return false;
    }
    return true;
}

bool Database::queryDatabase(string tableName){
    string sql = "SELECT * FROM ";
    sql += tableName;
    char* zErrMsg = 0;
    int rc = sqlite3_exec(db, sql.c_str(), callback, 0, &zErrMsg);
    return true;
}

void Database::dropTable(string tableName){
    string sql = "DROP TABLE ";
    sql += tableName;
    char* zErrMsg = 0;
    int rc = sqlite3_exec(db, sql.c_str(), callback, 0, &zErrMsg);
}

void Database::deleteData(string tableName){
    string sql = "DELETE FROM ";
    sql += tableName;
    char* zErrMsg = 0;
    int rc = sqlite3_exec(db, sql.c_str(), callback, 0, &zErrMsg);
}

void Database::changeData(string tableName){
    string sql = "UPDATE  TEST SET NAME = 'MYTEST'";
        char* zErrMsg = 0;
    int rc = sqlite3_exec(db, sql.c_str(), callback, 0, &zErrMsg);
}

main.cpp:

#include"Database.h"

int main(){
    Database* db = new Database;
    db->initDatabase();
    db->createTable("");
    db->insertDatabase("TEST", "test", "1");
    db->changeData("vv");
    db->queryDatabase("TEST");
    db->showData();
    db->deleteData("TEST");
    db->dropTable("TEST");
    delete db;
    system("pause");
    return 0;
}