dboperator.h

ODBC API访问数据库的文章却少之又少。虽然用ODBC访问数据库比较麻烦

#pragma once
#include <afxdb.h>
#include <odbcinst.h>
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;
};