oraclehandler.h

基础数据管理工具 主要针对政务系统的基础数据管理、分析、应用等功能！ 项目代码

// OracleHandler.h: interface for the COracleHandler class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_ORACLEHANDLER_H__C11CEA5C_BC86_4DF5_81F5_C7E12B605751__INCLUDED_)
#define AFX_ORACLEHANDLER_H__C11CEA5C_BC86_4DF5_81F5_C7E12B605751__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

#include "ADOHandler.h"

#ifdef _EXPORT_BASEFUNC_
#define EXPORT_BASE_DLL		__declspec(dllexport)
#else
#define EXPORT_BASE_DLL		__declspec(dllimport)
#endif

typedef struct
{
	CString sServerName;
	CString sUserName;
	CString sPassword;
} 
EBOraConnectionInfo;

class EXPORT_BASE_DLL COracleHandler : public CADOHandler  
{
public:
	COracleHandler();
	virtual ~COracleHandler();

	bool InitInstance(const EBOraConnectionInfo &ebInfo);
//	CString GetServerName() {return m_sServerName;};
//	CString GetUserName() {return m_sUserName;};
//	CString GetUserPassWord() {return m_sUserPassWord;};
	//测试DataBaseLink是否可以连接
	bool TestDBLinkConnective(LPCTSTR pzsLinkName);
	//重新配置DataBaseLink
	bool ResetDataBaseLink(LPCTSTR pzsLinkName,LPCTSTR pzsTNSstring,LPCTSTR pzsUserName,LPCTSTR pzsPassWord);
	bool DropDataBaseLink(LPCTSTR pzsLinkName);
	//运行SQl脚本文件
	bool RunSQlScript(LPCTSTR pzsFilePath);
	//导出表
	bool ExportTables(CString sFilePath,CString sTables="");
	//删除用户下所有数据
	void ClearUserAllObjects();
	//恢复用户级的备份数据
	bool GetUserBack(LPCTSTR pzsSysUserID,LPCTSTR pzsSysUserPassWord,LPCTSTR pzsBackFilePath);

	bool CreateSequence(LPCTSTR pzsSequenceName,long lngMinValue=1,long lngMaxValue=99999999,long lngStartValue=1,long lngIncrementValue=1);
	long GetSequenceID(LPCTSTR pzsSequenceName);
protected:
	EBOraConnectionInfo ebConInfo;
};

#endif // !defined(AFX_ORACLEHANDLER_H__C11CEA5C_BC86_4DF5_81F5_C7E12B605751__INCLUDED_)