testdlldlg.cpp

将对Oracle数据库读写操作的OCI进行封装。不但具有普通数据的读取操作

// testdllDlg.cpp : implementation file
//

#include "stdafx.h"
#include "testdll.h"
#include "testdllDlg.h"
#include "WTDataBase.h"
#include "WTRecordSet.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App About

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();

// Dialog Data
	//{{AFX_DATA(CAboutDlg)
	enum { IDD = IDD_ABOUTBOX };
	//}}AFX_DATA

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

// Implementation
protected:
	//{{AFX_MSG(CAboutDlg)
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
	//{{AFX_DATA_INIT(CAboutDlg)
	//}}AFX_DATA_INIT
}

void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAboutDlg)
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
	//{{AFX_MSG_MAP(CAboutDlg)
		// No message handlers
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTestdllDlg dialog

CTestdllDlg::CTestdllDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CTestdllDlg::IDD, pParent)
{
	m_bConnet = FALSE;
	//{{AFX_DATA_INIT(CTestdllDlg)
	m_strName = _T("");
	//}}AFX_DATA_INIT
	// Note that LoadIcon does not require a subsequent DestroyIcon in Win32
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}

void CTestdllDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTestdllDlg)
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Text(pDX, IDC_EDIT1, m_strName);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CTestdllDlg, CDialog)
	//{{AFX_MSG_MAP(CTestdllDlg)
	ON_WM_SYSCOMMAND()
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
	ON_BN_CLICKED(IDC_BUTTON4, OnButton4)
	ON_BN_CLICKED(IDC_BUTTON5, OnButton5)
	ON_BN_CLICKED(IDC_BUTTON6, OnButton6)
	ON_BN_CLICKED(IDC_BUTTON7, OnButton7)
	ON_BN_CLICKED(IDC_BUTTON8, OnButton8)
	ON_WM_DESTROY()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTestdllDlg message handlers

BOOL CTestdllDlg::OnInitDialog()
{
	CDialog::OnInitDialog();

	// Add "About..." menu item to system menu.

	// IDM_ABOUTBOX must be in the system command range.
	ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
	ASSERT(IDM_ABOUTBOX < 0xF000);

	CMenu* pSysMenu = GetSystemMenu(FALSE);
	if (pSysMenu != NULL)
	{
		CString strAboutMenu;
		strAboutMenu.LoadString(IDS_ABOUTBOX);
		if (!strAboutMenu.IsEmpty())
		{
			pSysMenu->AppendMenu(MF_SEPARATOR);
			pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
		}
	}

	// Set the icon for this dialog.  The framework does this automatically
	//  when the application's main window is not a dialog
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon
	
//	ConnetDB("slh","scott","tiger","OCI_DEFAULT");
	ConnetDB("WATERDB","XLDSY","XLDSY","OCI_DEFAULT");
	
	return TRUE;  // return TRUE  unless you set the focus to a control
}

void CTestdllDlg::OnSysCommand(UINT nID, LPARAM lParam)
{
	if ((nID & 0xFFF0) == IDM_ABOUTBOX)
	{
		CAboutDlg dlgAbout;
		dlgAbout.DoModal();
	}
	else
	{
		CDialog::OnSysCommand(nID, lParam);
	}
}

// If you add a minimize button to your dialog, you will need the code below
//  to draw the icon.  For MFC applications using the document/view model,
//  this is automatically done for you by the framework.

void CTestdllDlg::OnPaint() 
{
	if (IsIconic())
	{
		CPaintDC dc(this); // device context for painting

		SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0);

		// Center icon in client rectangle
		int cxIcon = GetSystemMetrics(SM_CXICON);
		int cyIcon = GetSystemMetrics(SM_CYICON);
		CRect rect;
		GetClientRect(&rect);
		int x = (rect.Width() - cxIcon + 1) / 2;
		int y = (rect.Height() - cyIcon + 1) / 2;

		// Draw the icon
		dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{
		CDialog::OnPaint();
	}
}

// The system calls this to obtain the cursor to display while the user drags
//  the minimized window.
HCURSOR CTestdllDlg::OnQueryDragIcon()
{
	return (HCURSOR) m_hIcon;
}
#include "WTError.h"

//
//读取测试:整个表 ,同时将读取到的数据插入到一个新表中
//
void CTestdllDlg::OnButton1() 
{
	UpdateData();
	//m_strName
	m_list.ResetContent();
	BOOL bSuccess = FALSE;

	CWTRecordSet recordset;
	bSuccess = recordset.Create(&db,&error);
	if(bSuccess == FALSE)
	{
		AfxMessageBox("Error");
		return;
	}

	//读取数据
	int nNum = sizeof(int);
	nNum = sizeof(long);
	nNum = sizeof(float);
	nNum = sizeof(double);
	bSuccess = recordset.Open(m_strName);
	if(bSuccess == FALSE)
	{
		CString strError;
		strError = error.GetError();
		AfxMessageBox(strError);

		recordset.Close();

		return;
	}

	CWTField *pField = NULL;
	CWTRecord *pRecord = NULL;
	CString strValue = _T("");
	long lRecordCount = 0;
	lRecordCount = recordset.GetRecordCount();

	for(long i = 0;i < lRecordCount;i++)
	{
		pRecord = recordset.GetRecord(i);
		strValue = _T("");

		int nFieldCount = 0;
		nFieldCount = pRecord->GetFieldCount();
		for(int j = 0;j < nFieldCount;j++)
		{
			pField = pRecord->Fields().GetAt(j);
			strValue += pField->GetValueAsString() + _T(",");
		}
		m_list.AddString(strValue);
	}

	recordset.Close();
}

//
//查询测试:日期查询,有选择的输出查询结果(选择其中某些字段)
//
void CTestdllDlg::OnButton2() 
{/*
	m_list.ResetContent();
	BOOL bSuccess = FALSE;

	CWTRecordSet recordset;
	bSuccess = recordset.Create(&db);
	if(bSuccess == FALSE)
	{
		AfxMessageBox("Error");
		return;
	}

	recordset.m_strFilter = _T("hiredate > :VALUE");

	CWTParameter *pParam;
	pParam = new CWTParameter();
	pParam->Create(WTDATE,&db,&error);
	CString strDate = _T("30-12月81");
	*pParam = strDate;
	pParam->SetMark(_T(":VALUE"));
	recordset.Parameters().Add(pParam);

	CWTField *pField = NULL;

	pField = new CWTField();
	pField->SetFieldName(_T("empno"));
	recordset.Fields().Add(pField);

	pField = new CWTField();
	pField->SetFieldName(_T("job"));
	recordset.Fields().Add(pField);

	pField = new CWTField();
	pField->SetFieldName(_T("hiredate"));
	recordset.Fields().Add(pField);

	bSuccess = recordset.Open(_T("emp"),&error);
	if(bSuccess == FALSE)
	{
		CString strError;
		strError = error.GetError();
		AfxMessageBox(strError);

		recordset.Close();

		return;
	}

	pField = NULL;
	CWTRecord *pRecord = NULL;
	CString strValue = _T("");
	long lRecordCount = 0;
	lRecordCount = recordset.GetRecordCount();

	for(long i = 0;i < lRecordCount;i++)
	{
		pRecord = recordset.GetRecord(i);
		strValue = _T("");

		for(int j = 0;j < pRecord->GetFieldCount();j++)
		{
			pField = pRecord->Fields().GetAt(j);
			strValue += pField->GetValueAsString() + _T(",");
		}
		m_list.AddString(strValue);
	}

	for(i = 0;i < recordset.Parameters().GetSize();i++)
	{
		CWTParameter *pParamter = NULL;
		pParamter = recordset.Parameters().GetAt(i);
		delete pParamter;
		pParamter = NULL;
	}

	for(i = 0;i < recordset.Fields().GetSize();i++)
	{
		CWTField *pField = NULL;
		pField = recordset.Fields().GetAt(i);
		delete pField;
		pField = NULL;
	}

	recordset.Close();*/
}

//
//查询测试:字符串查询,有选择的输出查询结果(选择其中某些字段)
//
void CTestdllDlg::OnButton3() 
{/*
	m_list.ResetContent();
	BOOL bSuccess = FALSE;

	CWTRecordSet recordset;
	bSuccess = recordset.Create(&db);
	if(bSuccess == FALSE)
	{
		AfxMessageBox("Error");
		return;
	}

	recordset.m_strFilter = _T("job = :VALUE");

	CWTParameter *pParam;
	pParam = new CWTParameter();
	pParam->Create(WTDATE,&db,&error);
	CString steTemp = _T("12");
	*pParam = steTemp;
	pParam->SetMark(_T(":VALUE"));
	recordset.Parameters().Add(pParam);


	//选择要输出的字段:只须选择字段名
	CWTField *pField = NULL;
	pField = new CWTField();
	pField->SetFieldName(_T("empno"));
	recordset.Fields().Add(pField);

	pField = new CWTField();
	pField->SetFieldName(_T("job"));
	recordset.Fields().Add(pField);

	bSuccess = recordset.Open(_T("emp"),&error);
	if(bSuccess == FALSE)
	{
		CString strError;
		strError = error.GetError();
		AfxMessageBox(strError);

		recordset.Close();

		for(int i = 0;i < recordset.Parameters().GetSize();i++)
		{
			CWTParameter *pParamter = NULL;
			pParamter = recordset.Parameters().GetAt(i);
			delete pParamter;