³¬¼¶¼òµ¥£ºÊ¹ÓÃFOR XML AUTO¿ØÖÆXMLÊä³ö(Òëת)
ÕâƪÎÄÕÂÃèÊöÈçºÎͨ¹ýʹÓÃFOR XML AUTO¸üºÃµÄ¿ØÖÆXMLÊä³ö¸ñʽ¡£ÀýÈçÌí¼ÓXML±ê¼Ç¡£ÓÃÕâ¸öÀ´Ìæ´úÄÑÓÚÀí½âµÄFOR XML EXPLICIT Óï¾ä¡£Èç¹ûÄãÔÚÓ¦ÓóÌÐòÖм´½«·´ÐòÁл¯Êä³öµÄXML£¬Äã¾Í»á¾õµÃÕâ¸öÐÅÏ¢¶ÔÄãÓÐÓá£
ÔÚFor XML´Ó¾äÖУ¬Äúͨ³£Ê¹ÓÃÏÂÁз½Ê½Ö®Ò»£º
RAW
AUTO
EXPLICIT
PATH
Èç¹ûÄãÏëÍêÈ«ÕƿزúÉúµÄXML£¬¿ÉÒÔʹÓÃFOR XML EXPLICIT¡£µ«ÊÇËüÀí½âÆðÀ´Ï൱µÄÀ§ÄÑ£¬ºóÃ滹Ҫά»¤¸´ÔÓµÄselectÓï¾ä¡£FOR XML AUTO ÄܲúÉú×î¿É¶ÁµÄSELECTÓï¾ä£¬µ«ÊÇËüÒ²ÓÐȱµã£¬²»ÈÝÒ׿ØÖÆÉú³ÉµÄXML¡£µ«Ê¹ÓÃһЩ¼¼ÇÉ£¬ÀýÈçͨ¹ýʹÓöîÍâµÄPATHÑ¡ÏÄã¿ÉÒÔ×öһЩ³¬¹ýÄãÔ¤ÆÚµÄÊÂÇé¡£RAWÑ¡ÏîÊǺÜÉÙʹÓã¬Òò´Ë²»ÌÖÂÛ¡£PATH Ñ¡ÏîÔÊÐíÄúºÜÈÝÒ׵ػìºÏÊôÐÔºÍÔªËØ¡£ÏÖÔÚ£¬ÈÃÎÒÃÇÀ´Ê¹ÓÃFOR XML AUTO¡£
ÔÚÕâ¸öÀý×ÓÖУ¬ÎÒÃÇʹÓõÄÊÇ1£ºN¹ØϵµÄÁ½¸ö¼òµ¥µÄÊý¾Ý±í¡£Ò»¸ö±í£¨SalesOrder£©°üº¬¿Í»§ÐÅÏ¢µÄ¶©µ¥£¬ÀýÍâÒ»ÕÅ±í£¨Items£©Öаüº¬µÄ¾ßÌåµÄÏî¡£Ò»¸ö¶©µ¥¿ÉÒÔÓжà¸öÏһ¸öÏîÍùÍùÖ»ÊôÓÚÒ»¸ö¶©µ¥¡£
ÒÔ×îÈÝÒ׵ĿªÊ¼¡£
SELECT * from salesorder
²úÉú£º
ordernumber customername customerstreet
----------- ------------ --------------
1 parker first av
2 lesley sec av
Èç¹ûÄãÏëҪʹ½á¹û¼¯ÊÇXML£¬ÎÒÃÇÌí¼ÓFOR XML AUTO Óï¾ä£º
SELECT * from salesorder FOR XML AUTO
Ëü²úÉú£º
<salesorder ordernumber="1" customername="parker" customerstreet="first av"/>
<salesorder ordernumber="2" customername="lesley" customerstreet="sec av"/>
ÏÖÔÚ£¬×Ö¶ÎÊÇ×÷ÊôÐԵģ¬´ó¶àÊýÇé¿öÏÂÏ£ÍûËûÃÇÊÇÔªËØ¡£ÎªÁË×öµ½Õâµã£¬Ìí¼ÓELEMENTS ²ÎÊý
SELECT * from salesorder FOR XML AUTO, ELEMENTS
 
Ïà¹ØÎĵµ£º
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Xml;
private XmlDo ......
/*
* XMLTool.cpp ÅäÖÃÎļþ½âÎö¶¯Ì¬¿â×ÊÔ´Îļþ
* Ö÷ÒªÊä³öº¯Êý½Ó¿Ú·Ö±ðʵÏÖ¶ÔÅäÖÃÎļþµÄ¶ÁÈ¡ºÍдÈ룬Õë¶Ô½á¹û¼¯µÄ¸´ÖÆÇå¿Õ£¬ºÍÁ½¸ö×Ö·û´®´¦Àíº¯Êý
* ¶ÁÈ¡ÅäÖÃÎļþ½Ó¿Ú £ºint ReadXMLFile(XML_Node_Vector *XmlNodeVector, string filepath);
* Ð´È ......
SQL Server¸ù¾Ý²éѯ½á¹û,Éú³ÉXMLÎļþ
À´Ô´£º²»Ïê ×÷ÕߣºØýÃû ʱ¼ä£º2009-3-6 22:15:58 ·¢²¼£ººÚ¿ÍÈí¼þÔ°
/*
'bcp' ²»ÊÇÄÚ²¿»òÍⲿÃüÁҲ²»ÊÇ¿ÉÔËÐеijÌÐò£¿
¿´¿´ÔÚC:\Program Files\Microsoft SQL Server\80\Tools\BinnÀïÃæÓÐûÓÐbcp.exeÕâ¸öÎļþ
È»ºó¿´¿´pathÀïÃæ¼ÓC:\Program Files\Microso ......
package com.beckham.dom;
import java.io.File;
import java.io.FileWriter;
import org.dom4j.Document;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
import org.dom4j.io.OutputFormat;
import org.dom4j.io.XMLWriter;
/**
* @author ×÷Õß<Beckham>
* Email:gaowm0207@gmail.com ......