在while里给root添加一个person元素,然后把for里所有的元素添加到person元素里就好了

解决方案 »

  1.   

    谢谢 问题 已解决  
     public void toXML() {
                    Document document = new Document(new Element("data"));// 创建文档,文档名称
                    try {
                            ResultSetMetaData rsmd = rs.getMetaData(); // 获取字段名                        int numberOfColumns = rsmd.getColumnCount(); // 获取字段数                        int i = 0;                        while (rs.next()) { // 将查询结果取出
                          
                                    Element nameElement = new Element("person");//jia   de
                                   
                                    document.getRootElement().addContent(nameElement);//wo shan de 
                                    for (i =1; i <= numberOfColumns; i++) {
                                            String data = new String(rs.getString(i));
                                            Element element = new Element(rsmd.getColumnName(i))
                                                           .setText(data);
                                           
                                           nameElement.addContent(element);//jia de  
                                          
                                          
                                         
                                            
                                    } 
                                  
                            }
                            XMLOutputter outp = new XMLOutputter(); // 代码转换
                            outp.output(document, new FileOutputStream(
                                            "e:\\lianxi\\databasetoxmlfile.xml"));                        // 输出XML文档
                            System.out.println("XML 文档生成完毕!");
                            outp.outputString(document);
                    } catch (Exception e) {
                            System.out.print(e.getMessage());
                    }
            }