XML¸ñʽת»¯¹¤¾ßÀà
	
    
    
	»ùÓÚdom4jµÄXML¸ñʽת»¯Àà
package com.lixi.util;
import java.io.BufferedWriter;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;
import org.dom4j.Document;
import org.dom4j.io.OutputFormat;
import org.dom4j.io.SAXReader;
import org.dom4j.io.XMLWriter;
/**
 * <p>Title: </p>
 * <p>Description: XML¸ñʽת»¯¹¤¾ß</p>
 * <p>Copyright: Copyright (c) 2010-02-05</p>
 * <p>Company: </p>
 * @author li.xi
 * @version 1.0
 */
public class XmlHelper {
	public XmlHelper() {
	}
	
	/**
	 * String¸ñʽµÄXMLתDocument
	 * @param xml
	 * @param charSet ×Ö·û¼¯±àÂëÉèÖà È磺GBK
	 * @return Document
	 * @throws Exception
	 */
	public static Document buildDoc(String xml, String charSet)
			throws Exception {
		InputStream inputStream = new ByteArrayInputStream(xml.getBytes());
		SAXReader reader = new SAXReader();
		InputStreamReader inputStreamReader = new InputStreamReader(
				inputStream, charSet);
		Document document = reader.read(inputStreamReader);
		inputStreamReader.close();
		return document;
	}
	/**
	 * Document¸ñʽµÄXMLתString
	 * @param document
	 * @param charSet ×Ö·û¼¯±àÂëÉèÖÃ
	 * @return String
	 * @throws Exception
	 */
	public static String setCharSet(Document document, String charSet)
			throws Exception {
		OutputFormat format = OutputFormat.createPrettyPrint();
		format.setEncoding(charSet);
		ByteArrayOutputStream fos = new ByteArrayOutputStream();
		BufferedWriter bw = new BufferedWriter(new OutputStreamWriter(fos,
				charSet));
		XMLWriter writer = new XMLWriter(bw, format);
		writer.write(document);
		bw.close();
		String restr = fos.toString();
		fos.close();
		return restr;
	}
}
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    ÏÈ´´½¨Êý¾ÝÈ»ºóÉú³ÉÏàÓ¦µÄxmlÎļþ
 DataSet ds = new DataSet();
            #region Parent Table
            DataTable dt1 = new DataTable("Parent");
     ......
	
    
        
    
    DOMÊÇ»ùÓÚÆ½Ì¨¡¢ÓïÑÔÎ޹صĹٷ½W3C±ê×¼¡£»ùÓÚÊ÷µÄ²ã´Î£¬ÆäÓŵãÊÇ¿ÉÒÔÒÆÖ²£¬±à³ÌÈÝÒ×£¬¿ª·¢ÈËÔ±Ö»ÐèÒªµ÷Óý¨Ê÷µÄÖ¸Áî¡£ÆäȱµãÊǼÓÔØ´óÎļþ²»ÀíÏë¡£
¡¡¡¡SAXÊÇ»ùÓÚʼþÄ£Ð͵ģ¬ËüÔÚ½âÎö XML ÎĵµµÄʱºò¿ÉÒÔ´¥·¢Ò»ÏµÁеÄʼþ£¬µ±·¢ÏÖ¸ø¶¨µÄtagµÄʱºò£¬Ëü¿ÉÒÔ¼¤»îÒ»¸ö»Øµ÷·½·¨£¬¸æË߸÷½·¨Öƶ¨µÄ±êÇ©ÒѾÕÒµ½¡£ÀàËÆÓëÁ÷ýÌåµÄ½ ......
	
    
        
    
    1. »ù´¡£º¶ÔXML½øÐмòµ¥µÄ²éѯ, ²åÈë, ɾ³ý, ±à¼²Ù×÷
ÔÚÊý¾ÝÁ¿²»ÊǺܴóµÄÇé¿öÏ£¬¿ÉÒÔÓÃxml´úÌæÊý¾Ý¿â´æ´¢Êý¾Ý£¬µ«ÊÇÒª¶¨ÒåxsdÎļþÀ´ÑéÖ¤xmlÎļþ£¬±£Ö¤xmlÊý¾Ý¸ñʽ¡£
ÒÔÏÂÍøÒ³½éÉÜÁËÈçºÎÀûÓÃC#ʵÏÖxmlµÄ²éѯ£¬²åÈ룬ɾ³ýºÍ¸üвÙ×÷£¬Õâ±íÃ÷xml¿ÉÒÔ´úÌæÊý¾Ý¿â´æ´¢Ò»¶¨Á¿µÄÊý¾Ý¡£
http://blog.csdn.net/cmoonc/archive/20 ......
	
    
        
    
    //pugxml.h
///////////////////////////////////////////////////////////////////////////////
//
// Pug XML Parser - Version 1.0002
// --------------------------------------------------------
// Copyright (C) 2003, by Kristen Wegner (kristen@tima.net)
// Released into the Public Domain. Use at yo ......
	
    
        
    
    DECLARE @x xml 
SET @x='
<root>
  <ShopAccount>
    <ActivityType>IA - PM Standing WO (for LPI report)</ActivityType>
    <ProjectNo>R</ProjectNo>
  </ShopAccount>
  <ShopAccount>
     ......