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
Win a copy of
Badass: Making Users Awesome
this week in the
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
(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-2015