[jdom-interest] SQL join -> Structured XML

[Nott, Matthias]

goes sort of the direction of program generators,
if you want to reimport xml into the db by transforming
your xml into e.g. stored proc calls. There's quite a lot
of material around on that.

M

-----Original Message-----
From: Philippe Lang [mailto:philippe.lang at attiksystem.ch]
Sent: Thursday, April 25, 2002 8:18 AM
To: jdom-interest at jdom.org
Subject: [jdom-interest] SQL join -> Structured XML


Hi,

I have written a set of classes that take as input the result of an SQL
query, with joined tables. Given some parameters you give to the classes
(groups, sort order...), very similar to what you can configure in
Access or Crystal Reports, it outputs an XML file, with the same data,
but in a structured way. It works with any number of joins.

I wonder if it would be a good idea to incorporate these classes in
JDOM? Or does that go beyond the scope of JDOM?


Example:
--------

(CachedRowSet)

A        P1   P2
A        P3   P4
A        P5   P6
B        P7   P8
B        P9   P10
A        P11  P12
C        P13  P14

gives...


(XML)

----- A ----- P1   P2
   |      |-- P3   P4
   |      |-- P5   P6
   |      |-- P11  P12
   |
   |- B ----- P7   P8
   |      |-- P9   P10
   |
   |- C ----- P13  P14



-------------------------
Philippe Lang
Attik System
http://www.attiksystem.ch 
_______________________________________________
To control your jdom-interest membership:
http://lists.denveronline.net/mailman/options/jdom-interest/youraddr@yourhos
t.com