mybatis 新增语句_mybatis添加数据动态处理语句

insert into rb_guarantee_baseinfo

guarantee_id,

user_id,

user_account,

user_province,

nation,

user_city,

user_area,

detailed_address,

guarantee_name,

logo_url,

mini_guarantee_ratio,

guarantee_account,

guarantee_maxamount,

overdue_num,

total_overdue_num,

guarantee_num,

genus_body,

the_position,

apply_guarantor_id,

apply_guarantor_name,

apply_guarantor_status,

apply_guarantor_time,

have_authorized_id,

have_authorized_status,

have_authorized_name,

have_authorized_time,

revocaion_guarantor_id,

revocation_guarantor_name,

revocaion_guarantor_status,

revocaion_guarantor_time,

matched_guarantee_id,

matched_guarantee_name,

matched_guarantee_status,

matched_guarantee_time,

total_frozen_amount,

total_guarantee_amount,

frozen_sum,

total_money,

in_instance_number,

in_instance_account,

in_review_number,

overdue_number,

remark,

#{guaranteeId,jdbcType=INTEGER},

#{userId,jdbcType=INTEGER},

#{userAccount,jdbcType=VARCHAR},

#{userProvince,jdbcType=VARCHAR},

#{nation,jdbcType=VARCHAR},

#{userCity,jdbcType=VARCHAR},

#{userArea,jdbcType=VARCHAR},

#{detailedAddress,jdbcType=VARCHAR},

#{guaranteeName,jdbcType=VARCHAR},

#{logoUrl,jdbcType=VARCHAR},

#{miniGuaranteeRatio,jdbcType=DECIMAL},

#{guaranteeAccount,jdbcType=DECIMAL},

#{guaranteeMaxamount,jdbcType=DECIMAL},

#{overdueNum,jdbcType=INTEGER},

#{totalOverdueNum,jdbcType=DECIMAL},

#{guaranteeNum,jdbcType=INTEGER},

#{genusBody,jdbcType=INTEGER},

#{thePosition,jdbcType=INTEGER},

#{applyGuarantorId,jdbcType=INTEGER},

#{applyGuarantorName,jdbcType=VARCHAR},

#{applyGuarantorStatus,jdbcType=INTEGER},

#{applyGuarantorTime,jdbcType=TIMESTAMP},

#{haveAuthorizedId,jdbcType=INTEGER},

#{haveAuthorizedStatus,jdbcType=INTEGER},

#{haveAuthorizedName,jdbcType=VARCHAR},

#{haveAuthorizedTime,jdbcType=TIMESTAMP},

#{revocaionGuarantorId,jdbcType=INTEGER},

#{revocationGuarantorName,jdbcType=VARCHAR},

#{revocaionGuarantorStatus,jdbcType=INTEGER},

#{revocaionGuarantorTime,jdbcType=TIMESTAMP},

#{matchedGuaranteeId,jdbcType=INTEGER},

#{matchedGuaranteeName,jdbcType=VARCHAR},

#{matchedGuaranteeStatus,jdbcType=INTEGER},

#{matchedGuaranteeTime,jdbcType=TIMESTAMP},

#{totalFrozenAmount,jdbcType=DECIMAL},

#{totalGuaranteeAmount,jdbcType=DECIMAL},

#{frozenSum,jdbcType=DECIMAL},

#{totalMoney,jdbcType=DECIMAL},

#{inInstanceNumber,jdbcType=INTEGER},

#{inInstanceAccount,jdbcType=DECIMAL},

#{inReviewNumber,jdbcType=INTEGER},

#{overdueNumber,jdbcType=INTEGER},

#{remark,jdbcType=LONGVARCHAR},