Qt5 -如何在qt c++应用程序中永久添加sqlite数据库

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("path/to/database/file.db");

if (db.open()) {
    QSqlQuery query;
    query.exec("CREATE TABLE IF NOT EXISTS tablename (column1 datatype, column2 datatype, ...)");
}

QSqlQuery query;
query.prepare("INSERT INTO tablename (column1, column2) VALUES (:value1, :value2)");
query.bindValue(":value1", value1);
query.bindValue(":value2", value2);
query.exec();

QSqlQuery query;
query.prepare("UPDATE tablename SET column1 = :value1 WHERE column2 = :value2");
query.bindValue(":value1", newValue1);
query.bindValue(":value2", value2);
query.exec();

QSqlQuery query;
query.prepare("DELETE FROM tablename WHERE column1 = :value1");
query.bindValue(":value1", value1);
query.exec();

QSqlQuery query;
query.prepare("SELECT * FROM tablename WHERE column1 = :value1");
query.bindValue(":value1", value1);
query.exec();
while (query.next()) {
    // 处理查询结果
}

db.close();