This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Data result tree transform algorithm Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Data result tree transform algorithm" Watch "Data result tree transform algorithm" New topic

Data result tree transform algorithm

Steve Jiang
Ranch Hand

Joined: May 17, 2004
Posts: 107
The result set like below

L1 L2 L3
1 11 111
1 11 112
1 12 121
1 12 123
2 21 211
2 21 222

Need to output as tree,
output as tree,
L1 L2 L3

1 11 111,112
12 121,123
2 21 221, 222

I can think the basic idea for that to convert it as tree, but a lot of checking and seems very complexity.

it seems a general operation after DB extraction and wonder if there is better or existing soluation?

[ July 18, 2005: Message edited by: Steve Jiang ]
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30130

Any available solutions probably depend on the output format. What are you trying to create? A web page? A Swing app? Plain text?

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: Data result tree transform algorithm
Similar Threads
Merging Multiple Lists
SCJP 5: Mock questions
want to display the following output?
How many String objects ... ?!
test bed for array based list implementation