mysqlrecordset.h

来自「SQLBig5BugTool 宽字符操作问题」· C头文件 代码 · 共 88 行

// MYSQLRecordset.h: interface for the CMYSQLRecordset class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_MYSQLRECORDSET_H__F88B9E9A_0FDB_436D_A287_EEDB3C8D871B__INCLUDED_)
#define AFX_MYSQLRECORDSET_H__F88B9E9A_0FDB_436D_A287_EEDB3C8D871B__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

class CMYSQLRecordset;
class CMySQLDatabase;

#include "MyLog.h"

#include "MySQLDatabase.h"

#include <vector>

struct MYSQL_CFG
{
	CString strServer;
	CString strUser;
	CString strPwd;
	CString strDB;
};

class CMYSQLRecordset  
{
public:
	void SetDatabase(CMySQLDatabase* pDatabase);
	BOOL IsNumericField(const long lFieldIndex,BOOL& bIsNumericField);
	BOOL IsEOF();
	BOOL MoveFirst();
	BOOL MoveNext();
	BOOL IsOpen();
	short GetFieldCount();
	DWORD GetRecordCount();
	
	BOOL Open(LPCTSTR lpszSQL = NULL);
	
	void GetFieldValue( short		nIndex, std::string& strValue );
	
	short GetFieldIndex(const char* pszFieldName);

	CMYSQLRecordset(CMySQLDatabase* pDatabase=0);
	virtual ~CMYSQLRecordset();

	void GetFieldName( short nIndex,std::string& strFieldName );
	
private:
	void FreeResultset();

	CMySQLDatabase* m_pDatabase;

	MYSQL_RES* m_hMySQLResult;

	typedef std::vector<MYSQL_FIELD> MYSQL_FIELD_LIST;

	MYSQL_FIELD_LIST m_MySQLFieldList;

	MYSQL_ROW m_pMySQLRow;
};

BOOL MySQLGetCfgFromRegistry(
							 const char*	pszKey,
							 MYSQL_CFG&		cfg,
							 const HKEY		hParentKey=HKEY_CURRENT_USER
							 );

void MySQLGetCfg(
				 const char*	pszConfigFile,
				 const char*	pszConfigSection,
				 MYSQL_CFG&		cfg
				 );

//just first record
BOOL MySQLDBTableDataGet(
					CMySQLDatabase&				db,
					const char*					pszSQL,
					STD_MAP_STRING_2_STRING&	MapFieldToValue,
					std::string&				strErrorInfo
					);


#endif // !defined(AFX_MYSQLRECORDSET_H__F88B9E9A_0FDB_436D_A287_EEDB3C8D871B__INCLUDED_)