convert java object from sql to xml

Question

Is there a way or a function in java where java can create several xml documents for each customer that i am queering from a sql db?

PreparedStatement statement = connection.prepareStatement("SELECT (sqlstuff), (sqlstuff) , (sqlstuff) , (sqlstuff) , (sqlstuff) ,(sqlstuff) , (sqlstuff) , " + "(sqlstuff) , (sqlstuff) , (sqlstuff) , (sqlstuff) , (sqlstuff) , (sqlstuff) , (sqlstuff) , (sqlstuff#), (sqlstuff#) OST00008 FROM filetype");

  ResultSet resultSet = statement.executeQuery();

Luca · Accepted Answer · 2012-03-27 18:28:50Z

2

I suggest you this clean way:

Define your Customer class in java
Create a list of Customer from database rows
Convert your list of Customer in xml (using Jaxb for example)

answered Mar 27, 2012 at 18:28

Luca

4,2831 gold badge23 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alex Marshall · Accepted Answer · 2012-03-27 18:42:20Z

0

The easiest thing I've found was to use an ORM tool like Hibernate to map the objects into a database for me, and then use JAXB as well. I'd put the Hibernate annotations on the object's fields, and the XML annotations on the object's property getters, and I had to write almost no serialization code for either, only what was required to integrate with the two frameworks.

answered Mar 27, 2012 at 18:42

Alex Marshall

10.4k17 gold badges76 silver badges118 bronze badges

Collectives™ on Stack Overflow

convert java object from sql to xml

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related