mysqloperator.h

视频播放控制器程序

// MySqlOperator.h: interface for the CMySqlOperator class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_MYSQLOPERATOR_H__22EA0C11_5853_49D4_84D3_7A257866978E__INCLUDED_)
#define AFX_MYSQLOPERATOR_H__22EA0C11_5853_49D4_84D3_7A257866978E__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
#include "mysql.h"
#include "MySqlRecordset.h"

class CMySqlOperator
{
public:
	CMySqlOperator();
	virtual ~CMySqlOperator();

public:		
	// connection:
	BOOL IsConnected();

	// db:
	BOOL Open(LPCTSTR lpszDb,LPCTSTR lpszHost,LPCTSTR lpszUser=NULL,LPCTSTR lpszPassword=NULL);
	UINT GetErrCode();
	void FreeDb();
	int  Ping();

    // query:
	CMySqlRecordset* ExecuteQuery( LPCTSTR lpszSql );
	BOOL Execute( LPCTSTR lpszSql );

protected:
	//mysql members.
	sql_connection_c* m_pConn;
	sql_query_c* m_pQuery;
	BOOL m_bConnected;
};

#endif // !defined(AFX_MYSQLOPERATOR_H__22EA0C11_5853_49D4_84D3_7A257866978E__INCLUDED_)