?? database.h
字號(hào):
#include <stdio.h>#include <libpq-fe.h>#include <qcstring.h>#include <qstringlist.h>#include <libpq/libpq-fs.h>#include <fcntl.h>#include <stdlib.h>#include <linux/ext2_fs.h>#include <unistd.h>#include <sys/ioctl.h>#include <sys/types.h>#define BUFSIZE 1024class CDataBase{ public: CDataBase(); ~CDataBase(); public: bool ConnectDataBase(); //連接數(shù)據(jù)庫 bool ConnectDataBase(long &hdbc,QCString dbname, QCString dbuser,QCString dbpass); //連接數(shù)據(jù)庫 bool DisConnectDataBase(long &hdbc); //斷開數(shù)據(jù)庫 int SqlExec(long hdbc,QCString SqlStr); //執(zhí)行一個(gè)SQL語句 long SqlSelect(long hdbc,QCString SqlStr,long &result); //查詢數(shù)據(jù);返回記錄數(shù) int GetRecordCount(long result); //得到記錄數(shù) int GetFieldCount(long result); //得到字段數(shù)量 QCString GetFieldName(long result,unsigned int iField); //得到字段名稱 int GetFieldType(long result,unsigned int iField); //得到字段類型 QCString GetFieldValue(long result,unsigned int iRow,unsigned int iField); //得到字段值 void ClearResult(long &result); //釋放結(jié)果內(nèi)存 //使用游標(biāo)查詢數(shù)據(jù)庫 bool OpenCursor(long hdbc,QCString SqlStr,long &pCursor); //打開一個(gè)光標(biāo) bool FetchPriorRow(long hdbc,long pCursor,long &result); //讀取當(dāng)前記錄的上一條記錄 bool FetchNextRow(long hdbc,long pCursor,long &result); //讀取當(dāng)前記錄的下一條記錄 bool FetchAllRow(long hdbc,long pCursor,long &result); //讀取所有記錄 void CloseCursor(long hdbc,long &pCursor); //關(guān)閉光標(biāo) //大文本對(duì)象的處理 bool InsertWithLargeObject(long hdbc,QCString SqlStr,QStringList FileList); //插入大對(duì)象 bool DeleteWithLargeObject(long hdbc,QCString Table,QCString WhereStr,QStringList FieldList, bool bForceDele=0,bool bDeleRow=1); //刪除大對(duì)象 bool UpdateLargeObject(long hdbc,QCString SqlStr,QStringList FileList); //修改大對(duì)象 public: QCString FillParam(QCString SqlStr,int ParamIndex,int ParamType, QCString param); //填充參數(shù) void GetTableFromSql(QCString SqlStr,QCString &Table,QCString &WhereStr,QStringList &FieldList); Oid importfile(long hdbc,char *filename); bool pickout(long hdbc,Oid objId,int start,int len,void* retbuf); bool overwrite(long hdbc,Oid lobjId,int start,int len,void* srcbuf); bool exportfile(long hdbc,Oid objId,char *filename); public: PGconn *m_pconnect; QCString m_pghost; QCString m_pgport; QCString m_pgoptions; QCString m_pgtty; QCString m_dbname; QCString m_dbuser; QCString m_dbpassword; //引入影射變量 long m_hdbc; bool m_bconnect; };
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -