csqlquery.h

很好用的数据库连接组件

#ifndef CSQLQUERY_H
#define CSQLQUERY_H

#include "CVariant.h"
#include "CSqlError.h"
#include "CSqlShared.h"

class CSqlDriver;
class CSqlResult;
class CSqlBcpResult;
class CSqlResultInfo;
class CSqlConnection;

class CSqlResultShared ;
class CSqlQuery
{
public:
	CSqlQuery (CSqlResult * r);
	CSqlQuery (const string & query = "", CSqlConnection * db = NULL);
	CSqlQuery (const CSqlQuery & other);
	CSqlQuery & operator= (const CSqlQuery & other);
	virtual ~ CSqlQuery ();

	bool isValid () const;
	bool isActive () const;
	bool isNull (int field) const;
	string lastQuery () const;
	int numRowsAffected () const;
	CSqlError lastError () const;
	bool isSelect () const;
	int size () const;
  
	const CSqlDriver *driver () const;
	const CSqlResult *result () const;

	bool useDb (const string & db);
	bool isTableExist (const string & table);
	virtual bool exec (const string & query);
	virtual bool multi_exec (const string & query);
	virtual CVariant value (int i) const;
	virtual int  intValue (int i) const;
	virtual char* stringValue (int i) const;
	virtual bool bind( char buf[][256] , int len=0 ) ;
	virtual int  get_result ();
	virtual bool  cancel (bool bAll=true);
	virtual int  get_columns ();
	virtual bool next ();
private:
	CSqlResultShared * d;
};



#endif