vrecordset.h

otl简单包装实现类,对数据库进行操作的,简单易用.

/***************************************************************************
                          vrecordset.h  -  description
                             -------------------
    begin                : 2004-12-25
    copyright            : (C) 2004 by LiuZhong
    email                : [e-mail]
 ***************************************************************************/

/***************************************************************************
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation; either version 2 of the License, or     *
 *   (at your option) any later version.                                   *
 *                                                                         *
 ***************************************************************************/

#ifndef VRECORDSET_H
#define VRECORDSET_H

#include <mysql.h>
#include <iostream.h>
#include <string.h>
// include options: -I/usr/local/mysql/include 
// link options: -L/usr/local/mysql/lib -lmysqlclient -lz

/**
  *@author Liu
  */

class VRecordSet
{
public:
	char *Field(char *szFieldName);
	char *Field(unsigned short unFieldNo);

	int   FieldNum();
	char* FieldName(unsigned short unFieldNo);

	bool IsEof();
	bool IsBof();
	int  Total();
	int  Current();
	
	bool MoveFirst();
	bool MoveLast();
	bool MoveNext();
	bool MovePrev();
	bool MoveTo(int iPos);
	bool Refresh();
	bool Open(char *szSQL);
	void Close();
	bool Execute(char *szSQL);

	bool Connect(char *szDBName,int Port=0);
	void DisConnect();

	VRecordSet();
	~VRecordSet();
private:
	char* m_sql;
	MYSQL *m_conn;
	MYSQL_RES *m_set;
	MYSQL_ROW_OFFSET m_offset;
	bool m_bEof;
	bool m_bBof;
	
	int m_iPos;
	int m_iRows;
	static const char scNull[2];
};

class VSqlSet{
public:
	char *Field(char *szFieldName);
	char *Field(unsigned short unFieldNo);
	int   FieldLength(char *szFieldName);
	int   FieldLength(unsigned short unFieldNo);

	int   FieldNum();
	char* FieldName(unsigned short unFieldNo);

	bool IsEof();
	bool IsBof();
	int  Total();
	int  Current();

	bool MoveFirst();
	bool MoveLast();
	bool MoveNext();
	bool MovePrev();
	bool MoveTo(int iPos);
	bool Refresh();
	void SetDBConn(MYSQL* Conn);
	bool Open(char *szSQL);
	void Close();

	VSqlSet();
	~VSqlSet();
private:
	MYSQL *m_conn;
	MYSQL_RES *m_set;
	MYSQL_ROW_OFFSET m_offset;
	char* m_sql;
	bool m_bEof;
	bool m_bBof;
	int m_iPos;
	int m_iRows;
	static const char scNull[2];
};

class VSqlBase{
private:
	MYSQL *m_Conn;
	char*  m_Host;
	int    m_Port;
	char*  m_User;
	char*  m_Password;
public:
	VSqlBase();
	~VSqlBase();
	void SetHostInfo(char* Host,int Port);
	void SetUserInfo(char* User,char* Password);
	
	bool Open(char *szDBName);
	VSqlSet*  NewSet();
	bool IsConnected();
	void Close();
	bool Execute(char* szSQL);
    static bool Execute(char* szSQL,char* szDBName,char* Host=NULL,int Port=0,char* User=NULL,char* Password=NULL);
};

#endif