databasethread.h 930 B

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. #ifndef DATABASETHREAD_H
  2. #define DATABASETHREAD_H
  3. #include <QThread>
  4. #include <QSqlDatabase>
  5. #include <QSqlQuery>
  6. #include <QVariant>
  7. #include <QDateTime>
  8. #include <QString>
  9. #include <QStringList>
  10. #include <QList>
  11. class SendPatrolRecord{
  12. public:
  13. explicit SendPatrolRecord(QString time="",QString id="",QString value=""){
  14. DataTime = time;
  15. StationId = id;
  16. Values = value;
  17. }
  18. QString DataTime;
  19. QString StationId;
  20. QString Values;
  21. };
  22. class DatabaseThread : public QThread
  23. {
  24. Q_OBJECT
  25. public:
  26. explicit DatabaseThread(QObject *parent = nullptr);
  27. void run();
  28. void mem_init();
  29. void appendSql(QString sql);
  30. void stop();
  31. void savedata();
  32. signals:
  33. void sendpatrol(QList<QStringList> sendPatrolList);
  34. public slots:
  35. private:
  36. bool keepwork;
  37. QSqlDatabase db;
  38. QStringList sqlList;
  39. QList<QStringList > sendPatrolList;
  40. };
  41. #endif // DATABASETHREAD_H