代码修改只显示修改部分：现在提示QMetaObjectconnectSlotsByName No matching signal for on_modeComboBox_currentIndexChangedint#ifndef USERSWIDGET_H#define USERSWIDGET_H#include QWidgetnamespace Ui class UsersWidget;clas

#include #include #include #include #include #include "sqlite.h"

Sqlite::Sqlite() {

}

void Sqlite::sqlite_init() { // 先关闭重复的数据库连接 if (QSqlDatabase::contains("qt_sql_default_connection")) { QSqlDatabase::removeDatabase("qt_sql_default_connection"); } QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE"); db.setDatabaseName("../Smarthome_Client/database/database.db"); if(!db.open()) { qDebug()<<"无法打开数据库！"; } else{ qDebug()<<"数据库打开成功！"; } }

// 更新智能家居状态表中的数据 void updateSmartHomeStatus(int userId, QString deviceName, QString devicestate,QString newValue) { Sqlite::sqlite_init(); // 执行更新操作 QSqlQuery query; query.prepare("SELECT * FROM Status WHERE uid = :userId AND device_name = :deviceName"); query.bindValue(":userId", userId); query.bindValue(":deviceName", deviceName); if (!query.exec()) { qDebug() << "查询状态失败：" << query.lastError().text(); return; } if (query.next()) { QString sql = QString("UPDATE Status SET device_state = '%1', value = '%2' WHERE uid = %3 AND device_name = '%4'") .arg(devicestate).arg(newValue).arg(userId).arg(deviceName); query.prepare(sql); if (!query.exec()) { qDebug() << "更新数据失败：" << query.lastError().text(); return; } } else { QString sql = QString("INSERT INTO Status (uid, device_name, device_state, value) VALUES (%1, '%2', '%3', '%4')") .arg(userId).arg(deviceName).arg(devicestate).arg(newValue); query.prepare(sql); if (!query.exec()) { qDebug() << "插入数据失败：" << query.lastError().text(); return; } } }

bool statusUid(int userId) { Sqlite::sqlite_init(); QSqlQuery query; // 查询智能家居状态表，获取用户对应的状态 query.prepare("SELECT * FROM status WHERE uid = :userId"); query.bindValue(":userId", userId); qDebug()<<query.exec(); if (!query.next()) { qDebug() << "Failed to execute query!"<<query.lastError().text(); return false; }else{ qDebug() << "Successed to execute query!"; return true; } }