www.pudn.com > ODBCApi.rar > DbOperator.h

#pragma once 
#include  
#include  
class CDbOperator 
{ 
public: 
	SQLHENV henv; 
	SQLHDBC hdbc; 
	BOOL m_bLink; 
public: 
	CDbOperator(); 
	CDbOperator(CString strDSN, CString strUSER, CString strPWD); 
	~CDbOperator(); 
public: 
	BOOL OpenDatabase(); 
	BOOL InitAllTable(); 
	BOOL InitTableContent(); 
public: 
	BOOL IsTableExisted(CString strTableName); 
	BOOL CreateTable(CString strSQL); 
	BOOL AlterTable(CString strSQL); 
	BOOL DropTable(CString strSQL); 
	BOOL InsertContent(CString strSQL); 
public: 
	BOOL GetAllUserTable(CString strTableName[], int& nTableCount); 
public: 
	BOOL GetUserIdFromObj_User(int arrUserId[], int& nUserCount); 
	BOOL GetNinaByUserId(int nUserId, CString& strNickname); 
	BOOL GetUserpwdFromUserId(int nUserId, int ); 
	BOOL GetUserpwdByUsernina(CString strUsernina, CString& strUserpwd); 
public: 
	BOOL GetTableNameFromSql(CString strSQL, CString& strTableName); 
private: 
	CString m_strDSN; 
	CString m_strUSER; 
	CString m_strPWD; 
};