MybatisPlus之prim标签

MybatisPlus之trim标签

<trim prefix="" suffix="" suffixOverrides="" prefixOverrides=""></trim>

prefix:在trim标签内sql语句加上前缀。

suffix:在trim标签内sql语句加上后缀。

prefixOverrides:指定去除多余的前缀内容

suffixOverrides:指定去除多余的后缀内容，如：suffixOverrides=","，去除trim标签内sql语句多余的后缀","。

<update id="updateWork" >
         update 
            contract_work cw     
            <trim prefix="set" suffixOverrides="," suffix="where cw.id  = #{work.id}">       
                       
                cw.value = #{work.value},
                               
                cw.begin_date = #{work.beginDate},
                          
                cw.end_date = #{work.beginDate},
                   
                cw.meet_topic = #{work.meetTopic},
                              
                cw.meet_place = #{work.meetPlace},
                
                cw.serve_object = #{work.serveObject},
                                
                cw.check_serial = #{work.checkSerial},
                
                cw.name = #{work.name},
                
                cw.modifier_id = #{work.modifierId},
                
                cw.gmt_modified = #{work.gmtModified} ,        
                  
            </trim>          
    </update>

翻译过后的最终sql就是：

 update contract_work cw set cw.value = #{work.value},cw.begin_date = #{work.beginDate} ..省略逗号..cw.gmt_modified = #{work.gmtModified}