´«ÖDz¥¿Í—XML»ù´¡£¨ÉÏ£©
½ñÌìÊÇÉϿεĵÚÒ»Ì죬ûÏëµ½µÚÒ»Ìì¾Í½²ÁËÄÇô¶àµÄ¶«Î÷£¬¿´ÁË¿´ÀÏʦµÄPPT£¬·¢ÏÖ¶«Î÷ËäÈ»¶à£¬µ«ÊǶ¼²»ÄÑÀí½â£¬»¹ÊDZȽÏÈÝÒ׵ġ£¹þ¹þ£¬µÃÒæÓÚÔÚ´«ÖÇ»ù´¡°àµÄ´¸Á¶£¬Ó¢Ã÷µÄ¾ö¶¨¾ÍÊÇ´ÓͷѧÆð¡£
¸Õ¹ýÍê´º½ÚÀÏ·½µÄ»°»¹ÊÇ˵µÄ²»ÊǺÜÁ÷Àû°¡£¨Òª¼ÓÇ¿ÆÕͨ»°Á·Ï°à¸£©£¬½ñÌ컨ÁËÒ»½Ú¿ÎµÄʱ¼äÔÚ½²eclipseµÄʹÓúÍһЩ³£ÓõĿì½Ý¼ü£¬ÆäËûµÄʱ¼äÖ÷Òª¾ÍÊÇÔÚ½²XML»ù´¡¡£XMLÕâ¸ö¶«Î÷°É£¬ÌýÆðÀ´»¹ÊDZȽϿÝÔïµÄ£¬²»ÊǺܺÃÍ棬¾ÍÊÇÒ»¸ö¿ÉÀ©Õ¹±ê¼ÇÓïÑÔ¡£
Ê×ÏÈ·½ÀÏʦ½²ÁËeclipseµÄ¼òµ¥Ê¹ÓÃÒÔ¼°³£ÓõĿì½Ý¼ü£º
ÄÚÈÝÌáʾ£ºalt+/
¿ìËÙÐÞ¸´£ºctrl+1
µ¼°ü£ºctrl+shift+o
¸ñʽ»¯´úÂë¿é£ºctrl+shift+f
ÏòÇ°Ïòºó£ºalt+·½Ïò¼ü £¨¾ÝÀÏʦ˵Õâ¸ö¶«Î÷¶ÔÒÔºóµÄ¹¤×÷Ê®·ÖµÄÓаïÖú£¬ÄÇÊÇÏ൱µÄ·½±ã°¡£©
È»ºó¾ÙÁËÒ»¸öÀý×Ó£¬Àý×Ӻܼòµ¥£¬µ«ÊÇͨ¹ýÕâ¸öÀý×ÓÀÏʦǿµ÷ÁËÒ»¸öÊ®·ÖÖØÒªµÄϸ½Ú£¬µ«·²Ð´ÀàÒ»¶¨Òª´ø°ü£¬ÕâÊÇ´úÂëµÄ¹æ·¶£¬ÒÔÇ°×ÜÊÇͼʡÊÂËùÒÔ¾Íȱʡ°ü£¬ÀÁµÃд£¬ÒÔºóÒ»¶¨ÒªÑø³ÉÁ¼ºÃµÄ±àÂëÏ°¹ß¡£Í¨¹ýÕâ¸öÀý×Ó»¹½²½âÁËdebugµÄʹÓãº
1.ÔÚÐèÒªµ÷ÊÔ³ÌÐòµÄÐÐÇ°´ò¶Ïµã
2.Ìø¹ýµ±Ç°ÐУ¬Ö´ÐÐÏÂÒ»ÐÐ
½ÓÏÂÀ´¾Í½øÈë½ñÌìµÄÖ÷ÌâÁË—XML:
¿ªÊ¼£¬ÀÏʦͨ¹ýÒ»¸öÖйúµÄÊ¡ÊйØϵµÄÊý¾Ýͼ£¬ÒýÈëÁËXML£¬ËµÃ÷ÁËÕâÀàÓйØϵµÄÊý¾ÝÊÇÈçºÎ±»´¦ÀíµÄ¡£XML—Extensible Markup Language¡£Ê×ÏÈÎÒÃÇÒªÖªµÀËüÊÇ×öʲôµÄÒÔ¼°ËüµÄÌص㣺ËüÊÇÓÃÀ´ÃèÊöÊý¾ÝµÄ£¬XML±ê¼Ç²¢²»ÊÇÔ¤Ïȹ涨ºÃµÄ£¬±ØÐë´´Ôì×Ô¼ºµÄ±ê¼Ç£¬Ò²¾ÍÊÇ˵ËùÓеıêÇ©¶¼ÊǸù¾ÝÐèÒª×Ô¼º´´½¨³öÀ´µÄ¡£XMLÊDZ»Éè¼ÆÓÃÀ´´æ´¢Êý¾Ý¡¢Ð¯´øÊý¾ÝºÍ½»»»Êý¾ÝµÄ£¬Ëü²»ÊÇΪÁËÏÔʾÊý¾Ý¶øÉè¼ÆµÄ¡£
XMLµÄÓï·¨¹æÔò¼È¼òµ¥ÓÖÑϸñ¡£XMLÎĵµÊ¹ÓÃÁË×ÔÃèÊöµÄºÍ¼òµ¥µÄÓï·¨£»ËùÓеÄXMLÎĵµ±ØÐëÓÐÒ»¸ö½áÊø±ê¼Ç£¬ÔÚXMLÎĵµÖÐ, ºöÂÔ½áÊø±ê¼ÇÊDz»·ûºÏ¹æ¶¨µÄ£»XML±ê¼Ç¶¼ÊÇ´óСдÃô¸ÐµÄ£»ËùÓеÄXMLÔªËرØÐëºÏÀí°üº¬£¬¾ÍÊÇ˵ÔÚXMLÖв»ÔÊÐí²»ÕýÈ·µÄǶÌ×°üº¬£»ËùÓеÄXMLÎĵµ±ØÐëÓÐÒ»¸ö¸ùÔªËØ£»ÊôÐÔÖµ±ØÐëʹÓÃÒýºÅ""£»Ê¹ÓÃXML£¬¿Õ°×½«±»±£ÁôÔÚXMLÎĵµÖУ¬¿Õ°×²¿·Ö²»»á±»½âÎöÆ÷×Ô¶¯É¾³ý¡£ÕâÀïҪעÒâÒ»µã£¬ÊôÐÔÖµÓõ¥ÒýºÅºÍË«ÒýºÅÊÇûÓÐÇø±ðµÄ¡£
ÏÂÃæ¾ÍÊÇÒ»¸ö¼òµ¥µÄXMLÎĵµ£º
<?xml version="1.0" encoding=
Ïà¹ØÎĵµ£º
ÎÊÌâ:
¸ù¾Ýgoogle¹æ¶¨£¬ÔÚ¸ø×Ô¶¯¸øÍøÕ¾Éú³Ésitemap.xmlµÄʱºò£¬ ¸ø¸ù½áµã¼ÓÈçÏÂÊôÐÔʱ£¬Óöµ½ÁËÂé·³
xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"
Óúܶ෽·¨£¬ÏñaddAttribute, addNamespce¶¼²»ÐÐ
½â¾ö·½·¨£º
Document document = DocumentHelper.createDocument();
Element root = document.addEl ......
USE Test
--Create 2 tables as an example
CREATE TABLE ExampleTable
(
[ID] int PRIMARY KEY
,[Name] nvarchar(256)
)
CREATE TABLE ExampleTable2
(
[ID] int PRIMARY KEY
,[Name] nvarchar(256)
)
----way1
SELECT *
from sys.objects [table]
WHERE
[Name] LIKE 'ExampleTable%'
FOR XML AUTO, ROOT ......
ÏñÔÚ×ùµÄ¸÷λһÑù£¬ÓÉÓÚ×ÔÉíµÄÐËȤ£¬ÎÒ¶ÔAJAX±à³Ì·½ÃæµÄÑо¿ÊdzÖÐø²»¶ÏµÄ¡£ËæןÃÁìÓòµÄÉîÈ룬ÎÒÔ½À´Ô½·¢¾õËùνµÄä¯ÀÀÆ÷DOM£¬¼´HTML DOM£¬ÊÇÒ»¸ö·Ç³£ÖµµÃ¹Ø×¢µÄµã¡£Õâ¹ÛµãÔÚÓëͬÐÐÃǽ»»»Òâ¼ûµÄʱºòÒ²Ôø̸µ½¹ý£¬¾ÍÊÇ£¬ÎÒÃÇÈÔȻȱ·¦¾ßÓÐÉî¶ÈµÄ¡¢¹æ·¶µÄDOM Level 1¸¨Öú¶ÁÎÍøÂçÉÏËÑË÷Ò²±È½ÏÉÙ¼û¡£¶øÎÒÃÇÕæʵµÄÏë·¨ÔÚÓÚ£¬ÎÒÃÇ ......
ÒÔÇ°ÔÚ²©¿ÍÉÏ·¢¹ý£¬¾ÈËÌáÐÑDataSetÒÑ×Ô´ø¶ÁдXMLµÄ¹¦ÄÜ£¬ÓÚÊDZãɾÁË£¬
²»¹ýÔÚʵ¼ùÖиоõ·â×°Ò»²ãºó£¬Ê¹ÓÃÆðÀ´»¹ÊÇÂù·½±ãµÄ¡£¹ÊÔÙ´ÎÖØ·¢¡£
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.IO;
using System.Xml;
namespace XmlDesign
{
class XmlDatasetC ......
value·½·¨
µ±Äã²»Ïë½âÊÍÕû¸ö²éѯµÄ½á¹û¶øÖ»ÏëµÃµ½Ò»¸ö±êÁ¿ÖµÊ±£¬Õâ¸övalue·½·¨ÊǺÜÓаïÖúµÄ¡£Õâ¸övalue·½·¨ÓÃÓÚ²éѯXML²¢ÇÒ·µ»ØÒ»¸öÔ×ÓÖµ¡£
Õâ¸övalue·½·¨µÄÓï·¨ÈçÏ£º
value(XQuery£¬datatype)
½èÖúÓÚvalue·½·¨£¬Äã¿ÉÒÔ´ÓXMLÖеõ½µ¥¸ö±êÁ¿Öµ¡£Îª´Ë£¬Äã±ØÐëÖ¸¶¨XQueryÓï¾äºÍÄãÏëÒªËü·µ»ØµÄÊý¾ÝÀàÐÍ£¬²¢ÇÒÄã¿ÉÒÔ·µ»Ø³ ......