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

📄 timestamp_8c-source.html

📁 ORACLE编程的好东西,纯C写的OCI封装.很好用,支持数据池.
💻 HTML
📖 第 1 页 / 共 5 页
字号:
<a name="l00278"></a>00278         OCIDateTimeCompare((dvoid *) OCILib.env, tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#a63a28fecaeb556596429ac636329b22">err</a>,<a name="l00279"></a>00279                             tmsp2-&gt;<a class="code" href="struct_o_c_i___timestamp.html#fc374755147e6be3141d875fdad3cf8a">handle</a>, tmsp2-&gt;<a class="code" href="struct_o_c_i___timestamp.html#fc374755147e6be3141d875fdad3cf8a">handle</a>, &amp;value)<a name="l00280"></a>00280     )<a name="l00281"></a>00281 <a name="l00282"></a>00282 <span class="preprocessor">#endif</span><a name="l00283"></a>00283 <span class="preprocessor"></span><a name="l00284"></a>00284     OCI_RESULT(res);<a name="l00285"></a>00285 <a name="l00286"></a>00286     <span class="keywordflow">return</span> (<span class="keywordtype">int</span>) value;<a name="l00287"></a>00287 }<a name="l00288"></a>00288 <a name="l00289"></a>00289 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00290"></a>00290 <span class="comment"> * OCI_TimestampConstruct</span><a name="l00291"></a>00291 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00292"></a>00292 <a name="l00293"></a><a class="code" href="group__g__timestamp.html#gc159b440ab075cd969f2e6d3589a9fa4">00293</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__timestamp.html#gc159b440ab075cd969f2e6d3589a9fa4" title="Set a timestamp handle value.">OCI_TimestampConstruct</a>(<a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timespamp representation.">OCI_Timestamp</a> *tmsp, <span class="keywordtype">int</span> year,<span class="keywordtype">int</span> month,<a name="l00294"></a>00294                                       <span class="keywordtype">int</span> day, <span class="keywordtype">int</span> hour,  <span class="keywordtype">int</span> min, <span class="keywordtype">int</span> sec,<a name="l00295"></a>00295                                       <span class="keywordtype">int</span> fsec, <span class="keyword">const</span> mtext *timezone)<a name="l00296"></a>00296 {<a name="l00297"></a>00297     <span class="keywordtype">boolean</span> res = TRUE;<a name="l00298"></a>00298 <a name="l00299"></a>00299     OCI_CHECK_PTR(OCI_IPC_TIMESTAMP, tmsp, FALSE);<a name="l00300"></a>00300 <a name="l00301"></a>00301     OCI_CHECK_TIMESTAMP_ENABLED(tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#8d58d5aabe4cf9100bfdfc8428fbc234">con</a>, FALSE);<a name="l00302"></a>00302 <a name="l00303"></a>00303 <span class="preprocessor">#if OCI_VERSION_COMPILE &gt;= OCI_9</span><a name="l00304"></a>00304 <span class="preprocessor"></span><a name="l00305"></a>00305     OCI_CALL4<a name="l00306"></a>00306     (<a name="l00307"></a>00307         res, tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#a63a28fecaeb556596429ac636329b22">err</a>, tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#8d58d5aabe4cf9100bfdfc8428fbc234">con</a>,<a name="l00308"></a>00308         <a name="l00309"></a>00309         OCIDateTimeConstruct((dvoid *) OCILib.env, tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#a63a28fecaeb556596429ac636329b22">err</a>,<a name="l00310"></a>00310                                          tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#fc374755147e6be3141d875fdad3cf8a">handle</a>,<a name="l00311"></a>00311                                          (sb2) year, (ub1) month, (ub1) day,<a name="l00312"></a>00312                                          (ub1) hour, (ub1) min,(ub1) sec,<a name="l00313"></a>00313                                          (ub4) fsec, (OraText *) timezone,<a name="l00314"></a>00314                                          (<span class="keywordtype">size_t</span>) (timezone ? mtextsize(timezone) : 0))<a name="l00315"></a>00315     )<a name="l00316"></a>00316 <a name="l00317"></a>00317 <span class="preprocessor">#else</span><a name="l00318"></a>00318 <span class="preprocessor"></span><a name="l00319"></a>00319     OCI_NOT_USED(year);<a name="l00320"></a>00320     OCI_NOT_USED(month);<a name="l00321"></a>00321     OCI_NOT_USED(day);<a name="l00322"></a>00322     OCI_NOT_USED(hour);<a name="l00323"></a>00323     OCI_NOT_USED(min);<a name="l00324"></a>00324     OCI_NOT_USED(sec);<a name="l00325"></a>00325     OCI_NOT_USED(fsec);<a name="l00326"></a>00326     OCI_NOT_USED(timezone);<a name="l00327"></a>00327 <a name="l00328"></a>00328 <span class="preprocessor">#endif</span><a name="l00329"></a>00329 <span class="preprocessor"></span><a name="l00330"></a>00330    OCI_RESULT(res);<a name="l00331"></a>00331 <a name="l00332"></a>00332    <span class="keywordflow">return</span> res;<a name="l00333"></a>00333 }<a name="l00334"></a>00334 <a name="l00335"></a>00335 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00336"></a>00336 <span class="comment"> * OCI_TimestampConvert</span><a name="l00337"></a>00337 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00338"></a>00338 <a name="l00339"></a><a class="code" href="group__g__timestamp.html#g40864de524cc390bd3b33ce722992cca">00339</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__timestamp.html#g40864de524cc390bd3b33ce722992cca" title="Convert one timestamp value from one type to another.">OCI_TimestampConvert</a>(<a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timespamp representation.">OCI_Timestamp</a> *tmsp, <a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timespamp representation.">OCI_Timestamp</a> *tmsp2)<a name="l00340"></a>00340 {<a name="l00341"></a>00341     <span class="keywordtype">boolean</span> res = TRUE;<a name="l00342"></a>00342 <a name="l00343"></a>00343     OCI_CHECK_PTR(OCI_IPC_TIMESTAMP, tmsp,  FALSE);<a name="l00344"></a>00344     OCI_CHECK_PTR(OCI_IPC_TIMESTAMP, tmsp2, FALSE);<a name="l00345"></a>00345 <a name="l00346"></a>00346     OCI_CHECK_TIMESTAMP_ENABLED(tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#8d58d5aabe4cf9100bfdfc8428fbc234">con</a>, FALSE);<a name="l00347"></a>00347 <a name="l00348"></a>00348 <span class="preprocessor">#if OCI_VERSION_COMPILE &gt;= OCI_9</span><a name="l00349"></a>00349 <span class="preprocessor"></span><a name="l00350"></a>00350     OCI_CALL4<a name="l00351"></a>00351     (<a name="l00352"></a>00352         res, tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#a63a28fecaeb556596429ac636329b22">err</a>, tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#8d58d5aabe4cf9100bfdfc8428fbc234">con</a>,<a name="l00353"></a>00353         <a name="l00354"></a>00354         OCIDateTimeConvert((dvoid *) OCILib.env, tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#a63a28fecaeb556596429ac636329b22">err</a>,<a name="l00355"></a>00355                            tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#fc374755147e6be3141d875fdad3cf8a">handle</a>, tmsp2-&gt;<a class="code" href="struct_o_c_i___timestamp.html#fc374755147e6be3141d875fdad3cf8a">handle</a>)<a name="l00356"></a>00356     )<a name="l00357"></a>00357 <a name="l00358"></a>00358 <span class="preprocessor">#endif</span><a name="l00359"></a>00359 <span class="preprocessor"></span><a name="l00360"></a>00360    OCI_RESULT(res);<a name="l00361"></a>00361 <a name="l00362"></a>00362    <span class="keywordflow">return</span> res;<a name="l00363"></a>00363 }<a name="l00364"></a>00364 <a name="l00365"></a>00365 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00366"></a>00366 <span class="comment"> * OCI_TimestampFromText</span><a name="l00367"></a>00367 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00368"></a>00368 <a name="l00369"></a><a class="code" href="group__g__timestamp.html#gcd23e54055e335c4d04a165ab6858d92">00369</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__timestamp.html#gcd23e54055e335c4d04a165ab6858d92" title="Convert a string to a timestamp and store it in the given timestamp handle.">OCI_TimestampFromText</a>(<a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timespamp representation.">OCI_Timestamp</a> *tmsp, <span class="keyword">const</span> mtext *str, <a name="l00370"></a>00370                                       <span class="keyword">const</span> mtext *fmt)<a name="l00371"></a>00371 {<a name="l00372"></a>00372     <span class="keywordtype">boolean</span> res = TRUE;<a name="l00373"></a>00373     <span class="keywordtype">void</span> *ostr1 = NULL;<a name="l00374"></a>00374     <span class="keywordtype">void</span> *ostr2 = NULL;<a name="l00375"></a>00375     <span class="keywordtype">int</span>  osize1 = -1;<a name="l00376"></a>00376     <span class="keywordtype">int</span>  osize2 = -1;<a name="l00377"></a>00377 <a name="l00378"></a>00378     OCI_CHECK_PTR(OCI_IPC_TIMESTAMP, tmsp, FALSE);<a name="l00379"></a>00379     OCI_CHECK_PTR(OCI_IPC_STRING, str,  FALSE);<a name="l00380"></a>00380     OCI_CHECK_PTR(OCI_IPC_STRING, fmt,  FALSE);<a name="l00381"></a>00381 <a name="l00382"></a>00382     OCI_CHECK_TIMESTAMP_ENABLED(tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#8d58d5aabe4cf9100bfdfc8428fbc234">con</a>, FALSE);<a name="l00383"></a>00383 <a name="l00384"></a>00384 <span class="preprocessor">#if OCI_VERSION_COMPILE &gt;= OCI_9</span><a name="l00385"></a>00385 <span class="preprocessor"></span><a name="l00386"></a>00386     ostr1 = OCI_GetInputMetaString(str, &amp;osize1);<a name="l00387"></a>00387     ostr2 = OCI_GetInputMetaString(fmt, &amp;osize2);<a name="l00388"></a>00388 <a name="l00389"></a>00389     OCI_CALL4<a name="l00390"></a>00390     (<a name="l00391"></a>00391         res, tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#a63a28fecaeb556596429ac636329b22">err</a>, tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#8d58d5aabe4cf9100bfdfc8428fbc234">con</a>,<a name="l00392"></a>00392         <a name="l00393"></a>00393         OCIDateTimeFromText((dvoid *) OCILib.env, tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#a63a28fecaeb556596429ac636329b22">err</a>,<a name="l00394"></a>00394                             (OraText *) ostr1, (<span class="keywordtype">size_t</span>) osize1,<a name="l00395"></a>00395                             (OraText *) ostr2, (ub1) osize2,<a name="l00396"></a>00396                             (OraText *) NULL, (<span class="keywordtype">size_t</span>) 0, <a name="l00397"></a>00397                             tmsp-&gt;<a class="code" href="struct_o_c_i___timestamp.html#fc374755147e6be3141d875fdad3cf8a">handle</a>)<a name="l00398"></a>00398     )<a name="l00399"></a>00399 <a name="l00400"></a>00400     OCI_ReleaseMetaString(ostr1);<a name="l00401"></a>00401     OCI_ReleaseMetaString(ostr2);<a name="l00402"></a>00402 <a name="l00403"></a>00403 <span class="preprocessor">#else</span><a name="l00404"></a>00404 <span class="preprocessor"></span><a name="l00405"></a>00405     OCI_NOT_USED(ostr1);<a name="l00406"></a>00406     OCI_NOT_USED(ostr2);<a name="l00407"></a>00407     OCI_NOT_USED(osize1);<a name="l00408"></a>00408     OCI_NOT_USED(osize2);<a name="l00409"></a>00409 <a name="l00410"></a>00410 <span class="preprocessor">#endif</span><a name="l00411"></a>00411 <span class="preprocessor"></span><a name="l00412"></a>00412    OCI_RESULT(res);<a name="l00413"></a>00413 <a name="l00414"></a>00414    <span class="keywordflow">return</span> res;<a name="l00415"></a>00415 }<a name="l00416"></a>00416 <a name="l00417"></a>00417 <span class="comment">/* ------------------------------------------------------------------------ *</span><a name="l00418"></a>00418 <span class="comment"> * OCI_TimestampToText</span><a name="l00419"></a>00419 <span class="comment"> * ------------------------------------------------------------------------ */</span><a name="l00420"></a>00420 <a name="l00421"></a><a class="code" href="group__g__timestamp.html#gb737b5a0c898dde2381fd095dd4e2b65">00421</a> <span class="keywordtype">boolean</span> OCI_API <a class="code" href="group__g__timestamp.html#gb737b5a0c898dde2381fd095dd4e2b65" title="Convert a timestamp value from the given timestamp handle to a string.">OCI_TimestampToText</a>(<a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timespamp representation.">OCI_Timestamp</a> *tmsp, <span class="keyword">const</span> mtext *fmt, <a name="l00422"></a>00422                                     <span class="keywordtype">int</span> size, mtext *str, <span class="keywordtype">int</span> precision)<a name="l00423"></a>00423 {

⌨️ 快捷键说明

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