File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes XML and Related Technologies and the fly likes SQL Statements in XML document Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Badass: Making Users Awesome this week in the Game Development forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "SQL Statements in XML document" Watch "SQL Statements in XML document" New topic

SQL Statements in XML document

Sandeep Shahane

Joined: Nov 16, 2005
Posts: 8
I'm new to XML. I wish to store all my application SQL statements in an XML file. Can anybody please guide me where can I find XML strucutre for the same and XML parsers also.
Is using XML for storing SQL statements is a good practice ?

Sandeep L. Shahane<br />SCJP 1.4, SCWCD J2EE 1.4, <br />SCBCD J2EE 1.3 ...
Paul Clapham

Joined: Oct 14, 2005
Posts: 19357

For beginners, just use the XML parser (and other tools) built into Java (1.4 or later). There are many ways to store SQL statements in XML. The simplest is like this:

<SQL>Select name, address from supplier</SQL>

Or you could break the statement up into its parts and store them in separate elements. I would suggest learning the basics of XML before you make any decisions on how to use it.
It is sorta covered in the JavaRanch Style Guide.
subject: SQL Statements in XML document