#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