Connecting Tech Pros Worldwide Forums | Help | Site Map

Help please about Converting XML back to Resultset....

jeffbroodwar's Avatar
Member
 
Join Date: Oct 2006
Posts: 118
#1: Nov 28 '06
Hi everyone ! i need help on how can i convert xml data to resultset.. actually i was able to convert ResultSet to XML (using MySQL database) the problem is how can i make my client program consume this xml file... please someone help me with this.... if possible also help me do the research.. i need to finish this before next week. no worries, it'll pay you good. knowing that only few people knows how to do this. it an achievement to be one of 'em. please take a look at the xml file : Format#1.xml

<?xml version="1.0" encoding="UTF-8" ?>
- <Results>
- <Row>
<id>1</id>
<name>Jeff</name>
</Row>
- <Row>
<id>2</id>
<name>Cherry</name>
</Row>
</Results>


note: i didn't use JDOM to do this.. i used the tutorial in developer.com. please help me do this.. thank you all ! ^^

Regards,
Jeff

Lives Here
 
Join Date: Sep 2006
Posts: 12,070
#2: Nov 28 '06

re: Help please about Converting XML back to Resultset....


Quote:

Originally Posted by jeffbroodwar

Hi everyone ! i need help on how can i convert xml data to resultset.. actually i was able to convert ResultSet to XML (using MySQL database) the problem is how can i make my client program consume this xml file... please someone help me with this.... if possible also help me do the research.. i need to finish this before next week. no worries, it'll pay you good. knowing that only few people knows how to do this. it an achievement to be one of 'em. please take a look at the xml file : Format#1.xml

<?xml version="1.0" encoding="UTF-8" ?>
- <Results>
- <Row>
<id>1</id>
<name>Jeff</name>
</Row>
- <Row>
<id>2</id>
<name>Cherry</name>
</Row>
</Results>


note: i didn't use JDOM to do this.. i used the tutorial in developer.com. please help me do this.. thank you all ! ^^

Regards,
Jeff

This question is not making much sense to me. From the specs

Quote:
public interface ResultSetA table of data representing a database result set, which is usually generated by executing a statement that queries the database.
What do you mean by convert xml data to resultset?
jeffbroodwar's Avatar
Member
 
Join Date: Oct 2006
Posts: 118
#3: Nov 29 '06

re: Help please about Converting XML back to Resultset....


i hope this will clear things up. what i need to do is to convert the xml file that i created in java back to resultset object so that the client will be able to consume xml files. i'm currently working on java webservices. the scenario goes like this :

my server creates xml file format of database then will pass this data to client. the client then converts it back to resultset format so that it can be used to present data in the client side.
Reply