statement_8c-source.html

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

<a name="l00614"></a>00614                     <span class="keywordflow">break</span>;        
<a name="l00615"></a>00615                 }
<a name="l00616"></a>00616                 <span class="keywordflow">case</span> OCI_ARG_USHORT:
<a name="l00617"></a>00617                 {
<a name="l00618"></a>00618                    <span class="keywordtype">unsigned</span> <span class="keywordtype">short</span> src, *dst;
<a name="l00619"></a>00619 
<a name="l00620"></a>00620                     src = <a class="code" href="group__g__fetch.html#g4806cb6d6ead3a3ef04be924517aee1c" title="Return the current unsigned short value of the column at the given index in the resultset...">OCI_GetUnsignedShort</a>(rs, i);
<a name="l00621"></a>00621                     dst = va_arg(args, <span class="keywordtype">unsigned</span> <span class="keywordtype">short</span> *);
<a name="l00622"></a>00622                     
<a name="l00623"></a>00623                     <span class="keywordflow">if</span> (dst != NULL)
<a name="l00624"></a>00624                         *dst = src;
<a name="l00625"></a>00625 
<a name="l00626"></a>00626                     <span class="keywordflow">break</span>;        
<a name="l00627"></a>00627                 }
<a name="l00628"></a>00628                 <span class="keywordflow">case</span> OCI_ARG_INT:
<a name="l00629"></a>00629                 {
<a name="l00630"></a>00630                     <span class="keywordtype">int</span> src, *dst;
<a name="l00631"></a>00631 
<a name="l00632"></a>00632                     src = <a class="code" href="group__g__fetch.html#ga8d80dc30b2012eaddd13efa9dfb711d" title="Return the current integer value of the column at the given index in the resultset...">OCI_GetInt</a>(rs, i);
<a name="l00633"></a>00633                     dst = va_arg(args, <span class="keywordtype">int</span> *);
<a name="l00634"></a>00634                                     
<a name="l00635"></a>00635                     <span class="keywordflow">if</span> (dst != NULL)
<a name="l00636"></a>00636                         *dst = src;
<a name="l00637"></a>00637 
<a name="l00638"></a>00638                     <span class="keywordflow">break</span>;        
<a name="l00639"></a>00639                 }
<a name="l00640"></a>00640                 <span class="keywordflow">case</span> OCI_ARG_UINT:
<a name="l00641"></a>00641                 {
<a name="l00642"></a>00642                    <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> src, *dst;
<a name="l00643"></a>00643 
<a name="l00644"></a>00644                     src = <a class="code" href="group__g__fetch.html#g512a69f1856c612a2c2ee672d8e69dc6" title="Return the current unsigned integer value of the column at the given index in the...">OCI_GetUnsignedInt</a>(rs, i);
<a name="l00645"></a>00645                     dst = va_arg(args, <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span> *);
<a name="l00646"></a>00646                     
<a name="l00647"></a>00647                     <span class="keywordflow">if</span> (dst != NULL)
<a name="l00648"></a>00648                         *dst = src;
<a name="l00649"></a>00649 
<a name="l00650"></a>00650                     <span class="keywordflow">break</span>;        
<a name="l00651"></a>00651                 }
<a name="l00652"></a>00652                 <span class="keywordflow">case</span> OCI_ARG_BIGINT:
<a name="l00653"></a>00653                 {
<a name="l00654"></a>00654                     big_int src, *dst;
<a name="l00655"></a>00655 
<a name="l00656"></a>00656                     src = <a class="code" href="group__g__fetch.html#gbb1a223e75c676289d69c65b43d81b6a" title="Return the current big integer value of the column at the given index in the resultset...">OCI_GetBigInt</a>(rs, i);
<a name="l00657"></a>00657                     dst = va_arg(args, big_int *);
<a name="l00658"></a>00658                     
<a name="l00659"></a>00659                     <span class="keywordflow">if</span> (dst != NULL)
<a name="l00660"></a>00660                         *dst = src;
<a name="l00661"></a>00661 
<a name="l00662"></a>00662                     <span class="keywordflow">break</span>;        
<a name="l00663"></a>00663                 }
<a name="l00664"></a>00664                 <span class="keywordflow">case</span> OCI_ARG_BIGUINT:
<a name="l00665"></a>00665                 {
<a name="l00666"></a>00666                    big_uint src, *dst;
<a name="l00667"></a>00667 
<a name="l00668"></a>00668                     src = <a class="code" href="group__g__fetch.html#gefc3d8c3925c76c16cd1c4699e2ad9ef" title="Return the current unsigned big integer value of the column at the given index in...">OCI_GetUnsignedBigInt</a>(rs, i);
<a name="l00669"></a>00669                     dst = va_arg(args, big_uint *);
<a name="l00670"></a>00670                     
<a name="l00671"></a>00671                     <span class="keywordflow">if</span> (dst != NULL)
<a name="l00672"></a>00672                         *dst = src;
<a name="l00673"></a>00673 
<a name="l00674"></a>00674                     <span class="keywordflow">break</span>;        
<a name="l00675"></a>00675                 }
<a name="l00676"></a>00676                 <span class="keywordflow">case</span> OCI_ARG_DOUBLE:
<a name="l00677"></a>00677                 {
<a name="l00678"></a>00678                     <span class="keywordtype">double</span> src, *dst;
<a name="l00679"></a>00679 
<a name="l00680"></a>00680                     src = <a class="code" href="group__g__fetch.html#gdfbe8b6c23200810823e9ca6a1956cd7" title="Return the current double value of the column at the given index in the resultset...">OCI_GetDouble</a>(rs, i);
<a name="l00681"></a>00681                     dst = va_arg(args, <span class="keywordtype">double</span> *);
<a name="l00682"></a>00682                     
<a name="l00683"></a>00683                     <span class="keywordflow">if</span> (dst != NULL)
<a name="l00684"></a>00684                         *dst = src;
<a name="l00685"></a>00685 
<a name="l00686"></a>00686                     <span class="keywordflow">break</span>;
<a name="l00687"></a>00687                 }
<a name="l00688"></a>00688                 <span class="keywordflow">case</span> OCI_ARG_DATETIME:
<a name="l00689"></a>00689                 {
<a name="l00690"></a>00690                     <a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *src, *dst;
<a name="l00691"></a>00691 
<a name="l00692"></a>00692                     src = <a class="code" href="group__g__fetch.html#g1ad37dce6d6e900e98d39b2b2e0f5022" title="Return the current date value of the column at the given index in the resultset.">OCI_GetDate</a>(rs, i);
<a name="l00693"></a>00693                     dst = (<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *) va_arg(args, <a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *);
<a name="l00694"></a>00694 
<a name="l00695"></a>00695                     <span class="keywordflow">if</span> (src != NULL &amp;&amp; dst != NULL)
<a name="l00696"></a>00696                         res = <a class="code" href="group__g__date.html#gd66b48f587f3bc30b1db8cd4cb892847" title="Assign the value of a date handle to another one.">OCI_DateAssign</a>(dst, src);
<a name="l00697"></a>00697 
<a name="l00698"></a>00698                     <span class="keywordflow">break</span>;
<a name="l00699"></a>00699                 }
<a name="l00700"></a>00700                 <span class="keywordflow">case</span> OCI_ARG_TEXT:
<a name="l00701"></a>00701                 {
<a name="l00702"></a>00702                     <span class="keyword">const</span> dtext *src;
<a name="l00703"></a>00703                     dtext *dst;
<a name="l00704"></a>00704 
<a name="l00705"></a>00705                     src = <a class="code" href="group__g__fetch.html#g755a9b07c174feacd05c86e0e44b0ab0" title="Return the current string value of the column at the given index in the resultset...">OCI_GetString</a>(rs, i);
<a name="l00706"></a>00706                     dst = va_arg(args, dtext *);
<a name="l00707"></a>00707                     
<a name="l00708"></a>00708                     <span class="keywordflow">if</span> (dst != NULL)
<a name="l00709"></a>00709                         dst[0] = 0;
<a name="l00710"></a>00710 
<a name="l00711"></a>00711                     <span class="keywordflow">if</span> (dst != NULL &amp;&amp; src != NULL)
<a name="l00712"></a>00712                         dtscat(dst, src);
<a name="l00713"></a>00713 
<a name="l00714"></a>00714                     <span class="keywordflow">break</span>;
<a name="l00715"></a>00715                 }
<a name="l00716"></a>00716                 <span class="keywordflow">case</span> OCI_ARG_RAW:
<a name="l00717"></a>00717                 {
<a name="l00718"></a>00718                     <a class="code" href="group__g__fetch.html#gd81efb112147c18b376c9524c91ecd28" title="Copy the current raw value of the column at the given index into the specified buffer...">OCI_GetRaw</a>(rs, i, va_arg(args, dtext *), col-&gt;<a class="code" href="struct_o_c_i___column.html#e0216bd7ecc0517de0fa5dc56980bf1e">bufsize</a>);
<a name="l00719"></a>00719                     <span class="keywordflow">break</span>;
<a name="l00720"></a>00720                 }
<a name="l00721"></a>00721                 <span class="keywordflow">case</span> OCI_ARG_LOB:
<a name="l00722"></a>00722                 {
<a name="l00723"></a>00723                     <a class="code" href="struct_o_c_i___lob.html" title="Oracle Internal Large objects :.">OCI_Lob</a> *src, *dst;
<a name="l00724"></a>00724 
<a name="l00725"></a>00725                     src = <a class="code" href="group__g__fetch.html#gbac23a7dea02963ef8de438950ef6fae" title="Return the current lob value of the column at the given index in the resultset.">OCI_GetLob</a>(rs, i);
<a name="l00726"></a>00726                     dst = (<a class="code" href="struct_o_c_i___lob.html" title="Oracle Internal Large objects :.">OCI_Lob</a> *) va_arg(args, <a class="code" href="struct_o_c_i___lob.html" title="Oracle Internal Large objects :.">OCI_Lob</a> *);
<a name="l00727"></a>00727 
<a name="l00728"></a>00728                     <span class="keywordflow">if</span> (src != NULL &amp;&amp; dst != NULL)
<a name="l00729"></a>00729                         res = <a class="code" href="group__g__lob.html#g30c335eb342272b308eb3746e5b4ea75" title="Assign a lob to another one.">OCI_LobAssign</a>(dst, src);
<a name="l00730"></a>00730 
<a name="l00731"></a>00731                     <span class="keywordflow">break</span>;
<a name="l00732"></a>00732                 }
<a name="l00733"></a>00733                 <span class="keywordflow">case</span> OCI_ARG_FILE:
<a name="l00734"></a>00734                 {
<a name="l00735"></a>00735                     <a class="code" href="struct_o_c_i___file.html" title="Oracle External Large objects :.">OCI_File</a> *src, *dst;
<a name="l00736"></a>00736 
<a name="l00737"></a>00737                     src = <a class="code" href="group__g__fetch.html#g1f4362d4f0ad420ebfaeafca29670d77" title="Return the current File value of the column at the given index in the resultset.">OCI_GetFile</a>(rs, i);
<a name="l00738"></a>00738                     dst = (<a class="code" href="struct_o_c_i___file.html" title="Oracle External Large objects :.">OCI_File</a> *) va_arg(args, <a class="code" href="struct_o_c_i___file.html" title="Oracle External Large objects :.">OCI_File</a> *);
<a name="l00739"></a>00739 
<a name="l00740"></a>00740                     <span class="keywordflow">if</span> (src != NULL &amp;&amp; dst != NULL)
<a name="l00741"></a>00741                         res = <a class="code" href="group__g__file.html#g2a37633ddf3d9c22575a85cee7b75f42" title="Assign a file to another one.">OCI_FileAssign</a>(dst, src);
<a name="l00742"></a>00742 
<a name="l00743"></a>00743                     <span class="keywordflow">break</span>;
<a name="l00744"></a>00744                 }
<a name="l00745"></a>00745                 <span class="keywordflow">case</span> OCI_ARG_TIMESTAMP:
<a name="l00746"></a>00746                 {
<a name="l00747"></a>00747                     <a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timespamp representation.">OCI_Timestamp</a> *src, *dst;
<a name="l00748"></a>00748 
<a name="l00749"></a>00749                     src = <a class="code" href="group__g__fetch.html#gac76cbb23c018511ed3889faa859e52a" title="Return the current timestamp value of the column at the given index in the resultset...">OCI_GetTimestamp</a>(rs, i);
<a name="l00750"></a>00750                     dst = (<a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timespamp representation.">OCI_Timestamp</a> *) va_arg(args, <a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timespamp representation.">OCI_Timestamp</a> *);
<a name="l00751"></a>00751 
<a name="l00752"></a>00752                     <span class="keywordflow">if</span> (src != NULL &amp;&amp; dst != NULL)
<a name="l00753"></a>00753                         res = <a class="code" href="group__g__timestamp.html#g6b8356c2fcaa984d2d63edd5cc7a357b" title="Assign the value of a timestamp handle to another one.">OCI_TimestampAssign</a>(dst, src);
<a name="l00754"></a>00754 
<a name="l00755"></a>00755                     <span class="keywordflow">break</span>;
<a name="l00756"></a>00756                 }
<a name="l00757"></a>00757                 <span class="keywordflow">case</span> OCI_ARG_INTERVAL:
<a name="l00758"></a>00758                 {
<a name="l00759"></a>00759                     <a class="code" href="struct_o_c_i___interval.html" title="Oracle internal interval representation.">OCI_Interval</a> *src, *dst;
<a name="l00760"></a>00760 
<a name="l00761"></a>00761                     src = <a class="code" href="group__g__fetch.html#g58c53573e5c67e8a4cf29a9cb9ead209" title="Return the current interval value of the column at the given index in the resultset...">OCI_GetInterval</a>(rs, i);
<a name="l00762"></a>00762                     dst = (<a class="code" href="struct_o_c_i___interval.html" title="Oracle internal interval representation.">OCI_Interval</a> *) va_arg(args, <a class="code" href="struct_o_c_i___interval.html" title="Oracle internal interval representation.">OCI_Interval</a> *);
<a name="l00763"></a>00763 
<a name="l00764"></a>00764                     <span class="keywordflow">if</span> (src != NULL &amp;&amp; dst != NULL)
<a name="l00765"></a>00765                         res =<a class="code" href="group__g__timestamp.html#g479e6e2db5d78dee2b396190c577019a" title="Assign the value of a interval handle to another one.">OCI_IntervalAssign</a>(dst, src);
<a name="l00766"></a>00766 
<a name="l00767"></a>00767                     <span class="keywordflow">break</span>;
<a name="l00768"></a>00768                 }