Display data from database as Tree Structure in JSP

hi all,

i need some examples where ,i can extract data from database and
display that data as tree in jsp (as parent and child relation).

U can use JDBC API to extract the data from the DB and create beans for
indivdual records.
then tracking the parent child relation ship we can create tree structure

SAX or DOM model can be used for converting XML structure to Java object and
vice versa

or
One More option is to use Gwt(Google Web Toolkit) .It is Quite helpful To
dispaly data.

AnswerBot wrote:U can use JDBC API to extract the data from the DB and create beans for
indivdual records.
then tracking the parent child relation ship we can create tree structure

SAX or DOM model can be used for converting XML structure to Java object and
vice versa

or
One More option is to use Gwt(Google Web Toolkit) .It is Quite helpful To
dispaly data.

Could you post one example/code for create tree structure from database using jsp.
Thanks in advance.

do you have any database example that follow the tree structure.

I have this trouble too,
my database table structure is like this

create table business_unit(
business_unit_code varchar(10),
business_unit_name varchar(50),
business_unit_parent varchar(10),
business_unit_manager varchar(50),
description varchar(100)
)

and the data will be like this :

00001 Root - - root
00002 Head Office 1 00001 Erric Western this is head office
00003 Head Office 2 00001 Maybeline this is head office
00004 Regional 1 00002 Jonny
00005 Regional 2 00002 Belly


how to create tree for this data ? someone please help me...