实体类:
public class Module {
private Integer id;
private Integer pid;
private String text;
private String icon;
private String url;
private int sort;
private List<Module> children = new ArrayList<>();
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public Integer getPid() {
return pid;
}
public void setPid(Integer pid) {
this.pid = pid;
}
public String getText() {
return text;
}
public void setText(String text) {
this.text = text;
}
public String getIcon() {
return icon;
}
public void setIcon(String icon) {
this.icon = icon;
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
public int getSort() {
return sort;
}
public void setSort(int sort) {
this.sort = sort;
}
public List<Module> getChildren() {
return children;
}
public void setChildren(List<Module> children) {
this.children = children;
}
@Override
public String toString() {
return "Module [id=" + id + ", pid=" + pid + ", text=" + text + ", icon=" + icon + ", url=" + url + ", sort="
+ sort + "]";
}
}
数据访问层:
public class ModuleDao implements IModuleDao {
@Override
public List<Module> listModel(int pid) {
List<Module> list = new ArrayList<>();
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
String sql = "select id,pid,text,icon,url,sort from t_module where pid=?";
con = DBHelper.getsCon();
ps = con.prepareStatement(sql);
ps.setInt(1, pid);
rs = ps.executeQuery();
while(rs.next()) {
Module m = new Module();
m.setId(rs.getInt("id"));
m.setPid(rs.getInt("pid"));
m.setText(rs.getString("text"));
m.setUrl(rs.getString("url"));
m.setSort(rs.getInt("sort"));
list.add(m);
}
} catch (Exception e) {
} finally {
DBHelper.Close(con, ps, rs);
}
return list;
}
public static void main(String[] args) {
ModuleDao dao = new ModuleDao();
List<Module> list = dao.listModel(21);
list.forEach(t->System.out.println(t));
}
}
servlet:
@WebServlet("/moduleServlet")
public class ModuleServlet extends HttpServlet {
private IModuleService service = new ModuleService();
public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException {
doPost(req, resp);
}
public void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException {
req.setCharacterEncoding("utf-8");
resp.setContentType("application/json; charset=utf-8");
List<Module> list = service.listModel(-1);
PrintWriter out = resp.getWriter();
String str = JSON.toJSONString(list);
out.write(str);
out.flush();
out.close();
}
}
service:
public class ModuleService implements IModuleService {
private IModuleDao dao = new ModuleDao();
@Override
public List<Module> listModel(int pid) {
List<Module> list = dao.listModel(pid);
//递归算法
for(Module m: list) {
if(m.getUrl() == null || "".equals(m.getUrl().trim())) {
m.setChildren(listModel(m.getId()));
}
}
return list;
}
}
主界面:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<%@ include file="common/head.jsp"%>
<script type="text/javascript">
$(function() {
$('#funcTree').tree({
// ctx是上下文参数,作为绝对路径使用,详细可以查看上一章EasyUI
url : ctx + '/moduleServlet',
//双击事件
onDblClick : function(node) {
//判重,如果为false即可以添加新的tab
if(!$("#tt").tabs('exists',node.text)){
$('#tt').tabs('add', {
title:node.text,
content:node.text,
closable:true
});
//如果为true,证明已经存在,就移动到指定的tab
}else{
$('#tt').tabs('select',node.text)
}
}
});
})
</script>
</head>
<body class="easyui-layout">
<div data-options="region:'north',title:'芜湖',split:true"
style="height: 100px;"></div>
<div data-options="region:'west',title:'功能导航',split:true"
style="width: 200px;">
<ul id="funcTree"></ul>
</div>
<div data-options="region:'center'"
style="padding: 5px; background: #eee;">
<div id="tt" class="easyui-tabs" style="width: 100%; height: 100%;">
<div title="首页" style="padding: 20px; display: none;">首页</div>
</div>
</div>
<div data-options="region:'south',split:true"
style="text-align: center; height: 30px; background: #E0ECFF"
class="panel-title">Copyright@XXXX有限责任公司</div>
</body>
</html>