用JDOM實現資料庫到XML的轉換

<%@page contentType="text/html;charset=GBK"%>
<HTML>
<HEAD>
<TITLE>用JDOM實現資料庫到XML的轉換</TITLE>
</HEAD>
<BODY>
<%@page import = "org.jdom.*"%>
<%@page import = "org.jdom.output.*"%>
<%@page import = "java.*"%>
<%@page import = "java.sql.*" %>
<%@page import = "DB.*" %>
<%@ page import="java.io.*" %>
<%
String sql = null;
ResultSet rs = null;
Document document=new Document(new Element("PUSH統計"));//建立文檔
int count = 1;
String sElement = "使用者";
try{
DBGAMEConnection cn = new DBGAMEConnection();
sql = "SELECT * FROM tbl_wappush WHERE length(sTUID)>20 ORDER BY dPushDate";
rs = cn.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData(); //擷取欄位名
int numberOfColumns = rsmd.getColumnCount(); //擷取欄位數
while (rs.next()){
sElement = "使用者" + count;
Element element0=new Element(sElement); //建立元素 產生JDOM樹
document.getRootElement().addContent(element0);
for (int i=1; i<=numberOfColumns;i++)
{
String date=rs.getString(i); //代碼轉換
Element element=new Element(rsmd.getColumnName(i)).setText(date);
element0.addContent(element);
}
count++;
}
rs.close();
}catch (SQLException e){