mysql.h 3.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137
  1. #ifndef MYSQL_H
  2. #define MYSQL_H
  3. //SQL
  4. #include <QSqlDatabase>
  5. #include <QSqlError>
  6. #include <QSqlQuery>
  7. #include <main.h>
  8. #include <m_loger.h>
  9. typedef struct
  10. {
  11. int id;
  12. QString dtype;
  13. QString ip;
  14. int port;
  15. QString imei;
  16. QString uid;
  17. QString pwd;
  18. QString clientid;
  19. int qos;
  20. int keepalive;
  21. QString sub;
  22. QString pub;
  23. QString offline;
  24. int dat_f;
  25. }config_mqtt_db;
  26. typedef struct
  27. {
  28. int id;
  29. QString ip;
  30. int port;
  31. QString dir;
  32. QString uid;
  33. QString pwd;
  34. int mode;
  35. }config_ftp_db;
  36. typedef struct
  37. {
  38. int id;
  39. QString lbs_lat;
  40. QString lbs_lng;
  41. QString gps_lat;
  42. QString gps_lng;
  43. QString gps_elevation;
  44. }config_location_db;
  45. typedef struct
  46. {
  47. int id;
  48. QString datetime;
  49. QString Json_data;
  50. QString Json_warn;
  51. }data_json_db;
  52. typedef struct{
  53. QString camera_type;
  54. QString mode;
  55. int stitch_photonum;
  56. int photo_width;
  57. int photo_height;
  58. QString auto_focus;
  59. }config_camera;
  60. class config_db_type
  61. {
  62. public:
  63. config_mqtt_db mqtt_db;
  64. config_ftp_db ftp_db;
  65. config_location_db location_db;
  66. data_json_db json_db;
  67. config_camera camera_db;
  68. };
  69. //int mode;
  70. //QString lbs_lat;
  71. //QString lbs_lng;
  72. //QString gps_lat;
  73. //QString gps_lng;
  74. //QString gps_elevation;
  75. //QJsonArray param::mqtt_array;
  76. class SqliteOperator : public QObject
  77. {
  78. Q_OBJECT
  79. public:
  80. SqliteOperator(QString &dbname); //创建数据库
  81. //创建数据库
  82. bool OpenDb(); //打开数据库
  83. bool isTableExist(QString& tableName); //判断数据表是否存在
  84. int CloseDb(); //关闭数据库
  85. int CreateTable(QString& tableName); //创建数据表
  86. int InsertData(config_db_type &singledb,QString tablename); //插入数据
  87. void InertListConfig(QList<config_db_type> &moreData,QString tablename);
  88. int UpdateData(QString tablename, QString name, QString value); //更新、修改数据
  89. int QueryAllData(QString& table_name); //遍历查询
  90. int QueryData(); //条件查询
  91. void deleteData(int id); //删除数据
  92. void deleteTable(QString& tableName); //删除数据表
  93. private:
  94. QSqlDatabase db; // 用于建立和数据库的连接
  95. };
  96. bool InsertJson_mqtt();
  97. //条件查询与遍历查询的对比
  98. //加循环建了一个包含229300条数据,7448kb的数据库。
  99. //条件查询耗时:30ms
  100. //遍历查询耗时:100ms
  101. //随着数据量的增加,差距应该会更明显。
  102. //qml接口
  103. class DatabaseInterface : public QObject
  104. {
  105. Q_OBJECT
  106. public:
  107. explicit DatabaseInterface(QObject *parent = nullptr);
  108. Q_INVOKABLE bool openDatabase(const QString& dbName);
  109. Q_INVOKABLE bool closeDatabase();
  110. Q_INVOKABLE QString getTable_row(QString tablename);
  111. Q_INVOKABLE bool createTable(QString tableName);
  112. Q_INVOKABLE bool insertData(const QString& name, const QString& address);
  113. Q_INVOKABLE bool deleteData(int id);
  114. Q_INVOKABLE bool updateData(QString tablename,QString name,QVariant value);
  115. Q_INVOKABLE QJsonArray queryData(QString table_name,int count_index);
  116. private:
  117. QSqlDatabase m_database;
  118. };
  119. #endif // MYSQL_H