Total members 11867 |It is currently Sun Jan 23, 2022 5:37 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





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




Author:
Proficient
User avatar Posts: 280
Have thanks: 1 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.

_________________
Please recommend my post if you found it helpful


Author:
Proficient
User avatar Posts: 228
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.


Author:
Newbie
User avatar Posts: 1
Have thanks: 0 time

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

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time

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


Author:
Newbie
User avatar Posts: 1
Have thanks: 0 time
Post new topic Reply to topic  [ 5 posts ] 

  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     -  









Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com