c++ SQLite 特别好用的库使用实例-创建数据库（1）

创建数据库：

void _CreateDB()
{
    //创建数据库
    Kompex::SQLiteDatabase *pDatabase = new Kompex::SQLiteDatabase("test.db", SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, 0);
    Kompex::SQLiteStatement *pStmt = new Kompex::SQLiteStatement(pDatabase);
    int nNumber = pDatabase->GetLibVersionNumber();

    {
        pStmt->SqlStatement("CREATE TABLE user (userID INTEGER NOT NULL PRIMARY KEY, lastName VARCHAR(50) NOT NULL, firstName VARCHAR(50), age INTEGER, weight DOUBLE)");
        pStmt->SqlStatement("INSERT INTO user (userID, lastName, firstName, age, weight) VALUES (1, 'Lehmann', 'Jamie', 20, 65.5)");
        pStmt->SqlStatement("INSERT INTO user (userID, lastName, firstName, age, weight) VALUES (2, 'Burgdorf', 'Peter', 55, NULL)");
        pStmt->SqlStatement("INSERT INTO user (userID, lastName, firstName, age, weight) VALUES (3, 'Lehmann', 'Fernando', 18, 70.2)");
        pStmt->SqlStatement("INSERT INTO user (userID, lastName, firstName, age, weight) VALUES (4, 'Lehmann', 'Carlene ', 17, 50.8)");
    }
    
    {
        pStmt->Sql("INSERT INTO user (userID, lastName, firstName, age, weight) VALUES(?, ?, ?, ?, ?);");
        pStmt->BindInt(1, 5);
        pStmt->BindString(2, "Murahama");
        pStmt->BindString(3, "Yura");
        pStmt->BindInt(4, 28);
        pStmt->BindDouble(5, 60.2);
        pStmt->ExecuteAndFree();
    }

    pDatabase->Close();
}