INSERT INTO deal_cp(
id,
batch_number,
code,
name,
card,
bank_card,
money,
dates,
time,
shop_name,
batch_numbernew,
visitor,
visitor_card,
end_date,
moneynew,
service_type,
idnew,
start_date,
start_dates,
start_time,
end_dates,
end_time,
data_status,
data_type,
bank_ID
)SELECT #{dealCp.id,jdbcType=VARCHAR},
#{dealCp.batchNumber,jdbcType=VARCHAR},
#{dealCp.code,jdbcType=VARCHAR},
#{dealCp.name,jdbcType=VARCHAR},
#{dealCp.card,jdbcType=VARCHAR},
#{dealCp.bankCard,jdbcType=VARCHAR},
#{dealCp.money,jdbcType=VARCHAR},
#{dealCp.dates,jdbcType=VARCHAR},
#{dealCp.time,jdbcType=VARCHAR},
#{dealCp.shopName,jdbcType=VARCHAR},
#{dealCp.batchNumbernew,jdbcType=VARCHAR},
#{dealCp.visitor,jdbcType=VARCHAR},
#{dealCp.visitorCard,jdbcType=VARCHAR},
#{dealCp.endDate,jdbcType=DATE},
#{dealCp.moneynew,jdbcType=VARCHAR},
#{dealCp.serviceType,jdbcType=VARCHAR},
#{dealCp.idnew,jdbcType=VARCHAR},
#{dealCp.startDate,jdbcType=DATE},
#{dealCp.startDates,jdbcType=VARCHAR},
#{dealCp.startTime,jdbcType=VARCHAR},
#{dealCp.endDates,jdbcType=VARCHAR},
#{dealCp.endTime,jdbcType=VARCHAR},
#{dealCp.dataStatus,jdbcType=CHAR},
#{dealCp.dataType,jdbcType=CHAR},
#{dealCp.bankId,jdbcType=VARCHAR}
FROM dual