Using mybatis Dynamic Update data _java

Using MyBatis to write SQL, you need to dynamically update the object data, each time you need to update the fields, in order to prevent null-null exceptions, you need to use dynamic SQL,

<update id= "Update" parametertype= "Com.commuli.po.User" >
update s_user <trim
"Set" Suffixoverrides= "," >
<if test= "Name!=null" >name=#{name},</if>
<if test= "Age!=null" > age=#{age},</if>
<if test= "Address!=null" >address=#{address},</if>
<if test= " Createdate!=null ">createDate=#{createDate},</if>
</trim>
where
id=#{id}
</ Update>

Note: The trim label is used to remove the comma "," from the last field in SQL.

The above is a small set to introduce the use of MyBatis Dynamic update data, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!