<insert id="tops_visa_openapi_jvisaproduct.batchinsert" parameterClass="java.util.List">
<iterate conjunction="">
insert into tops_visa_openapi.jvisaproduct (id, external_id, providermark, name, nationid, visacompany_id,
zjcompany_id, visatype_name, adultprice, twoprice, zeroprice, interview,
visible, transact_date, staydate, entries_no, validity, nation_name, visa_company_name,
zjcompany_name, visa_type, create_time, update_time, visa_status)
values
<![CDATA[
(#list[].id#, #list[].externalId#, #list[].providermark#, #list[].name#, #list[].nationid#, #list[].visacompanyId#,
#list[].zjcompanyId#, #list[].visatypeName#, #list[].adultprice#, #list[].twoprice#, #list[].zeroprice#, #list[].interview#,
#list[].visible#, #list[].transactDate#, #list[].staydate#, #list[].entriesNo#, #list[].validity#, #list[].nationName#, #list[].visaCompanyName#,
#list[].zjcompanyName#, #list[].visaType#, #list[].createTime#, #list[].updateTime#, #list[].visaStatus#);
]]>
</iterate>
</insert>