📄 cpl__odbc_8h-source.html
字号:
<a name="l00145"></a>00145 <span class="preprocessor"></span><span class="preprocessor">#endif</span><a name="l00146"></a>00146 <span class="preprocessor"></span><a name="l00147"></a>00147 <span class="preprocessor">#if !defined(MISSING_SQLULEN)</span><a name="l00148"></a>00148 <span class="preprocessor"></span><span class="comment">/* ODBC types to support 64 bit compilation */</span><a name="l00149"></a>00149 <span class="preprocessor"># define _SQLULEN SQLULEN</span><a name="l00150"></a>00150 <span class="preprocessor"></span><span class="preprocessor"># define _SQLLEN SQLLEN</span><a name="l00151"></a>00151 <span class="preprocessor"></span><span class="preprocessor">#else</span><a name="l00152"></a>00152 <span class="preprocessor"></span><span class="preprocessor"># define _SQLULEN SQLUINTEGER</span><a name="l00153"></a>00153 <span class="preprocessor"></span><span class="preprocessor"># define _SQLLEN SQLINTEGER</span><a name="l00154"></a>00154 <span class="preprocessor"></span><span class="preprocessor">#endif </span><span class="comment">/* ifdef SQLULEN */</span><a name="l00155"></a>00155 <a name="l00156"></a>00156 <a name="l00163"></a><a class="code" href="classCPLODBCSession.html">00163</a> <span class="keyword">class </span>CPL_DLL CPLODBCSession {<a name="l00164"></a>00164 <span class="keywordtype">char</span> m_szLastError[SQL_MAX_MESSAGE_LENGTH + 1];<a name="l00165"></a>00165 HENV m_hEnv;<a name="l00166"></a>00166 HDBC m_hDBC;<a name="l00167"></a>00167 <a name="l00168"></a>00168 <span class="keyword">public</span>:<a name="l00169"></a>00169 CPLODBCSession();<a name="l00170"></a>00170 ~CPLODBCSession();<a name="l00171"></a>00171 <a name="l00172"></a>00172 <span class="keywordtype">int</span> EstablishSession( <span class="keyword">const</span> <span class="keywordtype">char</span> *pszDSN, <a name="l00173"></a>00173 <span class="keyword">const</span> <span class="keywordtype">char</span> *pszUserid, <a name="l00174"></a>00174 <span class="keyword">const</span> <span class="keywordtype">char</span> *pszPassword );<a name="l00175"></a>00175 <span class="keyword">const</span> <span class="keywordtype">char</span> *GetLastError();<a name="l00176"></a>00176 <a name="l00177"></a>00177 <span class="comment">// Essentially internal. </span><a name="l00178"></a>00178 <a name="l00179"></a>00179 <span class="keywordtype">int</span> CloseSession();<a name="l00180"></a>00180 <a name="l00181"></a>00181 <span class="keywordtype">int</span> Failed( <span class="keywordtype">int</span>, HSTMT = NULL );<a name="l00182"></a>00182 HDBC GetConnection() { <span class="keywordflow">return</span> m_hDBC; }<a name="l00183"></a>00183 HENV GetEnvironment() { <span class="keywordflow">return</span> m_hEnv; }<a name="l00184"></a>00184 };<a name="l00185"></a>00185 <a name="l00195"></a><a class="code" href="classCPLODBCStatement.html">00195</a> <span class="keyword">class </span>CPL_DLL CPLODBCStatement {<a name="l00196"></a>00196 <a name="l00197"></a>00197 CPLODBCSession *m_poSession;<a name="l00198"></a>00198 HSTMT m_hStmt;<a name="l00199"></a>00199 <a name="l00200"></a>00200 SQLSMALLINT m_nColCount;<a name="l00201"></a>00201 <span class="keywordtype">char</span> **m_papszColNames;<a name="l00202"></a>00202 SQLSMALLINT *m_panColType;<a name="l00203"></a>00203 <span class="keywordtype">char</span> **m_papszColTypeNames;<a name="l00204"></a>00204 _SQLULEN *m_panColSize;<a name="l00205"></a>00205 SQLSMALLINT *m_panColPrecision;<a name="l00206"></a>00206 SQLSMALLINT *m_panColNullable;<a name="l00207"></a>00207 <a name="l00208"></a>00208 <span class="keywordtype">char</span> **m_papszColValues;<a name="l00209"></a>00209 _SQLLEN *m_panColValueLengths;<a name="l00210"></a>00210 <a name="l00211"></a>00211 <span class="keywordtype">int</span> Failed( <span class="keywordtype">int</span> );<a name="l00212"></a>00212 <a name="l00213"></a>00213 <span class="keywordtype">char</span> *m_pszStatement;<a name="l00214"></a>00214 size_t m_nStatementMax;<a name="l00215"></a>00215 size_t m_nStatementLen;<a name="l00216"></a>00216 <a name="l00217"></a>00217 <span class="keyword">public</span>:<a name="l00218"></a>00218 CPLODBCStatement( CPLODBCSession * );<a name="l00219"></a>00219 ~CPLODBCStatement();<a name="l00220"></a>00220 <a name="l00221"></a>00221 HSTMT GetStatement() { <span class="keywordflow">return</span> m_hStmt; }<a name="l00222"></a>00222 <a name="l00223"></a>00223 <span class="comment">// Command buffer related.</span><a name="l00224"></a>00224 <span class="keywordtype">void</span> Clear();<a name="l00225"></a>00225 <span class="keywordtype">void</span> AppendEscaped( <span class="keyword">const</span> <span class="keywordtype">char</span> * );<a name="l00226"></a>00226 <span class="keywordtype">void</span> Append( <span class="keyword">const</span> <span class="keywordtype">char</span> * );<a name="l00227"></a>00227 <span class="keywordtype">void</span> Append( <span class="keywordtype">int</span> );<a name="l00228"></a>00228 <span class="keywordtype">void</span> Append( <span class="keywordtype">double</span> );<a name="l00229"></a>00229 <span class="keywordtype">int</span> Appendf( <span class="keyword">const</span> <span class="keywordtype">char</span> *, ... );<a name="l00230"></a>00230 <span class="keyword">const</span> <span class="keywordtype">char</span> *GetCommand() { <span class="keywordflow">return</span> m_pszStatement; }<a name="l00231"></a>00231 <a name="l00232"></a>00232 <span class="keywordtype">int</span> ExecuteSQL( <span class="keyword">const</span> <span class="keywordtype">char</span> * = NULL );<a name="l00233"></a>00233 <a name="l00234"></a>00234 <span class="comment">// Results fetching</span><a name="l00235"></a>00235 <span class="keywordtype">int</span> Fetch( <span class="keywordtype">int</span> nOrientation = SQL_FETCH_NEXT, <a name="l00236"></a>00236 <span class="keywordtype">int</span> nOffset = 0 );<a name="l00237"></a>00237 <span class="keywordtype">void</span> ClearColumnData();<a name="l00238"></a>00238 <a name="l00239"></a>00239 <span class="keywordtype">int</span> GetColCount();<a name="l00240"></a>00240 <span class="keyword">const</span> <span class="keywordtype">char</span> *GetColName( <span class="keywordtype">int</span> );<a name="l00241"></a>00241 <span class="keywordtype">short</span> GetColType( <span class="keywordtype">int</span> );<a name="l00242"></a>00242 <span class="keyword">const</span> <span class="keywordtype">char</span> *GetColTypeName( <span class="keywordtype">int</span> );<a name="l00243"></a>00243 <span class="keywordtype">short</span> GetColSize( <span class="keywordtype">int</span> );<a name="l00244"></a>00244 <span class="keywordtype">short</span> GetColPrecision( <span class="keywordtype">int</span> );<a name="l00245"></a>00245 <span class="keywordtype">short</span> GetColNullable( <span class="keywordtype">int</span> );<a name="l00246"></a>00246 <a name="l00247"></a>00247 <span class="keywordtype">int</span> GetColId( <span class="keyword">const</span> <span class="keywordtype">char</span> * );<a name="l00248"></a>00248 <span class="keyword">const</span> <span class="keywordtype">char</span> *GetColData( <span class="keywordtype">int</span>, <span class="keyword">const</span> <span class="keywordtype">char</span> * = NULL );<a name="l00249"></a>00249 <span class="keyword">const</span> <span class="keywordtype">char</span> *GetColData( <span class="keyword">const</span> <span class="keywordtype">char</span> *, <span class="keyword">const</span> <span class="keywordtype">char</span> * = NULL );<a name="l00250"></a>00250 <span class="keywordtype">int</span> GetColDataLength( <span class="keywordtype">int</span> );<a name="l00251"></a>00251 <a name="l00252"></a>00252 <span class="comment">// Fetch special metadata.</span><a name="l00253"></a>00253 <span class="keywordtype">int</span> GetColumns( <span class="keyword">const</span> <span class="keywordtype">char</span> *pszTable, <a name="l00254"></a>00254 <span class="keyword">const</span> <span class="keywordtype">char</span> *pszCatalog = NULL,<a name="l00255"></a>00255 <span class="keyword">const</span> <span class="keywordtype">char</span> *pszSchema = NULL );<a name="l00256"></a>00256 <span class="keywordtype">int</span> GetPrimaryKeys( <span class="keyword">const</span> <span class="keywordtype">char</span> *pszTable, <a name="l00257"></a>00257 <span class="keyword">const</span> <span class="keywordtype">char</span> *pszCatalog = NULL,<a name="l00258"></a>00258 <span class="keyword">const</span> <span class="keywordtype">char</span> *pszSchema = NULL );<a name="l00259"></a>00259 <a name="l00260"></a>00260 <span class="keywordtype">int</span> GetTables( <span class="keyword">const</span> <span class="keywordtype">char</span> *pszCatalog = NULL,<a name="l00261"></a>00261 <span class="keyword">const</span> <span class="keywordtype">char</span> *pszSchema = NULL );<a name="l00262"></a>00262 <a name="l00263"></a>00263 <span class="keywordtype">void</span> DumpResult( FILE *fp, <span class="keywordtype">int</span> bShowSchema = FALSE );<a name="l00264"></a>00264 <a name="l00265"></a>00265 <span class="keyword">static</span> CPLString GetTypeName( <span class="keywordtype">int</span> );<a name="l00266"></a>00266 <span class="keyword">static</span> SQLSMALLINT GetTypeMapping( SQLSMALLINT );<a name="l00267"></a>00267 <a name="l00268"></a>00268 <span class="keywordtype">int</span> CollectResultsInfo();<a name="l00269"></a>00269 };<a name="l00270"></a>00270 <a name="l00271"></a>00271 <span class="preprocessor">#endif </span><span class="comment">/* #ifndef WIN32CE */</span><a name="l00272"></a>00272 <a name="l00273"></a>00273 <span class="preprocessor">#endif</span><a name="l00274"></a>00274 <span class="preprocessor"></span><a name="l00275"></a>00275 </pre></div><hr>Generated for GDAL by <a href="http://www.doxygen.org/index.html"><img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.5.1.</body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -