1 1983-03-12 00:00:00.0 2080-03-12 00:00:00 liushengwei 1 2 1985-01-23 00:00:00.0 1986-04-15 00:00:00 lucy 1 3 1986-03-12 00:00:00.0 2002-02-02 00:00:00 jack 1 4 1963-03-12 00:00:00.0 2006-12-12 00:00:00 alibert 0 5 1986-12-12 00:00:00.0 2004-12-12 00:00:00 lili 0 6 1853-01-01 00:00:00.0 2001-01-01 00:00:00 mick 1 7 1963-01-01 00:00:00.0 1988-02-02 00:00:00 hoho 0 8 1569-05-05 00:00:00.0 2010-03-03 00:00:00 koko 2 9 1589-05-02 00:00:00.0 1986-02-04 00:00:00 nana 2 11 1983-03-12 00:00:00.0 19841027 asd 1 ------------------------------------------------------------------------- 这段代码为生成后的XML文件!不够生成的不是地方 没生成到WebRoot下 郁闷!现在正在想呢。。现在正在想呢!!! -------------------------------------------------------------------------
This is my JSP page.
------------------------------------------------------------------------- 这段代码是用来取XML文件中的信息 不过搞错了 没取出来 不知道是路径的问题还是 语法的问题 郁闷呢!继续思考 ------------------------------------------------------------------------- package com; import javax.xml.parsers.DocumentBuilderFactory; import javax.xml.parsers.DocumentBuilder; import javax.xml.transform.TransformerFactory; import javax.xml.transform.Transformer; import javax.xml.transform.dom.DOMSource; import javax.xml.transform.stream.StreamResult; import org.w3c.dom.Document; import org.w3c.dom.Element; import org.w3c.dom.Text; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.util.Vector; public class Business { public Business() { } public static void convertToXml(ResultSet rs,String xmlFileName) { try { ResultSetMetaData rsmd = rs.getMetaData(); Vector columns=new Vector(); for(int i=1;i<=rsmd.getColumnCount();i++) { columns.addElement(rsmd.getColumnName(i)); } DocumentBuilderFactory dfactory=DocumentBuilderFactory.newInstance(); DocumentBuilder dbuilder=dfactory.newDocumentBuilder(); Document doc=dbuilder.newDocument(); Element root=doc.createElement("datatable"); doc.appendChild(root); while(rs.next()) { Element datarow=doc.createElement("datarow"); root.appendChild(datarow); for(int i=0;i