myconnection.h

利用oci（oracle connect interface）方式实现的数据库连接

// MyConnection.h: interface for the MyConnection class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_MYCONNECTION_H__703C60F4_CBD8_11D4_B3EE_000102574F1A__INCLUDED_)
#define AFX_MYCONNECTION_H__703C60F4_CBD8_11D4_B3EE_000102574F1A__INCLUDED_

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


////此头文件不可更改！！！
/*
 * 此类代表oracle的一个数据库连接
 *
 * 没有定义数据库连接的所有可能操作，如有需要与lg联系。
 * 
 */



#include "ocidem.h"
#include "oratypes.h"
#include "ocidfn.h"




//##ModelId=39A1382603CA
class  AFX_EXT_CLASS connection
{
  friend class cursor;
  public:
	//##ModelId=39A1382603DB
	BOOL IsConnected();
	//##ModelId=39A1382603DC
     connection();
	//##ModelId=39A1382603E5
     ~connection();
	//##ModelId=39A138270007
     BOOL connect(char *username, char *password,char *sername);
	//##ModelId=39A13827001B
     BOOL disconnect();
	//##ModelId=39A13827001C
     void display_error() const;





  private:
	//##ModelId=39A138270030
    Lda_Def lda;
	//##ModelId=39A138270039
    unsigned char hda[HDA_SIZE];    
	
	//##ModelId=39A138270057
	enum conn_state
    {
		//##ModelId=39A13827006B
      not_connected,
		//##ModelId=39A138270075
      connected
    };
	//##ModelId=39A138270044
    conn_state state;
}; 
/*
 * 此类代表一个oracle游标
 *
 * 没有定义游标的所有可能操作，如有需要与lg联系。
 * 
 * 
 */
//##ModelId=39A1382700C5
class AFX_EXT_CLASS cursor
{
  public:
	//##ModelId=39A1382700CF
	 BOOL IsOpened();
	//##ModelId=39A1382700D9
	 BOOL ExecuteSQL(char * stmt);
	//##ModelId=39A1382700ED
     cursor(); 
	//##ModelId=39A1382700F7
     ~cursor();
	//##ModelId=39A1382700F8
     BOOL open(connection *conn_param);
	//##ModelId=39A138270102
     BOOL close();
	//##ModelId=39A13827010B
     BOOL parse(const char *stmt);
    /* 绑定输入 */
	//##ModelId=39A138270115
     BOOL bind_by_position(int sqlvnum, void *progvar,int progvarlen, int datatype,short *indicator);

    /* 定义输出 */
	//##ModelId=39A13827012A
     BOOL define_by_position(int position, void *buf,int bufl, int datatype);                
	//##ModelId=39A138270135
     BOOL define_by_name(CString sqlname,void *buf,int bufl,  int datatype);

	//取得列描述信息
	//##ModelId=39A138270149
	 BOOL describe(int position, long *dbsize, int *dbtype, 
                   void *cbuf, int *cbufl, long *dsize, int *prec,
                   int *scale, int *nullok);
	//##ModelId=39A138270167
     BOOL execute();

	//##ModelId=39A138270168
     BOOL fetch();

	//##ModelId=39A138270170
	 int FetchMultiRow(int amount);

	//##ModelId=39A138270172
     void display_error();


  private:  
	//##ModelId=39A13827017A
	int  get_error_code();
	//##ModelId=39A138270185
    Cda_Def cda;
	//##ModelId=39A13827018F
    connection *conn;  
	//##ModelId=39A1382701A2
	CString stmt;
	//##ModelId=39A1382701AC
	BOOL    Defined[50];
	
	//##ModelId=39A1382701CA
	enum cursor_state
    {
		//##ModelId=39A1382701DE
      not_opened,
		//##ModelId=39A1382701E8
      opened
    };
	//##ModelId=39A1382701B7
    cursor_state state;
}; 




#endif // !defined(AFX_MYCONNECTION_H__703C60F4_CBD8_11D4_B3EE_000102574F1A__INCLUDED_)