java生成xml文件

/*
* Copyright 2013 The EGF Co,. Ltd.
* site: http://www.egfit.com
* file: $Id$
* created at:2013-11-28
*/
package com.egf.qingbao;

import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;

import org.jdom.Document;
import org.jdom.Element;
import org.jdom.JDOMException;
import org.jdom.output.Format;
import org.jdom.output.XMLOutputter;

/**
* 生成resources.xml配置文件
*
* @author xh
* @version $Revision: 1.1 $
* @since 0.1
*/
public class CreateCaseXML implements CreateCaseService {
private DBHelper db = new DBHelper();
private Connection conn = null;
private PreparedStatement pre = null;
private ResultSet rs = null;

/**
* @throws IOException
* @throws JDOMException
*/
public void BuildXMLDoc(String ajcode) {
// 创建根节点 list
Element root = new Element("list");
// 将根节点添加到文档中
Document doc = new Document(root);
// 查询数据库
try {
conn = db.getConnection();
String sql = "select j.slajjd,j.slajmc,j.slajlb,j.slajla,j.slajlc,j.sldbjb,j.slfarq,j.slfaqh,j.slfadz,j.sljyaq,j.ajlarq,j.ajparq from jjsldj j where j.ajcode=?";
pre = conn.prepareStatement(sql);
pre.setString(1, ajcode);
System.out.println("sql语句: " + sql);
rs = pre.executeQuery();
// 此处遍历数据库表的结果集操作;
while (rs.next()) {
// 创建节点 user
Element elements = new Element("case");
// 给user节点添加属性id
//elements.setAttribute("id", "i");
elements.addContent(new Element("ajcode").setText(ajcode));
elements.addContent(new Element("slajjd").setText(rs.getString("slajjd")));
elements.addContent(new Element("slajjd").setText(rs.getString("slajmc")));
elements.addContent(new Element("slajlb").setText(rs.getString("slajlb")));
elements.addContent(new Element("slajlc").setText(rs.getString("slajla")));
elements.addContent(new Element("slajla").setText(rs.getString("slajlc")));
elements.addContent(new Element("sldbjb").setText(rs.getString("sldbjb")));
elements.addContent(new Element("slfarq").setText(rs.getString("slfarq")));
elements.addContent(new Element("slfaqh").setText(rs.getString("slfaqh")));
elements.addContent(new Element("slfadz").setText(rs.getString("slfadz")));
elements.addContent(new Element("sljyaq").setText(rs.getString("sljyaq")));
elements.addContent(new Element("ajlarq").setText(rs.getString("ajlarq")));
elements.addContent(new Element("ajparq").setText(rs.getString("ajparq")));
// 给父节点list添加user子节点
root.addContent(elements);
}
Format format = Format.getPrettyFormat();
format.setEncoding("utf-8");
format.setIndent("   ");//设置缩进
XMLOutputter XMLOut = new XMLOutputter(format);
String name=new SimpleDateFormat("yyyyMMddHHmm").format(new Date());
XMLOut.output(doc, new FileOutputStream("D:\\case"+name+".xml"));
// 输出sample.xml文件
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
rs.close();
pre.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
e.printStackTrace();
}
}
}

public static void main(String[] args) {
       try {
       CreateCaseXML cixml = new CreateCaseXML();
       System.out.println("生成xml文件*************");
       Long startTime  = System.currentTimeMillis();
       cixml.BuildXMLDoc("A4101000000002012040032");
       Long endTime = System.currentTimeMillis();
       System.out.println("生成xml文件成功，总耗时为： "+(endTime-startTime)/1000+"秒");
} catch (Exception e) {
e.printStackTrace();
}
}
}