mysql start with_mysql 实现 start with

自己写service----> 传入map(idsql,rssql,prior)   idsql 查询id   rssql 查询结果集    调用 以下方法

@param ids 要查询的起始 start with

* @param allres 包含要递归数据的结果集 ( 查询时别名ID PID )

* @param pos prior---> UP or DOWN

* @return

*/

public static List> getTree(ArrayList ids,

List> allres,String pos) {

List> res=new ArrayList>();

if("up".equals(pos)){

res=toCreatTreeUp(ids,allres,res);

}

if("down".equals(pos)){

res=toCreatTreeDown(ids,allres,res);

}

return res;

}

private static List> toCreatTreeUp(ArrayList ids,

List> allres,List> res) {

ArrayList idss = new ArrayList();

for(String id :ids){

for (Map map : allres) {

if(id.equals(map.get("ID").toString())){

idss.add(map.get("PID").toString());

res.add(map);

}

}

}

if (idss.size()!=0) {

ids = idss;

res = toCreatTreeUp(ids,allres,res);

}

return res ;

}

private static List> toCreatTreeDown(ArrayList ids,

List> allres,List> res) {

ArrayList idss = new ArrayList();

for(String id :ids){

for (Map map : allres) {

if(id.equals(map.get("ID").toString())){

res.add(map);

}

if(id.equals(map.get("PID").toString())){

idss.add(map.get("ID").toString());

}

}

}

if (idss.size()!=0) {

ids = idss;

res = toCreatTreeDown(ids,allres,res);

}

return res ;

}