-- 创建用户表CREATE TABLE IF NOT EXISTS users uid INTEGER PRIMARY KEY AUTOINCREMENT username varchar10 passwd varchar10;INSERT INTO users username passwd VALUES AA 123456;INSERT INTO users usern

-- 创建用户表 CREATE TABLE IF NOT EXISTS users ( uid INTEGER PRIMARY KEY AUTOINCREMENT, username varchar(10), passwd varchar(10) ); INSERT INTO users (username, passwd) VALUES ('AA', '123456'); INSERT INTO users (username, passwd) VALUES ('B', '121212');

-- 创建智能家居状态表 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) ); INSERT INTO Status(uid, device_name, device_state, value, mode) VALUES (1, 'Curtains', 'On', '1.1', '睡眠模式');

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

Lights::Lights(int userid,QWidget *parent) : QWidget(parent), ui(new Ui::Lights) { 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;
        Sqlite::sqlite_init();
        updateSmartHomeStatus(userid,QString("灯"),QString(flag),brighteness);
    }
});

}

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; }

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

Sqlite::Sqlite() {

}

void Sqlite::sqlite_init() {

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; QString sql = QString("UPDATE Status SET device_state = :device_state, value = :value WHERE uid = :uid AND device_name = :device_name"); query.prepare(sql); query.bindValue(":device_state", devicestate); query.bindValue(":value", newValue); query.bindValue(":uid", userId); query.bindValue(":device_name", deviceName);

if (!query.exec()) {
    qDebug() << "更新数据失败：" << query.lastError().text();
} else {
    qDebug() << "数据更新成功";
}

}

bool StatusUid(int userId) { Sqlite::sqlite_init(); QSqlQuery query; // 查询智能家居状态表，获取用户对应的状态 query.prepare("SELECT * FROM status WHERE uid = :uid"); query.bindValue(":uid", 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; } }

QSqlDatabasePrivate::addDatabase: duplicate connection name 'qt_sql_default_connection', old connection removed. 数据库打开成功！ 数据更新成功 Successed to execute query