easyui tree 多级节点的的某个节点的所有子节点id查询

最新推荐文章于 2019-11-07 20:29:30 发布

lzc1039862438

最新推荐文章于 2019-11-07 20:29:30 发布

阅读量1.4k

点赞数

文章标签： easyui

本文链接：https://blog.csdn.net/lzc1039862438/article/details/51545342

版权

数据库函数：

DELIMITER $$

CREATE DEFINER=`user`@`%` FUNCTION `queryChildrenType`(ppid varchar(32)) RETURNS text CHARSET utf8
BEGIN
DECLARE sTemp text;
DECLARE sTempChd text;

SET sTemp = "";
SET sTempChd = cast(ppid as char);

WHILE sTempChd is not NULL DO
if ISNULL(sTemp) || LENGTH(trim(sTemp))<1 THEN
SET sTemp = sTempChd;
ELSE
SET sTemp = CONCAT(sTemp,',',sTempChd);
END IF;

SELECT group_concat(id) INTO sTempChd FROM qs_airdata_materialtype where FIND_IN_SET(parentId,sTempChd)>0;
END WHILE;
return sTemp;
END

dao层函数（result即为所有的id）：

public String queryChildren(String id) {
Session session = getHibernateTemplate().getSessionFactory()
.openSession();
try {
String hql = "select queryChildrenType(?)";
String result = null;
SQLQuery query = session.createSQLQuery(hql);
query.setParameter(0, id);
result = (String) query.uniqueResult();
return result;
} finally {
session.close();
}
}