byteimport.h

一个用ADO执行存储过程的例子

#ifndef _BYTEIMPORT_H_
#define _BYTEIMPORT_H_

#include <fstream.h>
#include <time.h>

class ByteImport
{
public:
	ByteImport(char *pcFile,char *pcDelimiter = "\t");		// Constructor
	~ByteImport();

private:
	enum { Invalid=0,Valid=1 } BufferStatus;
	bool  m_bIsopen; 

public:
	int next();
	bool        IsFileopen() { return m_bIsopen; }
	inline char *GetBuffer() { return caBuffer; }
	inline int GetBytes() { return iBytes; }
	inline int GetRequests() { return iRequests; }
	inline char *GetSQL() { return pcSQL; }
	inline int GetRecordCount() { return iValidRecords; }
	inline int isValidRecord() { return Valid == iBufferStatus; }
	inline int GetErrorCount() { return iInvalidRecords; }
	inline int Commit(int iRate = 500) { return 0 == (iValidRecords % iRate); }

	time_t ElapsedTime();
	char		*pcDate;
	char		*pcURL;
	char		*pcTop;
	char		*pcQueryString;
	char		*pcBytes;
	char		*pcRequests;

private:
	void parse();
	int isNumeric(char *pcBuffer);

	int			 iBufferStatus;	// status of current buffer 0=Invalid,1=Valid
	char		 caBuffer[4096];	// current record
	char		 pcSQL[4096];

	char		*pcDelimiter;
	int			 iBytes;
	int			 iRequests;
	int			 iValidRecords;
	int			 iInvalidRecords;

	time_t		 ttStart;
	time_t		 ttStop;

	ifstream   f;
};

#endif