/home/bes3soft/bes3soft/Boss/7.0.2/dist/7.0.2/DQA/DQA_TO_DB/DQA_TO_DB-00-00-16/src/db_mysql.h

Go to the documentation of this file.

#ifndef DB_MYSQL_CLASS_H
#define DB_MYSQL_CLASS_H

#include <mysql/mysql.h>
#include <string>
#include <iostream>
using namespace std;
#define NEXT_ROW -1
class db_mysql
{
private:
        MYSQL *m_Mysql;
        MYSQL_RES *m_Res;
        MYSQL_ROW m_Row;
        MYSQL_FIELD *m_field;
        
        string m_strHost;
        string m_strUser;
        string m_strPasswd;
        string m_strDB;
        string m_strQuery;

        
        bool m_bInit;
        bool m_bConnect;
        bool m_bSelectDB;
        bool m_bExecute;
        bool m_bGetRow;
        bool m_result; //zhaohs
//Constructors:
public: 
        db_mysql();
        db_mysql(string host,string user,string passwd,string db="");
        ~db_mysql();

        unsigned int Field_num;
//functions:
        void Init(string host,string user,string passwd,string db="");
        void SetQuery(string query);
        bool Connect(void);
        bool SelectDB(string db);
                
        bool Execute(string query="");
        unsigned long Num_Rows(void);
        
        bool GetRow(my_ulonglong row=NEXT_ROW);
        string GetField(unsigned int n);
        string GetField_name(unsigned int n);
        //string GetField(string name);
        //string GetField_name(string name);
        
        void Free_Result(void);
        void Close(void);

};
#endif

---