ѧϰ 10 ÖÖÁ¼ºÃµÄ XML ʹÓÃϰ¹ß(ת)
Martin C. Brown (questions@mcslp.com), ¿ª·¢ÈËÔ±ºÍ×÷¼Ò
2008 Äê 6 ÔÂ 16 ÈÕ
ʹÓñ¾ÎĽéÉÜµÄ 10 ¸ö¼¼Çɸü¼ÓÇáËɵش¦Àí XML£¬´Ó¶ø¼õÉÙ´íÎó²¢Ìá¸ßЧÂÊ¡£
¼ò½é
ÈËÃǶ¼ºÜϲ»¶ XML ÒÔ¼°ËüËùÌṩµÄÁé»îÐԺͻ¥²Ù×÷ÐÔ£¬µ«ÊÇ£¬Í¨¹ýʹÓÃһЩ¼¼ÇÉ£¬¿ÉÒÔʹÓë XML µÄ»¥²Ù×÷ºÍÓë XML Ò»ÆðʹÓõŤ¾ß¸ü¼Ó¼òµ¥¡£ÔÚ´¦Àí XML Ê±Ñø³ÉһЩÁ¼ºÃµÄϰ¹ß¿ÉÒÔ±£Ö¤×î¸ßЧµØÀûÓÃÄúµÄ XML ÎĵµºÍÓ¦ÓóÌÐò¡£
ʹÓà 10 ÖÖÁ¼ºÃµÄϰ¹ß
ÒÔÏÂÊÇ 10 ÖÖ×îÁ¼ºÃµÄ XML ϰ¹ß£º
¶¨Òå XML ºÍ±àÂë
ʹÓà DTD »ò XSD
¼ÇµÃ½øÐÐÑéÖ¤
ÑéÖ¤²¢²»×ÜÊÇÄܹ»½â¾öÎÊÌâ
XML ½á¹¹ºÍÊôÐÔ
ʹÓà XPath ²éÕÒÐÅÏ¢
²¢²»×ÜÊÇÐèҪʹÓýâÎöÆ÷ÌáÈ¡ÐÅÏ¢
ºÎʱʹÓà SAX ¶ø·Ç DOM ½âÎö
ºÎʱʹÓà DOM ¶ø·Ç SAX ½âÎö
ʹÓÃÁ¼ºÃµÄ XML ±à¼Æ÷
¾³£Ê¹ÓõÄËõд´Ê
DOM£ºÎĵµ¶ÔÏóÄ£ÐÍ£¨Document Object Model£©
DTD£ºÎĵµÀàÐͶ¨Ò壨Document Type Definition£©
HTML£º³¬Îı¾±ê¼ÇÓïÑÔ£¨Hypertext Markup Language£©
IDE£º¼¯³É¿ª·¢»·¾³£¨Integrated Development Environment£©
SAX£ºXML ¼òµ¥ API£¨Simple API for XML£©
XSD£ºXML ģʽ¶¨Ò壨XML Schema Definition£©
XML£º¿ÉÀ©Õ¹±ê¼ÇÓïÑÔ£¨Extensible Markup Language£©
XSLT£º¿ÉÀ©Õ¹Ñùʽ±íÓïÑÔת»»£¨Extensible Stylesheet Language Transformations£©
¶¨Òå XML ºÍ±àÂë
ÔÚ¿ìËÙ´´½¨ XML ÎĵµÊ±£¬Ò»°ã¶¼»áÇãÏòÓÚ´´½¨»ù±¾µÄ½á¹¹²¢±Ü¿ªÒ»Ð©ÆÕͨ XML ÎĵµÐèÇ󣬰üÀ¨Ö¸¶¨ XML ÎĵµÉùÃ÷ºÍ XML Îĵµ°üº¬µÄÊý¾ÝµÄ±àÂëÀàÐÍ¡£
¿¼ÂÇÇåµ¥ 1 ËùʾµÄ XML Îĵµ¡£
Çåµ¥ 1. δ°üº¬ XML ÉùÃ÷ºÍÊý¾Ý±àÂëÀàÐ굀 XML Îĵµ
<phrases>
<phrase lang="en">Hello</phrase>
<phrase lang="it">Buongiorno</phrase>
<phrase lang="fr">Salut!</phrase>
</phrases>
¶ÔÓÚÆÕͨÈËÀ´Ëµ£¬¿ÉÒԲ鿴¸ÃÎĵµ²¢½«Æäʶ±ðΪ XML£¬µ«ÊǶÔÓÚ¼ÆËã»úÀ´Ëµ£¬ÔòºÜÄÑ×÷³öÕâÑùµÄÅжϡ£ÔÚÎļþ¶¥²¿Ìí¼Ó XML ÉùÃ÷£¬¿ÉÒÔʹËü¸ü¼ÓÃ÷È·¡¢¸üÈÝÒ×ʶ±ð¡£Ò»Ðмòµ¥µÄ´úÂë¾Í¿ÉÒÔ˵Ã÷ÎĵµÊÇ XML£¬²¢ÇÒÖ¸³ö°æ±¾ºÅºÍ XML Êý¾ÝʹÓõÄ×Ö·û±àÂëÀàÐÍ¡£ÀýÈ磺
<?xml version="1.0" encoding="us-ascii"?>
±àÂë˵Ã÷ÖеÄÄÚÈÝÒ²Ó¦¸ÃÈ·±£ÕýÈ·ÐÔ¡£XML ½âÎöÆ÷ʹÓñàÂëÈ·±£ XML Îĵµµ
Ïà¹ØÎĵµ£º
¡¡¡¡±¾ÎÄÌÖÂÛSQL Server 2005µÄй¦ÄÜ£¬ËüÔÊÐíÄ㽫XMLÊý¾Ý·Ö½âµ½¹ØÏµ¸ñʽÖУ¬¶ø²»±ØºÄÓÃÌ«¶àÄÚ´æ¡£
¡¡¡¡±¾ÎÄÌÖÂÛSQL Server 2005µÄй¦ÄÜ£¬ËüÔÊÐíÄ㽫XMLÊý¾Ý·Ö½âµ½¹ØÏµ¸ñʽÖУ¬¶ø²»±ØºÄÓÃÌ«¶àÄÚ´æ¡£
¡¡¡¡ÔÚ¾ÙÀý˵Ã÷ÈçºÎ·Ö½âÉÏһƪÎÄÕÂÖеÄÊý¾Ýʱ£¬ÎÒÃÇÊ×ÏÈÁ˽âÒ»ÏÂXQueryºÍËüÔÚSQL Server 2005ÖÐΪ¿ª·¢ÕßÌṩµÄ¹¦ÄÜ¡£
¡ ......
ÔÚ SQLServer2005 ÖÐ¶Ô XML µÄ´¦Àí¹¦ÄÜÏÔÈ»ÔöÇ¿Á˺ܶ࣬ÌṩÁË query(),value(),exist(),modify(),nodes() µÈº¯Êý¡£
¹ØÓÚ xml £¬ÄÑÒÔÀí½âµÄ²»ÊÇ SQLServer ÌṩµÄº¯Êý£¬¶øÊÇ¶Ô xml ±¾ÉíµÄÀí½â£¬¿´Ëƺܼòµ¥µÄÎļþ¸ñʽ£¬´¦ÀíÆðÀ´È´ÊǷdz£À§Äѵġ£±¾ÎÄÖ»ÊdzõÌ ......
ǰ¶Îʱ¼äÓÃjQuery×öÁ˸öСÁ·Ï°£¬»ñÈ¡±¾µØµÄxmlÊý¾Ý£¬ÔÚfirefoxÏÂÃæ²âÊÔûÎÊÌ⣬µ«ÊÇÔÚIEÏÂÃæ×ÜÊÇ»ñÈ¡Êý¾Ýʧ°Ü£¬ÉÏÍøÕÒÁ˺ܾÃҲûÕÒµ½ÊÇÔõô»ØÊ¡£ÓôÃÆÁ˺ܳ¤Ò»¶Îʱ¼ä£¬½ñÌìÓпÕÓÖ°ÑÕâ¸öÎÊÌâÄóöÀ´Ñо¿ÁËÏ£¬×îºóÖÕÓÚÕÒµ½ÔÒòÁË£¬°ÑÒ³Ãæ·Åµ½·þÎñÆ÷È¥ä¯ÀÀ¾ÍOKÁË¡£ÄѵÀÊÇȨÏÞÎÊÌ⣿²»ÖªµÀÔõô»ðºüÔÚ±¾µØÄ¿Â¼¿ÉÒÔ»ñÈ¡Êý¾Ý³É¹¦¡£ ......
windows xpÏÂIIS°²×°ºó¡£
¿ªÊ¼ÏÔʾµÄ´íÎóΪ
ÎÞ·¨ÏÔʾ XML Ò³¡£
ʹÓà Ñùʽ±íÎÞ·¨²é¿´ XML ÊäÈë¡£Çë¸üÕý´íÎóÈ»ºóµ¥»÷ ˢа´Å¥£¬»òÒÔºóÖØÊÔ¡£
------------------------------------------------------------------------- ......
package com.flxx.docUrl;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.List;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.input.SAXBuilder;
import org.jdom.output.Format;
import org.jd ......