sqlserver_helper.h

C++ODBC连接数据库的标准封装类

#if !defined(_SQLSERVER_HELPER_H)
#define _SQLSERVER_HELPER_H

#include <STAR/CORBA.h>
#include <stdlib.h>
#include <errno.h>
#include <assert.h>       //ASSERT
#include "sql.h"
#include "sqlext.h"
#include "sqltypes.h"    // This file defines the types used in ODBC
#include "sqlucode.h"    // This is the the unicode include for ODBC Core functions
#include "odbcss.h"      // This is the application include file for the SQL Server driver specific defines.
#include <fcntl.h>
#include <sys/types.h>
#include <sys/stat.h>
#include <io.h>
#include <stdio.h>
#include <string.h>
#include <IVCLog.h>
#include <GlobalDefines.h>

#ifdef HAVE_UNISTD_H
#   include <unistd.h>
#endif

#ifdef HAVE_STD_IOSTREAM
using namespace std;
#endif


#if !defined(WIN32)
#    include <unistd.h>
#endif

 

class SQLServer_Helper_T
{
private:
	
	SQLHENV  m_henv; //申请环境句柄
	SQLHDBC  m_hdbc; //申请环境句柄
	BOOL     m_bConnected; 
	
	char*    m_pszSourceName; 
	char*    m_pszUserId; 
    char*    m_pszPassword;
	
	//数据用户
	char*    m_pszDBUser;
	char*    m_pszDBPW;
	
	//系统查询连接标记
	BOOL     m_blnQuery; 
	//定义数据区的长度
	#define BUFFER_LENGTH                  1024 

private:

	BOOL Connect(LPCSTR pszSourceName,LPCSTR pszUserId,LPCSTR pszPassword,BOOL blnAutoTranfer);
	BOOL ExecDirectSQL(SQLHSTMT &m_hstmt,unsigned char* sqltext);
	
	//断开连接函数 
	void Disconnect();
   
	//读数据库用户
	BOOL getDBUserPW();

	//解密加了密的数据库密码
	void decryptDes(const char *secret,char &source);
	
public:		
	
	SQLServer_Helper_T();
	~SQLServer_Helper_T();

	//增删改操作
	BOOL OperaterDB(std::string strSQL);
};
#endif