2个回答
展开全部
jsp动态树形菜单须用到递归算法，比如在数据库有张表，parent表，parent的字段有id,name,depth,leve,ID自增，depth设置为级数,如这条数据最大，为0,如为字菜单就为1,而leve就指定它父节点的id，给段代码自己可以摸索下 public Vector getModuleTree()
{
Vector pclass = new Vector();
try
{
stmt =con.createStatement();
String sql = "select * from Module where parentid = 0";
rs = stmt.executeQuery(sql);
Module cvo = null;
while(rs.next())
{
cvo = new Module();
cvo.setModule_id(rs.getInt("Module_id"));
cvo.setModule_name(rs.getString("Module_name"));
cvo.setModule_url(rs.getString("Module_url"));
cvo.setParentid(rs.getInt("parentid")); cvo.setRootid(rs.getInt("rootid")); cvo.setDepth(rs.getInt("depth")); pclass.add(cvo);
}
for (int i = 0; i < pclass.size(); i++)
{
Module pcvo = (Module) pclass.get(i);
ShowTreeMenu(pcvo);
}
con.commit(); } catch (SQLException e)
{
e.printStackTrace();
} finally
{
try
{
if(rs!=null)
{
rs.close();
}
if(stmt!=null)
{
stmt.close();
}
if(con!=null)
{
con.close();
}
}
catch (SQLException e)
{
e.printStackTrace();
}
}
return classList;
}
public void ShowTreeMenu(Module c)
{
Module ccvo = null;
String sql = "select * from Module where parentid = " + c.getModule_id();
Vector cclass = new Vector();
try
{
Module cvotemp;
stmt =con.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next())
{
cvotemp = new Module();
cvotemp.setModule_id(rs.getInt("Module_id"));
cvotemp.setModule_name(rs.getString("Module_name"));
cvotemp.setModule_url(rs.getString("Module_url"));
cvotemp.setParentid(rs.getInt("parentid")); cvotemp.setRootid(rs.getInt("rootid")); cvotemp.setDepth(rs.getInt("depth")); cclass.add(cvotemp);
}
System.out.println(cclass.size()+"(((((((((((((((((((((((((9");
if (cclass.size() > 0)
{
c.setHasChild("have");
classList.add(c);
for (int j = 0; j < cclass.size(); j++)
{
ccvo = (Module) cclass.get(j);
ShowTreeMenu(ccvo);
} } else
{
classList.add(c);
}
} catch (SQLException e)
{
e.printStackTrace();
}
}
{
Vector pclass = new Vector();
try
{
stmt =con.createStatement();
String sql = "select * from Module where parentid = 0";
rs = stmt.executeQuery(sql);
Module cvo = null;
while(rs.next())
{
cvo = new Module();
cvo.setModule_id(rs.getInt("Module_id"));
cvo.setModule_name(rs.getString("Module_name"));
cvo.setModule_url(rs.getString("Module_url"));
cvo.setParentid(rs.getInt("parentid")); cvo.setRootid(rs.getInt("rootid")); cvo.setDepth(rs.getInt("depth")); pclass.add(cvo);
}
for (int i = 0; i < pclass.size(); i++)
{
Module pcvo = (Module) pclass.get(i);
ShowTreeMenu(pcvo);
}
con.commit(); } catch (SQLException e)
{
e.printStackTrace();
} finally
{
try
{
if(rs!=null)
{
rs.close();
}
if(stmt!=null)
{
stmt.close();
}
if(con!=null)
{
con.close();
}
}
catch (SQLException e)
{
e.printStackTrace();
}
}
return classList;
}
public void ShowTreeMenu(Module c)
{
Module ccvo = null;
String sql = "select * from Module where parentid = " + c.getModule_id();
Vector cclass = new Vector();
try
{
Module cvotemp;
stmt =con.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next())
{
cvotemp = new Module();
cvotemp.setModule_id(rs.getInt("Module_id"));
cvotemp.setModule_name(rs.getString("Module_name"));
cvotemp.setModule_url(rs.getString("Module_url"));
cvotemp.setParentid(rs.getInt("parentid")); cvotemp.setRootid(rs.getInt("rootid")); cvotemp.setDepth(rs.getInt("depth")); cclass.add(cvotemp);
}
System.out.println(cclass.size()+"(((((((((((((((((((((((((9");
if (cclass.size() > 0)
{
c.setHasChild("have");
classList.add(c);
for (int j = 0; j < cclass.size(); j++)
{
ccvo = (Module) cclass.get(j);
ShowTreeMenu(ccvo);
} } else
{
classList.add(c);
}
} catch (SQLException e)
{
e.printStackTrace();
}
}
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
2016-03-08 · 百度知道合伙人官方认证企业
育知同创教育
1【专注：Python+人工智能|Java大数据|HTML5培训】 2【免费提供名师直播课堂、公开课及视频教程】 3【地址：北京市昌平区三旗百汇物美大卖场2层，微信公众号：yuzhitc】
向TA提问
关注
![]()
展开全部
1、得到树信息
public Treeinfo[] getAllTreeinfo() throws Exception{
Connection conn = getConn();
PreparedStatement smt = conn.prepareStatement("select * from treeTable where parent_treeId = -1");
CachedRowSet cs = new CachedRowSetImpl();
cs.populate(smt.executeQuery());
List<Treeinfo> treeinfoList = new ArrayList<Treeinfo>();
while(cs.next()){
Treeinfo treeinfo = new Treeinfo();
treeinfo.setTreeId(cs.getInt(1));
treeinfo.setNodeName(cs.getString(2));
treeinfo.setParentId(cs.getInt(3));
treeinfo.setChildren(getChildren(treeinfo.getTreeId()));
treeinfoList.add(treeinfo);
}
cs.close();
smt.close();
conn.close();
Treeinfo[] treeinfo = new Treeinfo[treeinfoList.size()];
treeinfo = treeinfoList.toArray(treeinfo);
return treeinfo;
}
2、得到当前id的子节点信息,这里用了递归调用
public Treeinfo[] getChildren(int treeNodeId) throws Exception{
Connection conn = getConn();
PreparedStatement smt = conn.prepareStatement("select * from treeTable where parent_treeId = ?");
smt.setInt(1, treeNodeId);
ResultSet rs = smt.executeQuery();
List<Treeinfo> childList = new ArrayList<Treeinfo>();
while(rs.next()){
Treeinfo treeinfo = new Treeinfo();
treeinfo.setTreeId(rs.getInt(1));
treeinfo.setNodeName(rs.getString(2));
treeinfo.setParentId(rs.getInt(3));
treeinfo.setChildren(getChildren(treeinfo.getTreeId()));
childList.add(treeinfo);
}
rs.close();
smt.close();
conn.close();
Treeinfo[] childResult = new Treeinfo[childList.size()];
childResult = childList.toArray(childResult);
return childResult;
}
}
3、最后新建显示树形菜单的jsp页面
<%@ page language="java" pageEncoding="GB18030"%>
<%@ taglib uri="/struts-tags" prefix="s" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'testtree.jsp' starting page</title>
<s:head theme="ajax" debug="true" />
<script language="JavaScript">
function treeNodeSelected(arg) {
alert("id["+arg.source.widgetId+"], name["+ arg.source.title+ "] selected");
}
dojo.addOnLoad(function() {
var s = dojo.widget.byId('treeTestId').selector;
dojo.event.connect(s, 'select', 'treeNodeSelected');
});
</script>
</head>
<body>
<s:tree id="treeTestId"
theme="ajax"
rootNode="root"
childCollectionProperty="children"
nodeIdProperty="treeId"
nodeTitleProperty="nodeName"
treeSelectedTopic="treeSelected">
</s:tree>
</body>
</html>
public Treeinfo[] getAllTreeinfo() throws Exception{
Connection conn = getConn();
PreparedStatement smt = conn.prepareStatement("select * from treeTable where parent_treeId = -1");
CachedRowSet cs = new CachedRowSetImpl();
cs.populate(smt.executeQuery());
List<Treeinfo> treeinfoList = new ArrayList<Treeinfo>();
while(cs.next()){
Treeinfo treeinfo = new Treeinfo();
treeinfo.setTreeId(cs.getInt(1));
treeinfo.setNodeName(cs.getString(2));
treeinfo.setParentId(cs.getInt(3));
treeinfo.setChildren(getChildren(treeinfo.getTreeId()));
treeinfoList.add(treeinfo);
}
cs.close();
smt.close();
conn.close();
Treeinfo[] treeinfo = new Treeinfo[treeinfoList.size()];
treeinfo = treeinfoList.toArray(treeinfo);
return treeinfo;
}
2、得到当前id的子节点信息,这里用了递归调用
public Treeinfo[] getChildren(int treeNodeId) throws Exception{
Connection conn = getConn();
PreparedStatement smt = conn.prepareStatement("select * from treeTable where parent_treeId = ?");
smt.setInt(1, treeNodeId);
ResultSet rs = smt.executeQuery();
List<Treeinfo> childList = new ArrayList<Treeinfo>();
while(rs.next()){
Treeinfo treeinfo = new Treeinfo();
treeinfo.setTreeId(rs.getInt(1));
treeinfo.setNodeName(rs.getString(2));
treeinfo.setParentId(rs.getInt(3));
treeinfo.setChildren(getChildren(treeinfo.getTreeId()));
childList.add(treeinfo);
}
rs.close();
smt.close();
conn.close();
Treeinfo[] childResult = new Treeinfo[childList.size()];
childResult = childList.toArray(childResult);
return childResult;
}
}
3、最后新建显示树形菜单的jsp页面
<%@ page language="java" pageEncoding="GB18030"%>
<%@ taglib uri="/struts-tags" prefix="s" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'testtree.jsp' starting page</title>
<s:head theme="ajax" debug="true" />
<script language="JavaScript">
function treeNodeSelected(arg) {
alert("id["+arg.source.widgetId+"], name["+ arg.source.title+ "] selected");
}
dojo.addOnLoad(function() {
var s = dojo.widget.byId('treeTestId').selector;
dojo.event.connect(s, 'select', 'treeNodeSelected');
});
</script>
</head>
<body>
<s:tree id="treeTestId"
theme="ajax"
rootNode="root"
childCollectionProperty="children"
nodeIdProperty="treeId"
nodeTitleProperty="nodeName"
treeSelectedTopic="treeSelected">
</s:tree>
</body>
</html>
本回答被网友采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
