1 <!-- 次序上移下移 --> 2 <update id="upordown" parametertype="java.util.map"> 3 update d 4 set d.order_num = d1.order_num 5 from sys_dept d 6 join sys_dept d1 on (d.dept_id = #{id} and d1.dept_id = #{targetid} or d.dept_id = #{targetid} and d1.dept_id = #{id}) 7 </update>