ramnram
asked on
How to save Document object into .xml file
1) Iam converting JDBC ResultSet into XML.
2) Iam done with converting JDBC ResultSet to Document.
3) My query is, how can I save it into a .xml file using FileOutPutStream. For your perusal I've attached the code.
4) I've converted it into string and stored in xml file. But I don't find any wellformed xml content in the xml file
public Document getCustomerList()
{
Document document = null;
try
{
statement = connection.createStatement ();
resultset = statement.executeQuery("se lect *from temp");
document = toDocument(resultset);
resultset.close();
statement.close();
}
catch(Exception e)
{
e.printStackTrace();
}
return document;
}
public Document toDocument(ResultSet resultset) throws ParserConfigurationExcepti on, SQLException
{
DocumentBuilderFactory factory = DocumentBuilderFactory.new Instance() ;
DocumentBuilder builder = factory.newDocumentBuilder ();
Document document = builder.newDocument();
ResultSetMetaData rsmd = resultset.getMetaData();
int colCount = rsmd.getColumnCount();
Element results = document.createElement("Re sults");
document.appendChild(resul ts);
while(resultset.next())
{
Element rows = document.createElement("Ro ws");
results.appendChild(rows);
for(int i = 1;i <= colCount;i++)
{
String columnName = rsmd.getColumnName(i);
Object value = resultset.getObject(i);
Element node = document.createElementcolu mnName);
node.appendChild(document. createText Node(value .toString( )));
rows.appendChild(node);
}
}
return document;
}
public static void main(String[] args) throws Exception
{
JavaXML jxml = new JavaXML();
Document document = jxml.getCustomerList();
byte buffer[] = (document.toString()).getB ytes();
OutputStream xmlfile = new FileOutputStream("xmlfile. xml");
xmlfile.write(buffer);
xmlfile.close();
}
2) Iam done with converting JDBC ResultSet to Document.
3) My query is, how can I save it into a .xml file using FileOutPutStream. For your perusal I've attached the code.
4) I've converted it into string and stored in xml file. But I don't find any wellformed xml content in the xml file
public Document getCustomerList()
{
Document document = null;
try
{
statement = connection.createStatement
resultset = statement.executeQuery("se
document = toDocument(resultset);
resultset.close();
statement.close();
}
catch(Exception e)
{
e.printStackTrace();
}
return document;
}
public Document toDocument(ResultSet resultset) throws ParserConfigurationExcepti
{
DocumentBuilderFactory factory = DocumentBuilderFactory.new
DocumentBuilder builder = factory.newDocumentBuilder
Document document = builder.newDocument();
ResultSetMetaData rsmd = resultset.getMetaData();
int colCount = rsmd.getColumnCount();
Element results = document.createElement("Re
document.appendChild(resul
while(resultset.next())
{
Element rows = document.createElement("Ro
results.appendChild(rows);
for(int i = 1;i <= colCount;i++)
{
String columnName = rsmd.getColumnName(i);
Object value = resultset.getObject(i);
Element node = document.createElementcolu
node.appendChild(document.
rows.appendChild(node);
}
}
return document;
}
public static void main(String[] args) throws Exception
{
JavaXML jxml = new JavaXML();
Document document = jxml.getCustomerList();
byte buffer[] = (document.toString()).getB
OutputStream xmlfile = new FileOutputStream("xmlfile.
xmlfile.write(buffer);
xmlfile.close();
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
String fileNamePath = "myDoc.xml";
StringBuffer thisData = new StringBuffer(document.toSt
try
{
FileOutputStream outputFile = new FileOutputStream(fileNameP
FileChannel outChannel = outputFile.getChannel(); // Channel for file stream
try
{
//** finally write the buffered bytes to the file using file channel
outChannel.write(ByteBuffe
}
catch(IOException ex1)
{
//ex1.getMessage();
}
}
catch(FileNotFoundExceptio
{
//ex.getMessage();
}
//Naeem Shehzad Ghuman