关于序号的问题

	<!-- 删除后，将后面的序号减1 -->
	<statement id="updateCollaboratorNum"   parameterClass="java.util.Map">
 		<![CDATA[ 
 		update TBZCOLLABORATOR set num=num-1 WHERE BRANCH_ID=#branchId:VARCHAR# and NUM>#num#
 		 ]]>
	</statement>
	<!-- 给修改新序号 -->
	<statement id="updateCollaboratorNumForNewNum"   parameterClass="java.util.Map">
 		<![CDATA[ 
 		update TBZCOLLABORATOR set num=#newNum# WHERE COLLABORATOR_ID=#collaboratorId:VARCHAR#
 		 ]]>
	</statement>
	<!-- 给修改新序号后，更新其他序号 序号由小变大 -->
	<statement id="updateOtherCollaboratorNumForNewNumA"   parameterClass="java.util.Map">
 		<![CDATA[ 
 		update TBZCOLLABORATOR set num=num-1 WHERE BRANCH_ID=#branchId:VARCHAR# and NUM<=#newNum# and NUM>#num#
 		 ]]>
	</statement>
	<!-- 给修改新序号后，更新其他序号 序号由大变小 -->
	<statement id="updateOtherCollaboratorNumForNewNumD"   parameterClass="java.util.Map">
 		<![CDATA[ 
 		update TBZCOLLABORATOR set num=num+1 WHERE BRANCH_ID=#branchId:VARCHAR# and NUM<#num# and NUM>=#newNum#
 		 ]]>
	</statement>