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);
不用包装器使用绑定变量,很麻烦的。