ÀûÓÃSqlHelper(ExecuteXmlReaderʹÓÃ)£¬×ª»»µ½xml¸ñʽ
ÀûÓÃsqlhelperÖеÄExcuteXmlReader·½·¨£¬¶ÁÈ¡Êý¾Ý²¢±£´æÎªxmlÎļþ
string strConn = Properties.Settings.Default.Connections;
SqlConnection connection = new SqlConnection(strConn);
---×¢Ò⣺ºóÃæµÄfor¸ñʽ
string strsql = "select * from p where name=@name and other=@other FOR XML AUTO,root('root'),elements";
SqlParameter[] sqlp = new SqlParameter[2];
sqlp[0] = new SqlParameter("@name", "pp");
sqlp[1] = new SqlParameter("@other", "ss");
xr = SqlHelper.ExecuteXmlReader(connection, CommandType.Text, strsql,
sqlp);
XmlDocument xml = new XmlDocument();
xml.Load(xr);
xml.Save(Application.StartupPath + "\\test1.xml");
Ïà¹ØÎĵµ£º
Dom4JÊÇÒ»¸ö¿ªÔ´µÄÓÅÐãµÄXML½âÎöAPI£¬ÏÖÔÚÔ½À´Ô½¶àµÄÏîÄ¿ÖпªÊ¼²ÉÓÃÕâÖÖ½âÎö·½Ê½£¬ÆäÖаüº¬ÁËÖøÃûµÄHibernate¡£ÕâÀïÎÒÃÇʹÓÃDom4J½âÎöÒ»¸ö´øÃüÃû¿Õ¼äµÄCXFµÄSpringÅäÖÃÎļþ¡£Ïȵ¼Èëdom4j-1.6.1.jar
spring ÅäÖÃÎļþ applicationContext-cxf.xml:
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns=" ......
ÎļþÈçÏÂ
<BODY>
<SCRIPT src="swfobject.js"
type=text/javascript></SCRIPT>
<SCRIPT language=javascript>
var flashvars = {};
flashvars.myxmlpath = 'content.xml';
flashvars.type = 'content';
flashvars.decription = '0';
flashvars.textstyle = '';
flashvars.de ......
XML CDATA Îı¾
ËùÓÐ XML ÎĵµÖеÄÎı¾¾ù»á±»½âÎöÆ÷½âÎö¡£
Ö»ÓÐ CDATA Çø¶Î£¨CDATA section£©ÖеÄÎı¾»á±»½âÎöÆ÷ºöÂÔ¡£
Parsed Data
XML ½âÎöÆ÷ͨ³£»á½âÎö XML ÎĵµÖÐËùÓеÄÎı¾¡£
µ±Ä³¸ö XML ÔªËØ±»½âÎöʱ£¬Æä±êǩ֮¼äµÄÎı¾Ò²»á±»½âÎö£º
<message>´ËÎı¾Ò²»á±»½âÎö</message>
½âÎöÆ÷Ö®ËùÒÔÕâô×öÊÇÒòÎ ......
ͨ¹ýÀí½â´íÎóµÄ±àÂ뷽ʽ£¬¿ÉÒÔ¸üºÃµØÁ˽âÈçºÎÕýÈ·µØ½øÐбàÂë¡£µ±È»£¬±àд Asynchronous JavaScript™ +
XML£¨Ajax£©ÓÐÕýÈ·µÄ·½·¨£¬Ò²ÓдíÎóµÄ·½·¨¡£±¾ÎĽ«ÌÖÂÛһЩÐèÒª±ÜÃâµÄ³£¼û±àÂëʵ¼ù¡£
Èç¹ûÈËÃÇÔÚµÚÒ»´Î¾ÍÄܹ»½«ËùÓÐÊÂÇéÈ«²¿×ö¶Ô£¬ÄÇôÕâ¸öÊÀ½ç½«±äµÃÍêÈ«²»Í¬¡£Ajax Ò²ÊÇÈç´Ë¡£ÎÒ×öÁË´óÁ¿µÄ¹¤×÷ÒÔÖ§³Ö Ajax
......
¡¡¡¡Ò»¡¢ XML ¼ò½é
¡¡¡¡XML£¨Xtensible Markup Language£¬¼´À©Õ¹±ê¼ÇÓïÑÔ£©µÄ·¢Õ¹ÆðÔ´ÓÚ1996Äê¡£µ±Ê±£¬³ö°æ½ç¾ÞÍ·ºÍWebÒµÄÚÈËÊ¿¾¹ý¹²Í¬ÌÖÂÛ£¬Ìá³öÁË´´½¨SGML£¨Standard Generalized Markup Language£¬¼´±ê׼ͨÓñêʶÓïÑÔ£©×Ó¼¯£¨HML£©µÄ½¨Òé¡£¸Ã×Ó¼¯×¨ÓÃÓÚWeb£¬¾ßÓпÉÀ©Õ¹£¨»ò¿ÉÀ©³ä£©ÐÔ£¬²¢ÇÒÄÜÀûÓýṹ»¯±ê¼ÇÓïÑÔµÄËùÓÐ ......