The approach I took was
1. design a table that is self-reference. For example
id Parent_id
5 0
1 0
3 1
2 1
4 2
6 5
So the tree structure is lik
0-->1 -->2 -->4
-->3
-->5 -->6
2. User recurssion in you code
public void Get_MessageVector(String strDriver,String strUrl, String
strUserId,String strPassword,String parentID , int intLevel , Vector
vecReturn)
{
try
{
String strParentid =parentID;
//strParentid = strParentid.valueOf(parentID);
String strSql = "select * from tablename where parent_ID=" +
strParentid + ";
Class.forName(strDriver);
Connection conn =
DriverManager.getConnection(strUrl,strUserId,strPassword);
Statement strStatement;
strStatement = conn.createStatement();
ResultSet rs = strStatement.executeQuery(strSql);
while (rs.next())
{
Vector vecRow = new Vector();
String strLevel = Get_RepeatString("...", intLevel);
vecRow.addElement(strLevel); //0
String strNewPid = rs.getString("Id");
vecRow.addElement(strNewPid); //1
vecRow.addElement(rs.getString("Parent_Id")); //2
vecRow.addElement(rs.getString("Sender")); //3
vecRow.addElement(rs.getString("Subject")); //4
vecRow.addElement(rs.getString("Enter_Date")); //5
vecReturn.addElement(vecRow);
Get_MessageVector(strDriver,strUrl, strUserId,strPassword,
strNewPid, intLevel+1 , vecReturn);
}
rs.close();
conn.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
Hope this helps
Jeff Hu
-----Original Message-----
From: Vaishali Joshi [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 07, 2000 12:42 PM
To: [EMAIL PROTECTED]
Subject: Building an org chart?
Hi
does anyone has any leads on building an org chart using Java? I have an
employee table, which stores employee's info, his manager and his level. I
need to build a tree structure out of it. I would really appreciate if
anyone can throw some ideas..
Thanks
Vaishali
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
