?? oradate.cpp
字號:
#define __OCICPP_INTERNAL_USE_#include "OraDate.h"#include "OraError.h"
#include <stdio.h>
#include "OraError.h"
#include <stdio.h>
/*! \class OCICPP::OraDate \brief Client-side representation of date cells within the Oracle server */OCICPP::OraDate::OraDate(OCIEnv *envhp,OCIError *errhp,OCIParam *param,ub2 type,int rows) : OraType(envhp,errhp,param,type,rows) { ReqType=SQLT_DAT; size=10; /* DD-MM-YYYY */ date=(char *)calloc(7*nRows,sizeof(char));}OCICPP::OraDate::~OraDate() { free(date); OCIHandleFree(definehp,OCI_HTYPE_DEFINE);}void OCICPP::OraDate::define(OCIStmt *stmt,int col) { CHECKERR(err, OCIDefineByPos(stmt, &definehp, err, col+1, date, 7,ReqType, (dvoid *) null, 0, (ub2 *)0, OCI_DEFAULT)); }void OCICPP::OraDate::getStr(std::string &str,int row) { char buf[12]; char *month[]={"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"}; unsigned char cc,yy,mm,dd,hh,mi,ss; cc=(date+7*row)[0]; /* Century */ yy=(date+7*row)[1]; /* Year */ mm=(date+7*row)[2]; /* Month */ dd=(date+7*row)[3]; /* Day */ hh=(date+7*row)[4]-1; /* Hour */ mi=(date+7*row)[5]-1; /* Minute */ ss=(date+7*row)[6]-1; /* Seconds */ cc=(unsigned char)abs(cc-100); yy=(unsigned char)abs(yy-100); sprintf(buf,"%d-%s-%d",dd,month[mm-1],(unsigned int)cc*100+(unsigned int)yy); str.assign(buf);}void OCICPP::OraDate::getStrMon(std::string &mon,int row) { char *month[]={"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"}; unsigned char mm=(date+7*row)[2]; /* Month */ mon.assign(month[mm]);}void OCICPP::OraDate::getSec(int &sec,int row) { sec=(int) (date+7*row)[6]-1;}void OCICPP::OraDate::getMin(int &min,int row) { min=(int) (date+7*row)[5]-1;}void OCICPP::OraDate::getHour(int &hour,int row) { hour=(int) (date+7*row)[4]-1;}void OCICPP::OraDate::getDay(int &day,int row) { day=(int) (date+7*row)[3];}void OCICPP::OraDate::getMonth(int &mon,int row) { mon=(int) (date+7*row)[2];}void OCICPP::OraDate::getYear(int &year,int row) { unsigned char yy,cc; yy=(date+7*row)[1]; cc=(date+7*row)[0]; yy=(unsigned char)abs(yy-100); cc=(unsigned char)abs(cc-100); year=(int)cc*100+(int)yy;}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -