智能灯设置 - 轻松管理您的灯光 - 常规

#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 brighteness = QString::number(ui->ctrlform->getValue());
        qDebug()<<brighteness<<userid;
        updateSmartHomeStatus(userid,QString('智能灯'),QString('开启'),brighteness);
    }
    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()<userid; QString state = getLastState(this->userid); QString brightness = getLastBrightness(this->userid); qDebug()<<brightness; 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()<userid; QString state = QString(flag); QString brightness = QString::number(ui->ctrlform->getValue()); updateLastBrightness(this->userid,state, brightness); }

QString Lights::getLastBrightness(int userid) { Sqlite::sqlite_init(); QString queryStr = QString('SELECT value FROM Status WHERE uid = %1 AND device_name = '智能灯' ORDER BY DESC').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 state,QString brightness) { Sqlite::sqlite_init(); QString queryStr = QString('UPDATE Status SET value = '%1' AND 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(); } }

QString Lights::getLastState(int userid) { Sqlite::sqlite_init(); QString queryStr = QString('SELECT device_state FROM Status WHERE uid = %1 AND device_name = '智能灯' ORDER BY DESC').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 ''; } }

得到上一次亮度错误: 'near 'WHERE': syntax error Unable to execute statement'如何解决内容：在getLastBrightness函数中，查询语句的语法有误。应该将'ORDER BY WHERE'修改为'WHERE'，即将'ORDER BY WHERE uid'修改为'WHERE uid'。修改后的代码如下：