cociexampledlg.h

这个是用OCI接口在VC平台上对Oracle 数据库的操作.包括对数据库的连接,数据表的提取,查询,删除,修改等基本功能.这个代码已经编译实现.

// COCIExampleDlg.h : header file
//

#if !defined(AFX_COCIEXAMPLEDLG_H__317DF109_B756_4667_9B24_06DE594E7C42__INCLUDED_)
#define AFX_COCIEXAMPLEDLG_H__317DF109_B756_4667_9B24_06DE594E7C42__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
#include "oci.h"
/////////////////////////////////////////////////////////////////////////////
// CCOCIExampleDlg dialog

class CCOCIExampleDlg : public CDialog
{
public:
	OCIEnv      *envhp;
	OCIServer   *srvhp;
	OCISvcCtx   *svchp;
	OCIError    *errhp;
	OCISession  *authp;
	OCIStmt     *stmthp;
	OCIDescribe *dschp;

	OCIDefine * defhp[20];
	OCIBind   * bidhp[20];
	OCIParam  * colhp;
	ub2   collen[30];
	ub2   coltype[30];
	text      *colbuf[30];
	sb2   ind[30];

	CString ColName[50];
	CString ColType[50];
	CString ColVal[50][100];
	int ColumnNumbers;
	CString TableName;
	
// Construction
public:
	void ErrorProc(dvoid *err,sword status);
	CCOCIExampleDlg(CWnd* pParent = NULL);	// standard constructor
	~CCOCIExampleDlg();

// Dialog Data
	//{{AFX_DATA(CCOCIExampleDlg)
	enum { IDD = IDD_COCIEXAMPLE_DIALOG };
	CComboBox	m_comConFNameCtrl;
	CComboBox	m_comboCtrl;
	CListCtrl	m_listCtrl;
	CListBox	m_listTablename;
	CString	m_strTablename;
	CString	m_strFieldName;
	CString	m_strCondition;
	CString	m_strFieldVal;
	CString	m_strConFName;
	CString	m_strConFVal;
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CCOCIExampleDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);	// DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	HICON m_hIcon;

	// Generated message map functions
	//{{AFX_MSG(CCOCIExampleDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnSysCommand(UINT nID, LPARAM lParam);
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	afx_msg void OnButConnectdb();
	afx_msg void OnBTableselectok();
	afx_msg void OnButQuery();
	afx_msg void OnButDelete();
	afx_msg void OnButUpdate();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_COCIEXAMPLEDLG_H__317DF109_B756_4667_9B24_06DE594E7C42__INCLUDED_)