📄 classcplodbcstatement.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1"><title>GDAL: CPLODBCStatement Class Reference</title><link href="doxygen.css" rel="stylesheet" type="text/css"><link href="tabs.css" rel="stylesheet" type="text/css"></head><body><!-- Generated by Doxygen 1.5.1 --><div class="tabs"> <ul> <li><a href="index.html"><span>Main Page</span></a></li> <li id="current"><a href="annotated.html"><span>Classes</span></a></li> <li><a href="files.html"><span>Files</span></a></li> <li><a href="pages.html"><span>Related Pages</span></a></li> </ul></div><div class="tabs"> <ul> <li><a href="annotated.html"><span>Class List</span></a></li> <li><a href="hierarchy.html"><span>Class Hierarchy</span></a></li> <li><a href="functions.html"><span>Class Members</span></a></li> </ul></div><h1>CPLODBCStatement Class Reference</h1><!-- doxytag: class="CPLODBCStatement" --><code>#include <<a class="el" href="cpl__odbc_8h-source.html">cpl_odbc.h</a>></code><p><a href="classCPLODBCStatement-members.html">List of all members.</a><table border="0" cellpadding="0" cellspacing="0"><tr><td></td></tr><tr><td colspan="2"><br><h2>Public Member Functions</h2></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="ab606aaea30a350fe91ab0e3f1da3647"></a><!-- doxytag: member="CPLODBCStatement::CPLODBCStatement" ref="ab606aaea30a350fe91ab0e3f1da3647" args="(CPLODBCSession *)" --> </td><td class="memItemRight" valign="bottom"><b>CPLODBCStatement</b> (<a class="el" href="classCPLODBCSession.html">CPLODBCSession</a> *)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="89219d0c93a15333b3d3d68ef732dc7a"></a><!-- doxytag: member="CPLODBCStatement::GetStatement" ref="89219d0c93a15333b3d3d68ef732dc7a" args="()" -->HSTMT </td><td class="memItemRight" valign="bottom"><b>GetStatement</b> ()</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#3a7e1f605839b4bb73d676ea162682e7">Clear</a> ()</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#e40599446871e5bec44bd19e62252c02">AppendEscaped</a> (const char *)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#3b0f535fc43e327990d97f055bd3d472">Append</a> (const char *)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#b8c651da1fa4ce9291ab5f3c079ba423">Append</a> (int)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#170ea4a7df8f79432efce2cb27117ef2">Append</a> (double)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#bd3c9d8bdd495487e981429199e99f51">Appendf</a> (const char *,...)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="07625f5463eea76c32b0de5e53a4f0f5"></a><!-- doxytag: member="CPLODBCStatement::GetCommand" ref="07625f5463eea76c32b0de5e53a4f0f5" args="()" -->const char * </td><td class="memItemRight" valign="bottom"><b>GetCommand</b> ()</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#e952af1282c0a83e8b791cdfbb583af4">ExecuteSQL</a> (const char *=NULL)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#2ebf900aec9ed9a635e0b24f838ec00c">Fetch</a> (int nOrientation=SQL_FETCH_NEXT, int nOffset=0)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="f976569c5dc6a5e1d52aeff001fd82c8"></a><!-- doxytag: member="CPLODBCStatement::ClearColumnData" ref="f976569c5dc6a5e1d52aeff001fd82c8" args="()" -->void </td><td class="memItemRight" valign="bottom"><b>ClearColumnData</b> ()</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#4fdb2a6ed42b2193ec5c668d978c7140">GetColCount</a> ()</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#eb9cf8e5a20abfe6d49f937c8e16bab3">GetColName</a> (int)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">short </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#cefccc2295341b2ef09e0ad9be5ec9e2">GetColType</a> (int)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#a727a5ebeb29ce108b01a847de18a8de">GetColTypeName</a> (int)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">short </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#3fc9186c6b107cfbedb5677e97c86830">GetColSize</a> (int)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">short </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#2d6c8c2f790c81ce9ad1f067ee26ddfa">GetColPrecision</a> (int)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">short </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#31342f00e8dbbaea08ce7bcab12cad79">GetColNullable</a> (int)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#8d4871f0e005f499b23061c265b8bdda">GetColId</a> (const char *)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#2726f6b16d26e6002941898538c32c83">GetColData</a> (int, const char *=NULL)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#8589aec3daac0c3263232c571bb1bb8d">GetColData</a> (const char *, const char *=NULL)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="7e87977f8ce1fc67d3fcd72d143fdf9d"></a><!-- doxytag: member="CPLODBCStatement::GetColDataLength" ref="7e87977f8ce1fc67d3fcd72d143fdf9d" args="(int)" -->int </td><td class="memItemRight" valign="bottom"><b>GetColDataLength</b> (int)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#f6b487988cc484eda8a14d0bdb97d04b">GetColumns</a> (const char *pszTable, const char *pszCatalog=NULL, const char *pszSchema=NULL)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#df52034b4bb377d1ca7956b1d8c1b142">GetPrimaryKeys</a> (const char *pszTable, const char *pszCatalog=NULL, const char *pszSchema=NULL)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#17d2640dd75d50f4d37a33ad372f606d">GetTables</a> (const char *pszCatalog=NULL, const char *pszSchema=NULL)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#aac8fabff87844776f9198786fbf8cab">DumpResult</a> (FILE *fp, int bShowSchema=FALSE)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="c2f63ad925897e76926340dc5cd1be23"></a><!-- doxytag: member="CPLODBCStatement::CollectResultsInfo" ref="c2f63ad925897e76926340dc5cd1be23" args="()" -->int </td><td class="memItemRight" valign="bottom"><b>CollectResultsInfo</b> ()</td></tr><tr><td colspan="2"><br><h2>Static Public Member Functions</h2></td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">static CPLString </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#e9f475371e9ff2f91e6514668803900b">GetTypeName</a> (int)</td></tr><tr><td class="memItemLeft" nowrap align="right" valign="top">static SQLSMALLINT </td><td class="memItemRight" valign="bottom"><a class="el" href="classCPLODBCStatement.html#fe650707128654709da20449ee440f2a">GetTypeMapping</a> (SQLSMALLINT)</td></tr></table><hr><a name="_details"></a><h2>Detailed Description</h2>Abstraction for statement, and resultset.<p>Includes methods for executing an SQL statement, and for accessing the resultset from that statement. Also provides for executing other ODBC requests that produce results sets such as SQLColumns() and SQLTables() requests. <p><hr><h2>Member Function Documentation</h2><a class="anchor" name="3a7e1f605839b4bb73d676ea162682e7"></a><!-- doxytag: member="CPLODBCStatement::Clear" ref="3a7e1f605839b4bb73d676ea162682e7" args="()" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">void CPLODBCStatement::Clear </td> <td>(</td> <td class="paramname"> </td> <td> ) </td> <td width="100%"></td> </tr> </table></div><div class="memdoc"><p>Clear internal command text and result set definitions. </div></div><p><a class="anchor" name="e40599446871e5bec44bd19e62252c02"></a><!-- doxytag: member="CPLODBCStatement::AppendEscaped" ref="e40599446871e5bec44bd19e62252c02" args="(const char *)" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">void CPLODBCStatement::AppendEscaped </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>pszText</em> </td> <td> ) </td> <td width="100%"></td> </tr> </table></div><div class="memdoc"><p>Append text to internal command.<p>The passed text is appended to the internal SQL command text after escaping any special characters so it can be used as a character string in an SQL statement.<p><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"></td><td valign="top"><em>pszText</em> </td><td>text to append. </td></tr> </table></dl></div></div><p><a class="anchor" name="3b0f535fc43e327990d97f055bd3d472"></a><!-- doxytag: member="CPLODBCStatement::Append" ref="3b0f535fc43e327990d97f055bd3d472" args="(const char *)" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">void CPLODBCStatement::Append </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>pszText</em> </td> <td> ) </td> <td width="100%"></td> </tr> </table></div><div class="memdoc"><p>Append text to internal command.<p>The passed text is appended to the internal SQL command text.<p><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"></td><td valign="top"><em>pszText</em> </td><td>text to append. </td></tr> </table></dl></div></div><p><a class="anchor" name="b8c651da1fa4ce9291ab5f3c079ba423"></a><!-- doxytag: member="CPLODBCStatement::Append" ref="b8c651da1fa4ce9291ab5f3c079ba423" args="(int)" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">void CPLODBCStatement::Append </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>nValue</em> </td> <td> ) </td> <td width="100%"></td> </tr> </table></div><div class="memdoc"><p>Append to internal command.<p>The passed value is formatted and appended to the internal SQL command text.<p><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"></td><td valign="top"><em>nValue</em> </td><td>value to append to the command. </td></tr> </table></dl></div></div><p><a class="anchor" name="170ea4a7df8f79432efce2cb27117ef2"></a><!-- doxytag: member="CPLODBCStatement::Append" ref="170ea4a7df8f79432efce2cb27117ef2" args="(double)" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">void CPLODBCStatement::Append </td> <td>(</td> <td class="paramtype">double </td> <td class="paramname"> <em>dfValue</em> </td> <td> ) </td> <td width="100%"></td> </tr> </table></div><div class="memdoc"><p>Append to internal command.<p>The passed value is formatted and appended to the internal SQL command text.<p><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"></td><td valign="top"><em>dfValue</em> </td><td>value to append to the command. </td></tr> </table></dl></div></div><p><a class="anchor" name="bd3c9d8bdd495487e981429199e99f51"></a><!-- doxytag: member="CPLODBCStatement::Appendf" ref="bd3c9d8bdd495487e981429199e99f51" args="(const char *,...)" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">int CPLODBCStatement::Appendf </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>pszFormat</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"> </td> <td class="paramname"> <em>...</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td width="100%"></td> </tr> </table></div><div class="memdoc"><p>Append to internal command.<p>The passed format is used to format other arguments and the result is appended to the internal command text. Long results may not be formatted properly, and should be appended with the direct <a class="el" href="classCPLODBCStatement.html#3b0f535fc43e327990d97f055bd3d472">Append()</a> methods.<p><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"></td><td valign="top"><em>pszFormat</em> </td><td>printf() style format string.</td></tr> </table></dl><dl class="return" compact><dt><b>Returns:</b></dt><dd>FALSE if formatting fails dueto result being too large. </dd></dl></div></div><p><a class="anchor" name="e952af1282c0a83e8b791cdfbb583af4"></a><!-- doxytag: member="CPLODBCStatement::ExecuteSQL" ref="e952af1282c0a83e8b791cdfbb583af4" args="(const char *=NULL)" --><div class="memitem"><div class="memproto"> <table class="memname"> <tr> <td class="memname">int CPLODBCStatement::ExecuteSQL </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>pszStatement</em> = <code>NULL</code> </td> <td> ) </td> <td width="100%"></td> </tr> </table></div><div class="memdoc"><p>Execute an SQL statement.<p>This method will execute the passed (or stored) SQL statement, and initialize information about the resultset if there is one. If a NULL statement is passed, the internal stored statement that has been previously set via <a class="el" href="classCPLODBCStatement.html#3b0f535fc43e327990d97f055bd3d472">Append()</a> or <a class="el" href="classCPLODBCStatement.html#bd3c9d8bdd495487e981429199e99f51">Appendf()</a> calls will be used.<p><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0">⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -