³¬¼¶¼òµ¥£ºÊ¹ÓÃ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
 
Ïà¹ØÎĵµ£º
ÔÚXMLÎĵµÖеÄËùÓÐÎı¾¶¼»á±»½âÎöÆ÷½âÎö¡£
Ö»ÓÐÔÚCDATA²¿¼þÖ®ÄÚµÄÎı¾»á±»½âÎöÆ÷ºöÂÔ¡£
½âÎöÊý¾Ý
XML ½âÎöÆ÷ͨ³£Çé¿öÏ»ᴦÀíXMLÎĵµÖеÄËùÓÐÎı¾¡£
µ±XMLÔªËØ±»½âÎöµÄʱºò£¬XMLÔªËØÄÚ²¿µÄÎı¾Ò²»á±»½âÎö:
<message>This text is also parsed</message>
XML½âÎöÆ÷ÕâÑù×öµÄÔÒòÊÇXMLÔªËØÄÚ²¿¿ÉÄÜ» ......
1. ¾ßÓÐÁ¼ºÃµÄ¸ñʽ
XML Îĵµ¸ñʽÊôÓÚÁ¼ºÃ¸ñʽµÄÎļþ¡£HTML ÎļþÖеıê¼Ç£¬ÓÐЩÊDz»ÐèÒª½áβ±ê¼ÇµÄ£¬Èç<br>£¬ÓÐÐ©ÍøÒ³È±ÉÙÈô¸É½áβ±ê¼Ç£¬ÕÕÑùÄÜÕýÈ·ÏÔʾ¡£¶øXML µÄ±ê¼ÇÒ»¶¨ÒªÓµÓнáβ±ê¼Ç£¬ÀýÈ磺
<name>ÕÅÈý</name>
¼´£¬XML ±ê¼ÇÒ»¶¨ÊdzÉË«³É¶ÔµÄ¡£Èç¹ûûÓнáβ±ê¼Ç£¬ÄÇôÔÚ½áÊøµÄ“>”Ç ......
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 ......
java´úÂë
package com.xml.action;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
public class XMLAction extends ActionSupport{
private static final long serialVersionUID = 1L;
private String username;
private String mobile;
public void setUs ......
TinyXML£ºÒ»¸öÓÅÐãµÄC++ XML½âÎöÆ÷
¶ÁÈ¡ºÍÉèÖÃxmlÅäÖÃÎļþÊÇ×î³£ÓõIJÙ×÷£¬ÊÔÓÃÁ˼¸¸öC++µÄXML½âÎöÆ÷£¬¸öÈ˸оõTinyXMLÊÇʹÓÃÆðÀ´×îÊæ·þµÄ£¬ÒòΪËüµÄAPI½Ó¿ÚºÍJavaµÄÊ®·ÖÀàËÆ£¬ÃæÏò¶ÔÏóÐԺܺá£
TinyXMLÊÇÒ»¸ö¿ªÔ´µÄ½âÎöXMLµÄ½âÎö¿â£¬Äܹ»ÓÃÓÚC++£¬Äܹ»ÔÚWindows»òLinuxÖбàÒë¡£Õâ¸ö½âÎö¿âµÄÄ£ÐÍͨ¹ý½âÎöXMLÎļþ£¬È»ºóÔ ......