创建数据库:
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();
}
Original: https://blog.csdn.net/u011269801/article/details/126447792
Author: 春蕾夏荷_728297725
Title: c++ SQLite 特别好用的库使用实例-创建数据库(1)
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/815565/
转载文章受原作者版权保护。转载请注明原作者出处!