File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 124
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
author & internet detective

Joined: May 26, 2003
Posts: 32817

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

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Data result tree transform algorithm
It's not a secret anymore!