jquery中EasyUI实现异步树_jquery
程序员文章站
2022-05-18 19:46:46
...
前台使用EasyUI实现 . EasyUI向后台传递一个id参数 .
/**
* tree
*/
@RequestMapping(value = "/tree.do")
public void mytree(HttpServletResponse response, String id) {
this.writeJson(response, bookService.getChildrenTree(id));
}
@Transactional
@Override
public List getChildrenTree(String pid) {
try {
List result = new ArrayList();
//获得儿子节点的列表
List childrenList = this.getChildrenType(pid);
if (childrenList != null && childrenList.size() > 0) {
for (TBookType child : childrenList) {
// 获取孙子的个数
long count = bookDao.getChildrenCount(String.valueOf(child.getId()));
Tree node = new Tree();
node.setId(String.valueOf(child.getId()));
node.setPid(String.valueOf(child.getPid()));
node.setText(child.getName());
node.setChildren(null);
node.setState(count > 0 ? "closed" : "open");
//将儿子列表childrenList数据逐个存到树当中
result.add(node);
}
}
return result;
} catch (Exception e) {
throw new BusinessException("获取图书类型数据出现错误!", e);
}
}
@Override
public List getChildrenType(String pid) {
//这个的pid就是当前展开节点的id , 通过父节点的 id 来获得子节点
StringBuilder sqlstr = new StringBuilder();
if (StringUtils.isBlank(pid))
sqlstr.append("select * from booktype bt where bt.pid=0");
else
sqlstr.append("select * from booktype bt where bt.pid=" + pid );
return this.search2(TBookType.class, sqlstr.toString());
}
@Override
public long getChildrenCount(String pid) {
//这个的pid就是当前展开节点的id , 通过父节点的 id 来获得子节点的个数
StringBuilder sqlstr = new StringBuilder();
if (StringUtils.isBlank(pid))
sqlstr.append("select count(*) from booktype tb where tb.pid='0'");
else
sqlstr.append("select count(*) from booktype tb where tb.pid='" + pid + "'");
return this.count(sqlstr.toString());
}
第一次加载 , 向后台传递的id为null .
之后每次将树节点展开 , 会向后台传递一个当前节点的 id .
Control层 :
复制代码 代码如下:
/**
* tree
*/
@RequestMapping(value = "/tree.do")
public void mytree(HttpServletResponse response, String id) {
this.writeJson(response, bookService.getChildrenTree(id));
}
Service层 :
复制代码 代码如下:
@Transactional
@Override
public List
try {
List
//获得儿子节点的列表
List
if (childrenList != null && childrenList.size() > 0) {
for (TBookType child : childrenList) {
// 获取孙子的个数
long count = bookDao.getChildrenCount(String.valueOf(child.getId()));
Tree node = new Tree();
node.setId(String.valueOf(child.getId()));
node.setPid(String.valueOf(child.getPid()));
node.setText(child.getName());
node.setChildren(null);
node.setState(count > 0 ? "closed" : "open");
//将儿子列表childrenList数据逐个存到树当中
result.add(node);
}
}
return result;
} catch (Exception e) {
throw new BusinessException("获取图书类型数据出现错误!", e);
}
}
Dao层 :
复制代码 代码如下:
@Override
public List
//这个的pid就是当前展开节点的id , 通过父节点的 id 来获得子节点
StringBuilder sqlstr = new StringBuilder();
if (StringUtils.isBlank(pid))
sqlstr.append("select * from booktype bt where bt.pid=0");
else
sqlstr.append("select * from booktype bt where bt.pid=" + pid );
return this.search2(TBookType.class, sqlstr.toString());
}
复制代码 代码如下:
@Override
public long getChildrenCount(String pid) {
//这个的pid就是当前展开节点的id , 通过父节点的 id 来获得子节点的个数
StringBuilder sqlstr = new StringBuilder();
if (StringUtils.isBlank(pid))
sqlstr.append("select count(*) from booktype tb where tb.pid='0'");
else
sqlstr.append("select count(*) from booktype tb where tb.pid='" + pid + "'");
return this.count(sqlstr.toString());
}
以上所述就是本文关于EasyUI实现异步树的全部代码了,希望对大家能有所帮助