db_mysql.h

Go to the documentation of this file.

#ifndef DB_MYSQL_CLASS_H
#define DB_MYSQL_CLASS_H
 
#include <iostream>
#include <mysql.h>
#include <string>
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