File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
XML and Related Technologies
SQL Statements in XML document
Joined: Nov 16, 2005
Jan 22, 2006 23:01:00
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 ...
Joined: Oct 14, 2005
Jan 23, 2006 10:38:00
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
complex sql statements questions in interview, need info for job, please help!
How to trace SQL statements ?
Running .sql File in java
Trigger Function Problem
XML reporting and look query
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014