dboperator.h

来自「通过ODBC API实现对数据库的访问.虽然用ODBC访问数据库比较麻烦」· C头文件 代码 · 共 38 行

#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;
};