mysql.h 2.9 KB

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