easyui树拖拽排序java_easyui树节点拖拽排序的存储过程

easyui树的拖拽排序功能

easyui树中有拖拽功能

树结构如下：

一个行政区域对应一个单位，一个单位对应多个部门，每个部门下有相关人员，功能要求：

(1)行政区域没有子节点，点击text加载部门；(2)点击部门的text,如果有下级部门则加载部门，没有则加载人员；(3)树都有拖拽排序功能

1、前台页面：

var $orgs_tree = $("#orgs_tree").tree(orgs_tree_default);

var orgs_tree_default = {

url : 'servlet/SearchServlet?dispatch=0',

animate : true,

onClick:function(node){

var url = "servlet/SearchServlet?dispatch=1";//默认加载地区的树

var isDeptTree = false;

var unit_id ;

//根据行政区划获取单位列表

$.getJSON(url,{regions_id:node.attributes.regions_id},function(data){

if(data.length > 1){

}else if(data.length == 0){

}else{

//点击部门树的text,加载树

$("#dept_tree").tree({

url:"servlet/SearchServlet?dispatch=2&unit_id=" + unit_id+"&id=0", //默认加载部门的树

onBeforeExpand:function(node,param){

$("#dept_tree").tree("options").url="servlet/SearchServlet?dispatch=2&unit_id=" + unit_id+"&id="+node.id;

},

onSelect:function(node){//当点击text的时候，展开子节点

$(this).tree("expand",node.target);

}

});

}

});

},

onDrop:function(target, source, point){ //行政区域树的拖拽功能

var node = $("#orgs_tree").tree("getNode",target); // 将DOM对象转换为node

//组装参数

var param = {

//目标节点属性

targetId : node.attributes.regions_id ,

targetSort : node.attributes.regions_sort ,

//源节点属性

sourceId : source.attributes.regions_id ,

sourceSort : source.attributes.regions_sort,

//操作方式3种，append:变更父节点，top:平级-上 bottom:平级-下

point : point};

//更新数据库，这个后台需要用到存储过程

var url = "servlet/ManagerServlet?dispatch=0";

$.post(url,param,function(data){

alert("success");

});

}

};

2、java后台调用方法

public String dragRegionsSort(int target_id, int target_sort,

int source_id, int source_sort,String operation) {

String result = "排序成功";

conn= this.getConnection();

CallableStatement statement = conn.prepareCall("{call PRO_UPDATE_REGION_SORT(?,?,?,?,?)}");

try {

statement.setInt(1, target_id);

statement.setInt(2, target_sort);

statement.setInt(3, source_id);

statement.setInt(4, source_sort);

statement.setString(5, operation);

statement.execute();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return result ;

}

3、存储过程

create or replace procedure "PRO_UPDATE_REGION_SORT"

(

target_id in number,--目标id

target_sort in number,--目标排序号

source_id in number, --源id

source_sort in number , --源排序号

operation in varchar2 --操作类型，之前还是之后

)as

p_tid number;

p_sid number ;

begin

select regions_id into p_tid from tbl_regions t where t.regions_id = target_id;

select regions_id into p_sid from tbl_regions t where t.regions_id = source_id;

dbms_output.put_line('---目标id--'||p_tid||'---源id---'||p_sid);

if target_sort - source_sort = 1 then

if operation = 'top' then

null;

else

update tbl_regions t set t.regions_sort = target_sort WHERE t.regions_id = source_id ;

update tbl_regions t set t.regions_sort = source_sort WHERE t.regions_id = target_id ;

end if ;

elsif target_sort - source_sort = -1 then

if operation = 'top' then

update tbl_regions t set t.regions_sort = target_sort WHERE t.regions_id = source_id ;

update tbl_regions t set t.regions_sort = source_sort WHERE t.regions_id = target_id ;

else

null;

end if;

elsif target_sort - source_sort < -1 then

if operation = 'top' then

update tbl_regions t set t.regions_sort = t.regions_sort + 1 where t.regions_sort >= target_sort and t.regions_sort < source_sort;

update tbl_regions t set t.regions_sort = target_sort where t.regions_id = source_id ;

dbms_output.put_line('---排序前目标sort--'||target_sort||'---源sort---'||source_sort);

dbms_output.put_line('---排序后目标sort--'||target_sort||'---源sort---'||source_sort);

else

update tbl_regions t set t.regions_sort = t.regions_sort + 1 where t.regions_sort > target_sort and t.regions_sort < source_sort;

update tbl_regions t set t.regions_sort = target_sort+1 where t.regions_id = source_id ;

end if ;

elsif target_sort - source_sort > 1 then

if operation = 'top' then

update tbl_regions t set t.regions_sort = t.regions_sort - 1 where t.regions_sort > source_sort and t.regions_sort < target_sort;

update tbl_regions t set t.regions_sort = target_sort - 1 where t.regions_id = source_id ;

else

update tbl_regions t set t.regions_sort = t.regions_sort - 1 where t.regions_sort > source_sort and t.regions_sort <= target_sort;

update tbl_regions t set t.regions_sort = target_sort where t.regions_id = source_id ;

end if;

end if;

end;