element_8c-source.html

ORACLE编程的好东西,纯C写的OCI封装.很好用,支持数据池.

<a name="l00238"></a>00238 <span class="comment">/* ------------------------------------------------------------------------ *</span>
<a name="l00239"></a>00239 <span class="comment"> * OCI_ElemGetUnsignedShort</span>
<a name="l00240"></a>00240 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00241"></a>00241 
<a name="l00242"></a><a class="code" href="group__g__collection.html#g038e642f4f73ae5f18011069c1c5f452">00242</a> <span class="keywordtype">unsigned</span> <span class="keywordtype">short</span> OCI_API <a class="code" href="group__g__collection.html#g038e642f4f73ae5f18011069c1c5f452" title="Return the unsigned short value of the given collection element.">OCI_ElemGetUnsignedShort</a>(<a class="code" href="struct_o_c_i___elem.html" title="Oracle Collection item representation.">OCI_Elem</a> *elem)
<a name="l00243"></a>00243 {
<a name="l00244"></a>00244     <span class="keywordtype">unsigned</span> <span class="keywordtype">short</span> value = 0;
<a name="l00245"></a>00245     
<a name="l00246"></a>00246     OCI_CHECK_PTR(OCI_IPC_ELEMENT, elem, 0);
<a name="l00247"></a>00247 
<a name="l00248"></a>00248     OCI_ElemGetNumber(elem, (<span class="keywordtype">void</span> *) &amp;value, (uword) <span class="keyword">sizeof</span>(<span class="keywordtype">unsigned</span> <span class="keywordtype">short</span>),
<a name="l00249"></a>00249                       (uword) OCI_NUM_USHORT);
<a name="l00250"></a>00250  
<a name="l00251"></a>00251     <span class="keywordflow">return</span> value;
<a name="l00252"></a>00252 }
<a name="l00253"></a>00253 
<a name="l00254"></a>00254 <span class="comment">/* ------------------------------------------------------------------------ *</span>
<a name="l00255"></a>00255 <span class="comment"> * OCI_ElemGetInt</span>
<a name="l00256"></a>00256 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00257"></a>00257 
<a name="l00258"></a><a class="code" href="group__g__collection.html#g2d2a4783e9f727a8aaca7cd220d326cc">00258</a> <span class="keywordtype">int</span> OCI_API <a class="code" href="group__g__collection.html#g2d2a4783e9f727a8aaca7cd220d326cc" title="Return the int value of the given collection element.">OCI_ElemGetInt</a>(<a class="code" href="struct_o_c_i___elem.html" title="Oracle Collection item representation.">OCI_Elem</a> *elem)
<a name="l00259"></a>00259 {
<a name="l00260"></a>00260     <span class="keywordtype">int</span> value = 0;
<a name="l00261"></a>00261     
<a name="l00262"></a>00262     OCI_CHECK_PTR(OCI_IPC_ELEMENT, elem, 0);
<a name="l00263"></a>00263 
<a name="l00264"></a>00264     OCI_ElemGetNumber(elem, (<span class="keywordtype">void</span> *) &amp;value, (uword) <span class="keyword">sizeof</span>(value),
<a name="l00265"></a>00265                       (uword) OCI_NUM_INT);
<a name="l00266"></a>00266  
<a name="l00267"></a>00267     <span class="keywordflow">return</span> value;
<a name="l00268"></a>00268 }
<a name="l00269"></a>00269 
<a name="l00270"></a>00270 <span class="comment">/* ------------------------------------------------------------------------ *</span>
<a name="l00271"></a>00271 <span class="comment"> * OCI_ElemGetUnsignedInt</span>
<a name="l00272"></a>00272 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00273"></a>00273 
<a name="l00274"></a><a class="code" href="group__g__collection.html#g75421c426d3beece1dfa91246c5ebee9">00274</a> <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> OCI_API <a class="code" href="group__g__collection.html#g75421c426d3beece1dfa91246c5ebee9" title="Return the unsigned int value of the given collection element.">OCI_ElemGetUnsignedInt</a>(<a class="code" href="struct_o_c_i___elem.html" title="Oracle Collection item representation.">OCI_Elem</a> *elem)
<a name="l00275"></a>00275 {
<a name="l00276"></a>00276     <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> value = 0;
<a name="l00277"></a>00277     
<a name="l00278"></a>00278     OCI_CHECK_PTR(OCI_IPC_ELEMENT, elem, 0);
<a name="l00279"></a>00279 
<a name="l00280"></a>00280     OCI_ElemGetNumber(elem, (<span class="keywordtype">void</span> *) &amp;value, (uword) <span class="keyword">sizeof</span>(value),
<a name="l00281"></a>00281                       (uword) OCI_NUM_UINT);
<a name="l00282"></a>00282  
<a name="l00283"></a>00283     <span class="keywordflow">return</span> value;
<a name="l00284"></a>00284 }
<a name="l00285"></a>00285 
<a name="l00286"></a>00286 <span class="comment">/* ------------------------------------------------------------------------ *</span>
<a name="l00287"></a>00287 <span class="comment"> * OCI_ElemGetBigInt</span>
<a name="l00288"></a>00288 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00289"></a>00289 
<a name="l00290"></a><a class="code" href="group__g__collection.html#g945a0b1227b6826959e697071e274e76">00290</a> big_int OCI_API <a class="code" href="group__g__collection.html#g945a0b1227b6826959e697071e274e76" title="Return the big int value of the given collection element.">OCI_ElemGetBigInt</a>(<a class="code" href="struct_o_c_i___elem.html" title="Oracle Collection item representation.">OCI_Elem</a> *elem)
<a name="l00291"></a>00291 {
<a name="l00292"></a>00292     big_int value = 0;
<a name="l00293"></a>00293     
<a name="l00294"></a>00294     OCI_CHECK_PTR(OCI_IPC_ELEMENT, elem, 0);
<a name="l00295"></a>00295 
<a name="l00296"></a>00296     OCI_ElemGetNumber(elem, (<span class="keywordtype">void</span> *) &amp;value, (uword) <span class="keyword">sizeof</span>(big_int),
<a name="l00297"></a>00297                       (uword) OCI_NUM_BIGINT);
<a name="l00298"></a>00298  
<a name="l00299"></a>00299     <span class="keywordflow">return</span> value;
<a name="l00300"></a>00300 }
<a name="l00301"></a>00301 
<a name="l00302"></a>00302 <span class="comment">/* ------------------------------------------------------------------------ *</span>
<a name="l00303"></a>00303 <span class="comment"> * OCI_ElemGetUnsignedBigInt</span>
<a name="l00304"></a>00304 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00305"></a>00305 
<a name="l00306"></a><a class="code" href="group__g__collection.html#g61d675fd7130dd5ce2f79555f07a415b">00306</a> big_uint OCI_API <a class="code" href="group__g__collection.html#g61d675fd7130dd5ce2f79555f07a415b" title="Return the unsigned big int value of the given collection element.">OCI_ElemGetUnsignedBigInt</a>(<a class="code" href="struct_o_c_i___elem.html" title="Oracle Collection item representation.">OCI_Elem</a> *elem)
<a name="l00307"></a>00307 {
<a name="l00308"></a>00308     big_uint value = 0;
<a name="l00309"></a>00309     
<a name="l00310"></a>00310     OCI_CHECK_PTR(OCI_IPC_ELEMENT, elem, 0);
<a name="l00311"></a>00311 
<a name="l00312"></a>00312     OCI_ElemGetNumber(elem, (<span class="keywordtype">void</span> *) &amp;value,  (uword) <span class="keyword">sizeof</span>(big_uint),
<a name="l00313"></a>00313                       (uword) OCI_NUM_BIGUINT);
<a name="l00314"></a>00314  
<a name="l00315"></a>00315     <span class="keywordflow">return</span> value;
<a name="l00316"></a>00316 }
<a name="l00317"></a>00317 
<a name="l00318"></a>00318 <span class="comment">/* ------------------------------------------------------------------------ *</span>
<a name="l00319"></a>00319 <span class="comment"> * OCI_ElemGetDouble</span>
<a name="l00320"></a>00320 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00321"></a>00321 
<a name="l00322"></a><a class="code" href="group__g__collection.html#g2e2610880b2e3c5d9e065f4135d1ba82">00322</a> <span class="keywordtype">double</span> OCI_API <a class="code" href="group__g__collection.html#g2e2610880b2e3c5d9e065f4135d1ba82" title="Return the Double value of the given collection element.">OCI_ElemGetDouble</a>(<a class="code" href="struct_o_c_i___elem.html" title="Oracle Collection item representation.">OCI_Elem</a> *elem)
<a name="l00323"></a>00323 {
<a name="l00324"></a>00324     <span class="keywordtype">double</span> value = 0.0;
<a name="l00325"></a>00325     
<a name="l00326"></a>00326     OCI_CHECK_PTR(OCI_IPC_ELEMENT, elem, 0.0);
<a name="l00327"></a>00327 
<a name="l00328"></a>00328     OCI_ElemGetNumber(elem, (<span class="keywordtype">void</span> *) &amp;value, (uword) <span class="keyword">sizeof</span>(<span class="keywordtype">double</span>),
<a name="l00329"></a>00329                       (uword) OCI_NUM_DOUBLE);
<a name="l00330"></a>00330 
<a name="l00331"></a>00331     <span class="keywordflow">return</span> value;
<a name="l00332"></a>00332 }
<a name="l00333"></a>00333 
<a name="l00334"></a>00334 <span class="comment">/* ------------------------------------------------------------------------ *</span>
<a name="l00335"></a>00335 <span class="comment"> * OCI_ElemGetString</span>
<a name="l00336"></a>00336 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00337"></a>00337 
<a name="l00338"></a><a class="code" href="group__g__collection.html#g3f37f83b33c65908812643ef68f31db1">00338</a> <span class="keyword">const</span> dtext * OCI_API <a class="code" href="group__g__collection.html#g3f37f83b33c65908812643ef68f31db1" title="Return the String value of the given collection element.">OCI_ElemGetString</a>(<a class="code" href="struct_o_c_i___elem.html" title="Oracle Collection item representation.">OCI_Elem</a> *elem)
<a name="l00339"></a>00339 {
<a name="l00340"></a>00340     <span class="keyword">const</span> dtext *str  = NULL;
<a name="l00341"></a>00341     <span class="keywordtype">boolean</span> res       = FALSE;
<a name="l00342"></a>00342 
<a name="l00343"></a>00343     OCI_CHECK_PTR(OCI_IPC_ELEMENT, elem, NULL);
<a name="l00344"></a>00344 
<a name="l00345"></a>00345     <span class="keywordflow">if</span> (elem-&gt;<a class="code" href="struct_o_c_i___elem.html#c0d4f7331dec95693a62f16f58fd83b1">handle</a> != NULL)
<a name="l00346"></a>00346     {
<a name="l00347"></a>00347         res = TRUE;
<a name="l00348"></a>00348 
<a name="l00349"></a>00349         str = (dtext *) OCI_StringFromStringPtr(*(OCIString **) elem-&gt;<a class="code" href="struct_o_c_i___elem.html#c0d4f7331dec95693a62f16f58fd83b1">handle</a>,
<a name="l00350"></a>00350                                                 &amp;elem-&gt;<a class="code" href="struct_o_c_i___elem.html#bd308baff25c3f9e5682dd68b87b0ee5">buf</a>, &amp;elem-&gt;<a class="code" href="struct_o_c_i___elem.html#2bc3a1cd9899414c5ef4864367d4eac2">buflen</a>);
<a name="l00351"></a>00351     }
<a name="l00352"></a>00352 
<a name="l00353"></a>00353     OCI_RESULT(res);
<a name="l00354"></a>00354 
<a name="l00355"></a>00355     <span class="keywordflow">return</span> str;    
<a name="l00356"></a>00356 }
<a name="l00357"></a>00357 
<a name="l00358"></a>00358 
<a name="l00359"></a>00359 <span class="comment">/* ------------------------------------------------------------------------ *</span>
<a name="l00360"></a>00360 <span class="comment"> * OCI_ElemGetRaw</span>
<a name="l00361"></a>00361 <span class="comment"> * ------------------------------------------------------------------------ */</span>
<a name="l00362"></a>00362 
<a name="l00363"></a><a class="code" href="group__g__collection.html#gbe11c0476a8b0f2adda683fc12ad94fe">00363</a> <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> OCI_API <a class="code" href="group__g__collection.html#gbe11c0476a8b0f2adda683fc12ad94fe" title="Read the RAW value of the collection element into the given buffer.">OCI_ElemGetRaw</a>(<a class="code" href="struct_o_c_i___elem.html" title="Oracle Collection item representation.">OCI_Elem</a> *elem, <span class="keywordtype">void</span> *value, <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> len)