oracle数据库连接及基本操作封装代码,C代码库,德仔网

代码语言
代码分类
【C】 oracle数据库连接及基本操作封装
作者:intergret / 发布于2012/3/6/ 773
<div>pragma once</div>
<div></div>
ifdef _WIN32</div>
<div>pragma comment(lib,"oci.lib")<span class="Apple-tab-span" style="white-space:pre">	</span>   </div>
<div>pragma comment(lib,"ociw32.lib")</div>
<div>pragma comment(lib,"oraocci10d.lib")</div>
<div>endif</div>
<div></div>
#include <occi.h></div>
<div>using namespace oracle::occi;</div>
<div></div>
#include <string></div>
<div>using namespace std;</div>
<div></div>
<div>typedef unsigned int uint32 ;</div>
<div>typedef unsigned short uint16;</div>
<div>typedef unsigned long long uint64;</div>
<div></div>
<div>namespace ocidbi{</div>
<div></div>
<div></div>
<div>struct ClientVersion{</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>string strVersion;</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>uint32 VersionID;</div>
<div>};</div>
<div></div>
<div>class COciDBI</div>
<div>{</div>
<div>public:</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>COciDBI(void);</div>
<div>public:</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>~COciDBI(void);</div>
<div></div>
<div>public:</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>bool LoginDB(const char *user,const char *pw,const char *sid); //登录数据???</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>bool DisConnectDB();// 关闭数据库连接，释放资源</div>
<div>//protected:</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>ResultSet *OpenQuery(const char *msql); // 执行有返回结果的查询</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>ResultSet *OpenQuery2(Statement** pstm, const char *msql);</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>int64_t GetQueryNumber( const char *msql );</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>bool CloseRecordSet(ResultSet *pRsTask); //关闭有返回结果的ResultSet指针</div>
<div></div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>bool Excute(const char *msql);//执行无返回结果的操作</div>
<div>public:</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>string fn_GetErrMsg();</div>
<div></div>
<div>public:</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>Environment *m_env;</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>Connection *m_conn;</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>Statement *m_pStm;</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>string m_strerr; //错误消息</div>
<div></div>
<div>private:</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>string m_struser;</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>string m_strpw;</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>string m_strsid;</div>
<div>};</div>
<div></div>
<div></div>
<div>class COciBTDBI : public COciDBI{</div>
<div></div>
<div>public:</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>bool InitBtUserVersion();</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>bool AddBtUserVersion(ClientVersion & version);</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>bool AddBtUserVersion(string strnumber); //add by baoer 2011-03-17</div>
<div>};</div>
<div></div>
<div>}
<div></div>
试试其它关键字
　oracle数据库连接　
同语言下
可能有用的
intergret贡献的其它代码(4)