Switch to full style
What's behind JSP & Servlets
Post a reply

Display data from database as Tree Structure in JSP

Wed Oct 22, 2008 1:04 am

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).



Re: Display data from database as Tree Structure in JSP

Wed Oct 22, 2008 1:06 am

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.

Re: Display data from database as Tree Structure in JSP

Sat Jan 31, 2009 7:42 am

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.

Re: Display data from database as Tree Structure in JSP

Sat Jan 31, 2009 1:02 pm

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

Re: Display data from database as Tree Structure in JSP

Thu Jun 18, 2009 2:24 pm

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...

Post a reply
  Related Posts  to : Display data from database as Tree Structure in JSP
 c++/data structure     -  
 database contents display in table format in swing     -  
 Delete data from database by ID in php     -  
 Delete data from database table in php     -  
 How to fill a ComboBox with data from a database in jsp     -  
 Displaying images from database instead of the url from data     -  
 form to insert data, upload many files and images , database     -  
 Take tree nodes then create new tree with another root     -  
 ASP file structure     -  
 What is the size of this Structure     -