db_mysql.h

Go to the documentation of this file.

#ifndef DB_MYSQL_CLASS_H
#define DB_MYSQL_CLASS_H
 
#include <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