⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 date_8c-source.html

📁 ORACLE编程的好东西,纯C写的OCI封装.很好用,支持数据池.
💻 HTML
📖 第 1 页 / 共 4 页
字号:
<a name="l00153"></a>00153     OCI_FREE(date);<a name="l00154"></a>00154 <a name="l00155"></a>00155     OCI_RESULT(TRUE);<a name="l00156"></a>00156 <a name="l00157"></a>00157     <span class="keywordflow">return</span> TRUE;<a name="l00158"></a>00158 }<a name="l00159"></a>00159 <a name="l00160"></a>00160 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00161"></a>00161 <span class="comment"> * OCI_DateAddDays</span><a name="l00162"></a>00162 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00163"></a>00163 <a name="l00164"></a><a class="code" href="group__g__date.html#g7f446c4dc922920c36601770e3d9d7d1">00164</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__date.html#g7f446c4dc922920c36601770e3d9d7d1" title="Add or subtract days to a date handle.">OCI_DateAddDays</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date, <span class="keywordtype">int</span> nb)<a name="l00165"></a>00165 {<a name="l00166"></a>00166     <span class="keywordtype">boolean</span> res = TRUE;<a name="l00167"></a>00167 <a name="l00168"></a>00168     OCI_CHECK_PTR(OCI_IPC_DATE, date, FALSE);<a name="l00169"></a>00169 <a name="l00170"></a>00170     OCI_CALL4<a name="l00171"></a>00171     (<a name="l00172"></a>00172         res, date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#cdf61527146141228ec10ba1e2464f2f">con</a>,<a name="l00173"></a>00173         <a name="l00174"></a>00174         OCIDateAddDays(date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, (sb4) nb, date-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>)<a name="l00175"></a>00175     )<a name="l00176"></a>00176 <a name="l00177"></a>00177     OCI_RESULT(res);<a name="l00178"></a>00178 <a name="l00179"></a>00179     <span class="keywordflow">return</span> res;<a name="l00180"></a>00180 }<a name="l00181"></a>00181 <a name="l00182"></a>00182 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00183"></a>00183 <span class="comment"> * OCI_DateAddMonths</span><a name="l00184"></a>00184 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00185"></a>00185 <a name="l00186"></a><a class="code" href="group__g__date.html#ga405c4bb8c705ce2dd03b51bba1ef303">00186</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__date.html#ga405c4bb8c705ce2dd03b51bba1ef303" title="Add or subtract months to a date handle.">OCI_DateAddMonths</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date, <span class="keywordtype">int</span> nb)<a name="l00187"></a>00187 {<a name="l00188"></a>00188     <span class="keywordtype">boolean</span> res = TRUE;<a name="l00189"></a>00189 <a name="l00190"></a>00190     OCI_CHECK_PTR(OCI_IPC_DATE, date, FALSE);<a name="l00191"></a>00191 <a name="l00192"></a>00192     OCI_CALL4<a name="l00193"></a>00193     (<a name="l00194"></a>00194         res, date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#cdf61527146141228ec10ba1e2464f2f">con</a>,<a name="l00195"></a>00195         <a name="l00196"></a>00196         OCIDateAddMonths(date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, (sb4) nb, date-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>)<a name="l00197"></a>00197     )<a name="l00198"></a>00198 <a name="l00199"></a>00199     OCI_RESULT(res);<a name="l00200"></a>00200 <a name="l00201"></a>00201     <span class="keywordflow">return</span> res;<a name="l00202"></a>00202 }<a name="l00203"></a>00203 <a name="l00204"></a>00204 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00205"></a>00205 <span class="comment"> * OCI_DateAssign</span><a name="l00206"></a>00206 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00207"></a>00207 <a name="l00208"></a><a class="code" href="group__g__date.html#gd66b48f587f3bc30b1db8cd4cb892847">00208</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__date.html#gd66b48f587f3bc30b1db8cd4cb892847" title="Assign the value of a date handle to another one.">OCI_DateAssign</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date, <a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date_src)<a name="l00209"></a>00209 {<a name="l00210"></a>00210     <span class="keywordtype">boolean</span> res = TRUE;<a name="l00211"></a>00211 <a name="l00212"></a>00212     OCI_CHECK_PTR(OCI_IPC_DATE, date,     FALSE);<a name="l00213"></a>00213     OCI_CHECK_PTR(OCI_IPC_DATE, date_src, FALSE);<a name="l00214"></a>00214 <a name="l00215"></a>00215     OCI_CALL4<a name="l00216"></a>00216     (<a name="l00217"></a>00217         res, date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#cdf61527146141228ec10ba1e2464f2f">con</a>, <a name="l00218"></a>00218 <a name="l00219"></a>00219         OCIDateAssign(date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date_src-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>)<a name="l00220"></a>00220     )<a name="l00221"></a>00221 <a name="l00222"></a>00222     OCI_RESULT(res);<a name="l00223"></a>00223 <a name="l00224"></a>00224     <span class="keywordflow">return</span> res;<a name="l00225"></a>00225 }<a name="l00226"></a>00226 <a name="l00227"></a>00227 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00228"></a>00228 <span class="comment"> * OCI_DateCheck</span><a name="l00229"></a>00229 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00230"></a>00230 <a name="l00231"></a><a class="code" href="group__g__date.html#gec864d9e80d658f402e8f08c829feead">00231</a> <span class="keywordtype">int</span> OCI_API <a class="code" href="group__g__date.html#gec864d9e80d658f402e8f08c829feead" title="Check if the given date is valid.">OCI_DateCheck</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date)<a name="l00232"></a>00232 {<a name="l00233"></a>00233     <span class="keywordtype">boolean</span> res = TRUE;<a name="l00234"></a>00234     uword valid = 0;<a name="l00235"></a>00235 <a name="l00236"></a>00236     OCI_CHECK_PTR(OCI_IPC_DATE, date, OCI_ERROR);<a name="l00237"></a>00237 <a name="l00238"></a>00238     OCI_CALL4<a name="l00239"></a>00239     (<a name="l00240"></a>00240         res, date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#cdf61527146141228ec10ba1e2464f2f">con</a>, <a name="l00241"></a>00241         <a name="l00242"></a>00242         OCIDateCheck(date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, &amp;valid)<a name="l00243"></a>00243     )<a name="l00244"></a>00244 <a name="l00245"></a>00245     OCI_RESULT(res);<a name="l00246"></a>00246 <a name="l00247"></a>00247     <span class="keywordflow">return</span> (<span class="keywordtype">int</span>) valid;<a name="l00248"></a>00248 }<a name="l00249"></a>00249 <a name="l00250"></a>00250 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00251"></a>00251 <span class="comment"> * OCI_DateCompare</span><a name="l00252"></a>00252 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00253"></a>00253 <a name="l00254"></a><a class="code" href="group__g__date.html#g5c85213e0dc63565c0e5d8151a480010">00254</a> <span class="keywordtype">int</span> OCI_API <a class="code" href="group__g__date.html#g5c85213e0dc63565c0e5d8151a480010" title="Compares two date handles.">OCI_DateCompare</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date, <a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date2)<a name="l00255"></a>00255 {<a name="l00256"></a>00256     <span class="keywordtype">boolean</span> res = TRUE;<a name="l00257"></a>00257     sword value = -1;<a name="l00258"></a>00258 <a name="l00259"></a>00259     OCI_CHECK_PTR(OCI_IPC_DATE, date, -1);<a name="l00260"></a>00260 <a name="l00261"></a>00261     OCI_CALL4<a name="l00262"></a>00262     (<a name="l00263"></a>00263         res, date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#cdf61527146141228ec10ba1e2464f2f">con</a>,<a name="l00264"></a>00264         <a name="l00265"></a>00265         OCIDateCompare(date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, date2-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, &amp;value)<a name="l00266"></a>00266     )<a name="l00267"></a>00267 <a name="l00268"></a>00268     OCI_RESULT(res);<a name="l00269"></a>00269 <a name="l00270"></a>00270     <span class="keywordflow">return</span> (<span class="keywordtype">int</span>) value;<a name="l00271"></a>00271 }<a name="l00272"></a>00272 <a name="l00273"></a>00273 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00274"></a>00274 <span class="comment"> * OCI_DateDaysBetween</span><a name="l00275"></a>00275 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00276"></a>00276 <a name="l00277"></a><a class="code" href="group__g__date.html#gfa9f51e0977278bc43dafdef13d7fb5e">00277</a> <span class="keywordtype">int</span> OCI_API <a class="code" href="group__g__date.html#gfa9f51e0977278bc43dafdef13d7fb5e" title="Return the number of days betWeen two dates.">OCI_DateDaysBetween</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date, <a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date2)<a name="l00278"></a>00278 {<a name="l00279"></a>00279     <span class="keywordtype">boolean</span> res = TRUE;<a name="l00280"></a>00280     sb4 nb      = 0;<a name="l00281"></a>00281 <a name="l00282"></a>00282     OCI_CHECK_PTR(OCI_IPC_DATE, date,  OCI_ERROR);<a name="l00283"></a>00283     OCI_CHECK_PTR(OCI_IPC_DATE, date2, OCI_ERROR);<a name="l00284"></a>00284 <a name="l00285"></a>00285     OCI_CALL4<a name="l00286"></a>00286     (<a name="l00287"></a>00287         res, date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#cdf61527146141228ec10ba1e2464f2f">con</a>, <a name="l00288"></a>00288         <a name="l00289"></a>00289         OCIDateDaysBetween(date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, date2-&gt;<a class="code" href="struct_o_c_i___date.html#681a98f7d9313d572b3618044e2e4650">handle</a>, &amp;nb)<a name="l00290"></a>00290     )<a name="l00291"></a>00291 <a name="l00292"></a>00292     OCI_RESULT(res);<a name="l00293"></a>00293 <a name="l00294"></a>00294     <span class="keywordflow">return</span> (sb4) nb;<a name="l00295"></a>00295 }<a name="l00296"></a>00296 <a name="l00297"></a>00297 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00298"></a>00298 <span class="comment"> * OCI_DateFromText</span><a name="l00299"></a>00299 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00300"></a>00300 <a name="l00301"></a><a class="code" href="group__g__date.html#ge0a2778f7c5646df7ea8748d7683b76b">00301</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__date.html#ge0a2778f7c5646df7ea8748d7683b76b" title="Convert a string to a date and store it in the given date handle.">OCI_DateFromText</a>(<a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> *date, <span class="keyword">const</span> mtext *str, <a name="l00302"></a>00302                                  <span class="keyword">const</span> mtext *fmt)<a name="l00303"></a>00303 {<a name="l00304"></a>00304     <span class="keywordtype">void</span> *ostr1 = NULL;<a name="l00305"></a>00305     <span class="keywordtype">void</span> *ostr2 = NULL;<a name="l00306"></a>00306     <span class="keywordtype">int</span>  osize1 = -1;<a name="l00307"></a>00307     <span class="keywordtype">int</span>  osize2 = -1;<a name="l00308"></a>00308     <span class="keywordtype">boolean</span> res = TRUE;<a name="l00309"></a>00309 <a name="l00310"></a>00310     OCI_CHECK_PTR(OCI_IPC_DATE, date, FALSE);<a name="l00311"></a>00311     OCI_CHECK_PTR(OCI_IPC_STRING, str,  FALSE);<a name="l00312"></a>00312     OCI_CHECK_PTR(OCI_IPC_STRING, fmt,  FALSE);<a name="l00313"></a>00313 <a name="l00314"></a>00314     ostr1 = OCI_GetInputMetaString(str, &amp;osize1);<a name="l00315"></a>00315     ostr2 = OCI_GetInputMetaString(fmt, &amp;osize2);<a name="l00316"></a>00316 <a name="l00317"></a>00317     OCI_CALL4<a name="l00318"></a>00318     (<a name="l00319"></a>00319         res, date-&gt;<a class="code" href="struct_o_c_i___date.html#0e7756684f19d1780037f8ff3d525ae3">err</a>, date-&gt;<a class="code" href="struct_o_c_i___date.html#cdf61527146141228ec10ba1e2464f2f">con</a>,

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -