Qt想要实现在主界面进入Lights界面设置智能灯状态信息点击关闭按钮该界面隐藏再次点击Lights界面显示上一次的智能灯状态信息。改错：#include lightsh#include ui_lightsh#include switchformh#include sqliteh#include QSqlQuery#include QSqlDatabase#include QSqlError#in

#include "lights.h" #include "ui_lights.h" #include "switchform.h" #include "sqlite.h" #include #include #include #include #include

Lights::Lights(int userid, QWidget *parent) : QWidget(parent), ui(new Ui::Lights), userid(userid) //保证userid无变化 { ui->setupUi(this); lightsWidget(); //连接开关组件的信号和自定义的槽函数 connect(ui->SwitchStatus, &SwitchForm::statusChanged, this, &Lights::switchButton_status);

// 连接完成按钮的clicked信号和自定义的槽函数
connect(ui->Finished, &QPushButton::clicked, this, [=]{
    if (flag)
    {
        QString brightness = QString::number(ui->ctrlform->getValue());
        qDebug() << brightness << userid;
        updateSmartHomeStatus(userid, QString("智能灯"), QString("开启"), brightness);
    }
    else
    {
        qDebug() << "智能灯未打开！";
        updateSmartHomeStatus(userid, QString("智能灯"), QString("关闭"), QString("0"));
    }
});
// 加载上次更改的状态
loadLastStatus();

}

Lights::~Lights() { delete ui; }

void Lights::lightsWidget() { setWindowTitle("智能灯设置"); //设置ui组件背景 setAutoFillBackground(true); QPalette palette = this->palette(); QPixmap pixmap(":/user/image/image/light.jpg"); palette.setBrush(QPalette::Window, QBrush(pixmap)); setPalette(palette); setFixedSize(600, 400); }

bool Lights::switchButton_status(bool checked) { qDebug() << checked; flag = checked; return flag; }

void Lights::showEvent(QShowEvent *event) { // 当页面显示时，加载上次更改的状态 loadLastStatus(); event->accept(); }

void Lights::hideEvent(QHideEvent *event) { saveLastStatus(); event->accept(); }

void Lights::closeEvent(QCloseEvent *event) { // 隐藏窗口而不是关闭 hide(); event->ignore(); }

void Lights::loadLastStatus() { qDebug() << this->userid; QString state = getLastState(this->userid); QString brightness = getLastBrightness(this->userid); qDebug() << "1" << state; if (state == "开启") { ui->SwitchStatus->setChecked(true); ui->ctrlform->setValue(brightness.toInt()); } else { ui->SwitchStatus->setChecked(false); ui->ctrlform->setValue(0); } qDebug() << brightness.toInt(); }

void Lights::saveLastStatus() { qDebug() << this->flag; QString status; if (flag) { status = "开启"; } else { status = "关闭"; } QString brightness = QString::number(ui->ctrlform->getValue()); updateLastBrightness(this->userid, brightness, status); }

QString Lights::getLastBrightness(int userid) { Sqlite::sqlite_init(); QString queryStr = QString("SELECT value FROM Status WHERE uid = %1 AND device_name = '智能灯'").arg(userid); qDebug() << queryStr << userid; QSqlQuery query; qDebug() << query.exec(queryStr); if (query.exec(queryStr) && query.next()) { return query.value(0).toString(); } else { qDebug() << "得到上一次亮度错误: " << query.lastError().text(); return ""; } }

QString Lights::getLastState(int userid) { Sqlite::sqlite_init(); QString queryStr = QString("SELECT device_state FROM Status WHERE uid = %1 AND device_name = '智能灯'").arg(userid); qDebug() << queryStr << userid; QSqlQuery query; qDebug() << query.exec(queryStr); if (query.exec(queryStr) && query.next()) { return query.value(0).toString(); } else { qDebug() << "得到上一次状态错误: " << query.lastError().text(); return ""; } }

void Lights::updateLastBrightness(int userid, QString brightness, QString state) { Sqlite::sqlite_init(); QString queryStr = QString("UPDATE Status SET value = '%1', device_state = '%2' WHERE uid = %3 AND device_name = '智能灯'").arg(brightness).arg(state).arg(userid); QSqlQuery query; if (!query.exec(queryStr)) { qDebug() << "更新亮度失败: " << query.lastError().text(); } }

-- 创建用户表 CREATE TABLE IF NOT EXISTS users ( uid INTEGER PRIMARY KEY AUTOINCREMENT, username varchar(10), passwd varchar(10) );

-- 创建智能家居状态表 CREATE TABLE IF NOT EXISTS Status ( sid INTEGER PRIMARY KEY AUTOINCREMENT, uid INTEGER, device_name varchar(10), device_state varchar(10), value varchar(10), mode varchar(10), FOREIGN KEY (uid) REFERENCES users (uid) );

SELECT value FROM Status WHERE uid = 123 AND device_name = '智能灯'