mapper中
// A code block
mapper 文件中
// An highlighted block
int updateMess(@Param("Customer") Customer customer, @Param("org_num") Integer orId);
mybatis sql语句
`
// A code block
var foo = 'bar';
// An highlighted block
<update id="updateMess" parameterType="Customer">
update 表名
set
org_role = #{Customer.orgRole,jdbcType=VARCHAR},
org_name = #{Customer.orgName,jdbcType=VARCHAR},
org_status = #{Customer.orgStatus,jdbcType=VARCHAR},
host_dep = #{Customer.hostDep,jdbcType=VARCHAR},
cre_code = #{Customer.creCode,jdbcType=VARCHAR},
valid_perid = #{Customer.validPerid,jdbcType=VARCHAR},
legal_person = #{Customer.legalPerson,jdbcType=VARCHAR},
b_number = #{Customer.bNumber,jdbcType=VARCHAR},
l_number = #{Customer.lNumber,jdbcType=INTEGER},
date_time = #{Customer.dateTime,jdbcType=TIMESTAMP},
reg_address = #{Customer.regAddress,jdbcType=VARCHAR},
bus_address = #{Customer.busAddress,jdbcType=VARCHAR}
where cus_id= #{org_num}
</update>