(排除新增节点的值)
大于等于新增节的左下标值的右下标值都加二
大于等于新增节点右节点值的左下标值都加二
servlet中的sql语句方式
/*
*更新左下标
*/
public boolean uodateLeft_num(int right_num,int id){
String sql = "update user set left_num = left_num+2 where left_num >= ? and id <> ?";
return Dbutil.excuteUpdate(sql,right_num,id)>0;
}
/*
*更新左下标
*/
public boolean uodateRight_num(int left_num,int id){
String sql = "update user set right_num = right_num+2 where right_num >= ? and id <> ?";
return Dbutil.excuteUpdate(sql,right_num,id)>0;
}