将oracle中的数据绑定在界面中制作树形菜单
建包建类
数据库建表和插入数据
实体类:
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 + "]";
}
主界面:
<%@ include file="common/head.jsp" %>
<title>Insert title here</title>
<script>
$(function() {
$("#funcTree").tree({undefined
url: ctx+"/moduleServlet",
onDblClick:function(node) {
$("#funTab").tabs("add", {
title:node.text,
content:'Tab Body',
closable:true,
tools:[{undefined
iconCls:'icon-mini-refresh',
handler:function(){
alert('refresh');
}
}]
})
}
});
});
</script>
</head>
dao方法:
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;
}