补写代码：getLastBrightnessuseridupdateLastBrightnessuserid brightnessQt 界面点击关闭按钮隐藏起来等到再次进入这个页面页面上的内容为上次更改的状态#ifndef CONTROLFORM_H#define CONTROLFORM_H#include QWidgetnamespace Ui class ControlForm;class C

#include #include #include #include

QString getLastBrightness(int userid) { QString brightness;

QSqlDatabase db = QSqlDatabase::database();
if (!db.isValid())
{
    qDebug() << "Database is not valid!";
    return brightness;
}

QSqlQuery query(db);
query.prepare("SELECT value FROM Status WHERE uid = :userid AND device_name = '智能灯'");
query.bindValue(":userid", userid);
if (!query.exec())
{
    qDebug() << "Failed to execute query:" << query.lastError().text();
    return brightness;
}

if (query.next())
{
    brightness = query.value(0).toString();
}

return brightness;

}

void updateLastBrightness(int userid, QString brightness) { QSqlDatabase db = QSqlDatabase::database(); if (!db.isValid()) { qDebug() << "Database is not valid!"; return; }

QSqlQuery query(db);
query.prepare("UPDATE Status SET value = :brightness WHERE uid = :userid AND device_name = '智能灯'");
query.bindValue(":brightness", brightness);
query.bindValue(":userid", userid);
if (!query.exec())
{
    qDebug() << "Failed to execute query:" << query.lastError().text();
    return;
}

}