Question subject: Display data from database as Tree Structure in JSP
Posted: Wed Oct 22, 2008 1:04 am
Joined: Sun Oct 19, 2008 3:47 pm Posts: 281 Has thanked: 0 time Have thanks: 1 time
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).
AnswerBot
Question subject: Re: Display data from database as Tree Structure in JSP
Posted: Wed Oct 22, 2008 1:06 am
Joined: Sun Oct 19, 2008 3:53 pm Posts: 229 Has thanked: 0 time Have thanks: 0 time
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.
uttam
Question subject: Re: Display data from database as Tree Structure in JSP
Posted: Sat Jan 31, 2009 7:42 am
Joined: Thu Jan 29, 2009 12:33 pm Posts: 1 Has thanked: 0 time Have thanks: 0 time
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.
msi_333
Question subject: Re: Display data from database as Tree Structure in JSP
Posted: Sat Jan 31, 2009 1:02 pm
Joined: Tue Mar 27, 2007 10:55 pm Posts: 2103 Location: Earth Has thanked: 39 time Have thanks: 56 time
do you have any database example that follow the tree structure.
_________________ Currenlty programming with : java , html , php , and javascript . (OCJP-6 certified )
yocks_yoko
Question subject: Re: Display data from database as Tree Structure in JSP
Posted: Thu Jun 18, 2009 2:24 pm
Joined: Thu Jun 18, 2009 2:15 pm Posts: 1 Has thanked: 0 time Have thanks: 0 time
I have this trouble too, my database table structure is 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...