ActiveX-DCOM-ATL

Development Platform:

Visual C++

DALMyBools.h：Code Content

							// DALMyBools.h : Declaration of the CDALMyBools
#ifndef __DALMYBOOLS_H_
#define __DALMYBOOLS_H_
#include "resource.h"       // main symbols
#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","adEOF")
/////////////////////////////////////////////////////////////////////////////
// CDALMyBools
class ATL_NO_VTABLE CDALMyBools : 
	public CComObjectRootEx<CComSingleThreadModel>,
	public CComCoClass<CDALMyBools, &CLSID_DALMyBools>,
	public ISupportErrorInfo,
	public IDispatchImpl<IDALMyBools, &IID_IDALMyBools, &LIBID_BOOKSDALLib>
{
public:
	CDALMyBools()
	{
		this->m_sqlQueryById="select * from ocybooks where bookisnb=?";
		this->m_sqlQueryAll="select * from ocybooks";
		this->m_sqlUpdate="update ocybooks set bookname=?,bookauthor=? where bookisnb=?";
		this->m_sqlSave="insert into ocybooks (bookisnb,bookname,bookauthor) values(?,?,?)";
		this->m_sqlDelete="delete from ocybooks where bookisnb=?";
	}
DECLARE_REGISTRY_RESOURCEID(IDR_DALMYBOOLS)
DECLARE_PROTECT_FINAL_CONSTRUCT()
BEGIN_COM_MAP(CDALMyBools)
	COM_INTERFACE_ENTRY(IDALMyBools)
	COM_INTERFACE_ENTRY(IDispatch)
	COM_INTERFACE_ENTRY(ISupportErrorInfo)
END_COM_MAP()
// ISupportsErrorInfo
	STDMETHOD(InterfaceSupportsErrorInfo)(REFIID riid);
// IDALMyBools
public:
	//属性；Datasource, pwd,uid;
	STDMETHOD(get_DataSource)(/*[out, retval]*/ BSTR *pVal);
	STDMETHOD(put_DataSource)(/*[in]*/ BSTR newVal);
	STDMETHOD(get_PWD)(/*[out, retval]*/ BSTR *pVal);
	STDMETHOD(put_PWD)(/*[in]*/ BSTR newVal);
	STDMETHOD(get_UID)(/*[out, retval]*/ BSTR *pVal);
	STDMETHOD(put_UID)(/*[in]*/ BSTR newVal);
	//表的insert/delete/update/select
	STDMETHOD(Update)(/*[in]*/ DTOBook* Book, /*[out]*/ UINT* iResult);
	STDMETHOD(DeleteBookById)(/*[in]*/ UINT id, /*[out]*/ UINT* iResult);
	STDMETHOD(SaveBook)(/*[in]*/ DTOBook* bookdata, /*[out]*/ UINT* pResult);
	STDMETHOD(QueryAllBook)(/*[out]*/ DTOBook** allBook,UINT* Numbers);
	STDMETHOD(GetBookByIsbn)(/*[in]*/ UINT bookisbn,/*[out]*/ DTOBook** mybook);
private:
	//连接方法
	_ConnectionPtr GetMyConn();
	//参数定义方法；
	_ParameterPtr GetIdPara(UINT id,_CommandPtr sqlObj);
	_ParameterPtr GetNamePara(CString name,_CommandPtr sqlObj);
	_ParameterPtr GetAuthorPara(CString author,_CommandPtr sqlObj);
	CString m_sqlQueryById;
	CString m_sqlQueryAll;
	CString m_sqlUpdate;
	CString m_sqlSave;
	CString m_sqlDelete;
	CString m_UID;
	CString m_PWD;
	CString m_DataSource;
};
#endif //__DALMYBOOLS_H_

						