DBInterface.cpp 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. #include "StdAfx.h"
  2. #include "DBInterface.h"
  3. CDBInterface::CDBInterface(void)
  4. {
  5. }
  6. CDBInterface::~CDBInterface(void)
  7. {
  8. }
  9. /************************************************************************/
  10. /*
  11. 函数:InitCatalog
  12. 描述:初始化数据库实例连接对象;
  13. 参数:
  14. 返回:
  15. 要求:
  16. 注意:
  17. */
  18. /************************************************************************/
  19. BOOL CDBInterface::InitCatalog(IN CONST DWORD &dwCatalogPort, IN LPCTSTR lpCatalogSource, IN LPCTSTR lpCatalogAccount, IN LPCTSTR lpCatalogPsw, IN LPCTSTR lpCatalogName)
  20. {
  21. if ( IsOpen() )
  22. return TRUE;
  23. TCHAR szSQLConnt[MAX_PATH] = _T("");
  24. if (dwCatalogPort)
  25. {
  26. _stprintf_s(szSQLConnt, _T("driver={SQL Server};Server=%s,%d;database=%s;uid=%s;pwd=%s"),
  27. lpCatalogSource, dwCatalogPort, lpCatalogName, lpCatalogAccount, lpCatalogPsw);
  28. }
  29. else
  30. {
  31. _stprintf_s(szSQLConnt, _T("driver={SQL Server};Server=%s;database=%s;uid=%s;pwd=%s"),
  32. lpCatalogSource, lpCatalogName, lpCatalogAccount, lpCatalogPsw);
  33. }
  34. SetConn(szSQLConnt);
  35. BOOL bResult = OpenCatalog();
  36. if( !bResult )
  37. {
  38. OutputDebugString(_T("打开数据库失败\n"));
  39. }
  40. return bResult;
  41. }