国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

  /** 
    將ResultSet轉(zhuǎn)化為XML文件 
    ResultSet怎么生成這里就不寫(xiě)了，我使用的是Oracle.JDBC 
    Types.DATE 不知道SQL Server里的類型叫什么 
    代碼沒(méi)有經(jīng)測(cè)試 
    -------JoeCom 2006-12-01------------- 
  **/ 
  public static void resultSetToString(ResultSet rs,StringBuffer sb) 
  { 
      /** xml document */ 
      Document document = DocumentHelper.createDocument();  
      Element root = document.addElement("ROWDATA"); 
      /** 用來(lái)轉(zhuǎn)換日期格式 **/  
      SimpleDateFormat fmt = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");   
      if (rs!=null)  
      {     
          try  
          { 
            while (rs.next())  
            {            
               Element row = root.addElement("ROW");  
               ResultSetMetaData rsmd = rs.getMetaData(); 
               int columnCount = rsmd.getColumnCount(); 
               for (int i = 0; i < columnCount; i++)  
               { 
                     /** 所有字段都大寫(xiě)輸出 **/ 
                     Element element = row.addElement(rsmd.getColumnName(i).toUpperCase()); 
                     if(rs.getObject(i) != null) 
                     { 
                       if (rsmd.getColumnType(i)==Types.DATE) 
                       { 
                          String dt = fmt.format(rs.getTimestamp(i)); 
                          element.setText(dt); 
                       }else  
                       { 
                          /** 將所有值都轉(zhuǎn)化為String **/ 
                          element.setText(String.valueOf(rs.getObject(i))); 
                       } 
                     } 
                     else 
                     { 
                        element.setText(""); 
                     }                
               } 
            } 
          }catch (SQLException ex)  
          { 
             ex.printStackTrace(); 
          } 
      } 
      /** 將document保存為本地xml文件 **/ 
      doc2XmlFile(document,"d:/test/1.xml"); 
  }