中文XML论坛--◆◆如何将ResulteSet对象转换为XML Document对象◆◆

贴子主题： ◆◆如何将ResulteSet对象转换为XML Document对象◆◆

本主题类别:

转换为XML Document对象不大明白???
我现在只能返回一个字符串（xml文本）？？
代码如下，还望再指点一下：
public class PullValuesForXML{
private String WriteForXML()throws Exception{
   String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
      String dbUrl = "jdbc:odbc:Book";
      String user ="";
      String password ="",inputname;
      Connection db = null;
      Class.forName(driverName);
      db = DriverManager.getConnection(dbUrl,user,password);
          //Execute the query to populate the ResultSet
     inputname="jsp";
      PreparedStatement  s=db.prepareStatement("select * from Book where bookname=? ");
      s.setString(1,inputname);
      ResultSet rs = s.executeQuery();
      //Check for data by moving the cursor to the first record (if there is one)
      final StringBuffer buffer = new StringBuffer(1024);
          //String re;
      if ((rs == null))
         return "there's no record1";
      if(!rs.next())
       return "there's no record2";
     buffer.append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n");
     buffer.append("<ResultSet>\n");
     rs = s.executeQuery();
     ResultSetMetaData rsmd = rs.getMetaData();
     int colCount = rsmd.getColumnCount();
     for (int id = 0; rs.next(); id++) {
        //格式为row id , col name, col context
        buffer.append("\t<book>").append("\n");
        for (int i = 1; i <= colCount; i++) {
         buffer.append(("\t\t<")+rsmd.getColumnName(i)+">");
         buffer.append(rs.getString(i));
         buffer.append("</"+rsmd.getColumnName(i)+">\n");
          }
         buffer.append("\t</book>\n");
       }
     buffer.append("</ResultSet>");
     return buffer.toString();
    }
   public static void main (String args[])throws Exception{
    String xmlstring =(new PullValuesForXML()).WriteForXML();
    System.out.println(xmlstring);
   }
}


	W 3 C h i n a ( since 2003 ) 旗下站点苏ICP备05006046号《全国人大常委会关于维护互联网安全的决定》《计算机信息网络国际联网安全保护管理办法》	78.125ms