排序Java后台 两种方式

for(int i=0;i<list.size();i++){
                if(list.get(i).getId().equals(goodsId)){
                    if(type==0 && i>0){
                        nextSort = list.get(i-1).getSort();
                        nextGoodsId = list.get(i-1).getId();
                    }
                    else{
                        nextSort = list.get(i+1).getSort();
                        nextGoodsId = list.get(i+1).getId();
                    }
                    hostSort = list.get(i).getSort();
                }
            }

互换排序

@Update({"<script>"+"update goods set sort = sort " +
            "<if test='type == 0'> - </if> " +
            "<if test='type == 1'> + </if> " +
            "1 where " +
            "<if test='type == 0'> sort &lt;= #{newSort} and sort &gt; #{oldSort} </if>" +
            "<if test='type == 1'> sort &gt;= #{newSort} and sort &lt; #{oldSort} </if>"
            +"</script>"})
    public boolean insertSort(@Param("newSort") Integer newSort,@Param("oldSort") Integer oldSort,@Param("type") Integer type,@Param("condition")String condition);

插入排序