<%@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){ if(rs!=null)rs.close(); e.printStackTrace(); } //创建一个statement
XMLOutputter outp = new XMLOutputter(); outp.output(document, new FileOutputStream("/home/tomcat/webapps/game/data.xml")); //输出XML文档 //out.print("XML 文档生成完毕!"); %> <a href="http://xlincn/game/data.xml">点击打开产生的XML文档 </a> </BODY> </HTML>

|