-
Notifications
You must be signed in to change notification settings - Fork 0
/
sqlexample.h
60 lines (49 loc) · 1.16 KB
/
sqlexample.h
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
#ifndef SQLEXAMPLE_H
#define SQLEXAMPLE_H
#include <QWidget>
#include <QSqlDatabase>
#include <QtSql>
QT_FORWARD_DECLARE_CLASS(QTreeWidget)
QT_FORWARD_DECLARE_CLASS(QTreeWidgetItem)
QT_FORWARD_DECLARE_CLASS(QSqlDatabase)
QT_FORWARD_DECLARE_CLASS(QMenu)
namespace Ui {
class SQLExample;
}
class SQLExample : public QWidget {
Q_OBJECT
public:
explicit SQLExample(QWidget* parent = 0);
~SQLExample();
public slots:
void connectDatabase();
void refresh();
void showInfo();
void showStatus();
void showEvent();
protected:
void changeEvent(QEvent* e);
signals:
void statusMessage(const QString& message);
private slots:
void on_deviceList_itemSelectionChanged();
void readConfig();
void on_refreshButton_clicked();
private:
Ui::SQLExample* ui;
QSqlDatabase* db;
QString dbmstype;
QString hostname;
QString database;
QString username;
QString password;
QSqlQueryModel* statusModel;
QSqlQueryModel* eventModel;
QString listQuery;
QString infoQuery;
QStringList headers;
QString playlistQuery;
QString statusQuery;
QString eventQuery;
};
#endif // SQLEXAMPLE_H