oracle变量绑定代码,关于oracle 绑定变量在c++中的实现方式

stream << "insert into CM_UD_ROUTE (o_station_acccode, d_station_acccode, trip

_route, ";

stream << " sacccode_arr_dep, entry_time, exit_time, source_participant_id, se

ttlement_date, ";

stream << " card_serial_number, product_type, version_sn, od_route_sn, DIAGRAM

NUM_SN, SWITCH_ROUTE_ACCCODE, WAIT_TIME, WAIT_NUMBER ) ";

stream << " values(:OACCCODE, :DACCCODE, :TRIP, :SACCCODE, ";

if(strlen(trip->o_time) == 6)

stream << " TO_DATE(:ENTRYTIME, 'hh24miss'), TO_DATE(:EXITTIME, 'hh24miss'

), ";

else

stream << " TO_DATE(:ENTRYTIME, 'YYYYMMDDhh24miss'), TO_DATE(:EXITTIME, 'Y

YYYMMDDhh24miss'), ";

stream << " :PARTICIPANT_ID, TO_DATE(:SETTLEMENTDATE, 'YYYYMMDD'), :CARDSERIAL

NUM, ";

stream << " :PRODUCTTYPE, :VERSIONSN, :ODROUTESN, :DIAGRAMSN, :SWITCHACCCODE,

:WAITTIME, :WATINUMBER) ";

stream << ends;

if(parse(_sql) < 0)

return -1;

_sqlexec->getCursor()->initbind();

_sqlexec->getCursor()->bind(1, (void *)&trip->o_station_acc, sizeof(int), SQLT

_INT);

_sqlexec->getCursor()->bind(2, (void *)&trip->d_station_acc, sizeof(int), SQLT

_INT);

_sqlexec->getCursor()->bind(3, (void *)trip->trip_no, strlen(trip->trip_no), S

QLT_AFC);

_sqlexec->getCursor()->bind(4, (void *)trip->sacccode_arrdep, strlen(trip->sac

ccode_arrdep), SQLT_AFC);

_sqlexec->getCursor()->bind(5, (void *)trip->o_time, strlen(trip->o_time), SQL

T_AFC);

_sqlexec->getCursor()->bind(6, (void *)trip->d_time, strlen(trip->d_time), SQL

T_AFC);

_sqlexec->getCursor()->bind(7, (void *)&trip->source_participant_id, sizeof(in

t), SQLT_INT);

_sqlexec->getCursor()->bind(8, (void *)trip->settlement_date, strlen(trip->set

tlement_date), SQLT_AFC);

_sqlexec->getCursor()->bind(9, (void *)trip->card_serial_number, strlen(trip->

card_serial_number), SQLT_AFC);

//_sqlexec->getCursor()->bind(9, (void *)&trip->card_serial_number, sizeof(int

), SQLT_INT);

_sqlexec->getCursor()->bind(10, (void *)&trip->product_type, sizeof(int), SQLT

_INT);

_sqlexec->getCursor()->bind(11, (void *)trip->version_sn, strlen(trip->version

_sn), SQLT_AFC);

_sqlexec->getCursor()->bind(12, (void *)&trip->od_route_sn, sizeof(int), SQLT_

INT);

_sqlexec->getCursor()->bind(13, (void *)trip->diagramnum_sn, strlen(trip->diag

ramnum_sn), SQLT_AFC);

_sqlexec->getCursor()->bind(14, (void *)trip->switchAcccode, strlen(trip->swit

chAcccode), SQLT_AFC);

不用包装器使用绑定变量，很麻烦的。