sqliteutil.h
1.06 KB
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
#ifndef SqliteUtil_H
#define SqliteUtil_H
#include <QString>
#include <QMultiMap>
#if defined(JCOMMON_LIBRARY)
# define JCOMMONSHARED_EXPORT Q_DECL_EXPORT
#else
# define JCOMMONSHARED_EXPORT Q_DECL_IMPORT
#endif
class responseM;
class MenuItemData;
class SortList;
class JCOMMONSHARED_EXPORT SqliteUtil
{
public:
SqliteUtil();
void connectSqlDB();
void connectSqlDBLogin();
int createTable();
int execSql(QString sql,int type);
int insertsql(QStringList sql,int type=0);//0是其他，1是登陆
void writeTablesData(int, int roomId=0);
void readTablesData(int, int roomId=0);
//历史记录配置相关
QString readHistory(QString key);
void writeHistoryConfig(QString key, QString value);
//个人信息相关
QString readConfigValue(QString key, QString userFlag);
void writeConfigValue(QString key, QString value, QString userIdFlag);
static int callback_UserInfo(void *NotUsed, int argc, char **argv, char **azColName);
public:
bool isConfigFileOk;
bool isHistroyConfigFileOk;
};
#endif // SQLITE_H