QT C++实现智能家居温湿度监控客户端 - 连接SQLite数据库

基于QT C++的智能家居温湿度监控客户端

本文介绍如何使用QT C++编写一个简单的智能家居温湿度监控客户端，该客户端能够连接到服务器，获取温湿度数据，并根据数据分析结果在GUI界面显示建议。

1. 数据库设计

数据库名为'database.db'，包含两张表：

• users表: 存储用户信息。 sql CREATE TABLE IF NOT EXISTS users ( uid INTEGER PRIMARY KEY AUTOINCREMENT, username varchar(10), passwd varchar(10) );

• Status表: 存储智能家居设备状态信息。 sql 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) );

2. 客户端实现

客户端使用QT C++编写，主要功能包括：

• 连接服务器- 发送用户ID- 接收服务器返回的建议信息- 在GUI界面显示建议信息

2.1 客户端头文件 (client.h)cpp#ifndef CLIENT_H#define CLIENT_H

#include #include

class Client : public QObject{ Q_OBJECTpublic: explicit Client(QObject *parent = nullptr);

signals: void connectionStatus(bool status); void suggestionReceived(QString suggestion);

public slots: void connectToServer(); void readData(); void displayError(QAbstractSocket::SocketError socketError);

private: QTcpSocket *socket;};

#endif // CLIENT_H

2.2 客户端源文件 (client.cpp)cpp#include 'client.h'

Client::Client(QObject *parent) : QObject(parent){ socket = new QTcpSocket(this);

connect(socket, SIGNAL(connected()), this, SLOT(readData()));    connect(socket, SIGNAL(error(QAbstractSocket::SocketError)), this, SLOT(displayError(QAbstractSocket::SocketError)));}

void Client::connectToServer(){ socket->connectToHost('127.0.0.1', 1234); // 服务器的IP地址和端口号}

void Client::readData(){ socket->waitForReadyRead();

QByteArray data = socket->readAll();    QString suggestion = QString::fromUtf8(data);    emit suggestionReceived(suggestion);}

void Client::displayError(QAbstractSocket::SocketError socketError){ QString errorString = socket->errorString(); // 在TextEdit中显示连接失败信息 qDebug() << '连接失败：' << errorString;}

2.3 客户端UI界面文件 (mainwindow.ui)xml MainWindow 0 0 400 300 Client Connect true 0 0 400 21

2.4 客户端主程序文件 (main.cpp)cpp#include 'mainwindow.h'#include 'client.h'#include

int main(int argc, char *argv[]){ QApplication a(argc, argv);

MainWindow w;    w.show();

Client client;

QObject::connect(&w, SIGNAL(connectClicked()), &client, SLOT(connectToServer()));    QObject::connect(&client, SIGNAL(connectionStatus(bool)), &w, SLOT(displayConnectionStatus(bool)));    QObject::connect(&client, SIGNAL(suggestionReceived(QString)), &w, SLOT(displaySuggestion(QString)));

return a.exec();}

2.5 主窗口头文件 (mainwindow.h)cpp#ifndef MAINWINDOW_H#define MAINWINDOW_H

#include

QT_BEGIN_NAMESPACEnamespace Ui { class MainWindow; }QT_END_NAMESPACE

class MainWindow : public QMainWindow{ Q_OBJECT

public: MainWindow(QWidget *parent = nullptr); ~MainWindow();

signals: void connectClicked();

public slots: void displayConnectionStatus(bool status); void displaySuggestion(QString suggestion); void on_connectButton_clicked();

private: Ui::MainWindow *ui;};

#endif // MAINWINDOW_H

2.6 主窗口源文件 (mainwindow.cpp)cpp#include 'mainwindow.h'#include 'ui_mainwindow.h'

MainWindow::MainWindow(QWidget *parent) : QMainWindow(parent) , ui(new Ui::MainWindow){ ui->setupUi(this);

connect(ui->connectButton, SIGNAL(clicked()), this, SLOT(on_connectButton_clicked()));}

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

void MainWindow::displayConnectionStatus(bool status){ if (status) { ui->textEdit->append('连接成功'); } else { ui->textEdit->append('连接失败'); }}

void MainWindow::displaySuggestion(QString suggestion){ ui->textEdit->append(suggestion);}

void MainWindow::on_connectButton_clicked(){ emit connectClicked()