Question

关于mybatis的修改语句怎么写的

Answer 1

<update id="deletePdWorkExpAttach" parameterType="com.iss.postdoctor.project.domain.PdWorkExpAttach">
UPDATE PD_WORK_EXP_ATTACH
SET IS_DELETE = 1
, UPDATOR = #{pdWorkExp.updator}
, UPDATE_TIME = NOW()
WHERE IS_DELETE = 0
<if test="pdWorkExp.workExpId != null and pdWorkExp.workExpId !=''">
AND WORK_EXP_ID = #{pdWorkExp.workExpId}
</if>
<if test="pdWorkExp.attachId != null and pdWorkExp.attachId !=''">
AND ATTACH_ID != #{pdWorkExp.attachId}
</if>
</update>