[ת]Android¶ÁдXML£¨Ï£©——´´½¨XMLÎĵµ
Õª×Ô--http://www.moandroid.com/?p=868
¶ÁдXML£¨Ï£©——´´½¨XMLÎĵµ
By: º£ÊÐò×Â¥ | In: Android¿ª·¢
23 ¾Å 2009
ÔÚÇ°ÃæµÄ2ƪÎÄÕÂAndroid¶ÁдXML£¨ÉÏ£©——package˵Ã÷¡¢Android¶ÁдXML£¨ÖУ©——SAXÖÐÏë±Ø´ó¼Ò¶ÔXMLÎļþ¶ÁÈ¡µÄ·½·¨ÒѾ±È½ÏÊìϤÁË£¬ÔÚÕâÀïÎÒÃǾͲ»¶à˵ÁË£¬Ö±½Ó˵Ã÷ÈçºÎ½«ÐÅϢд³ÉXMLÎļþ£¬Ê×ÏȽéÉÜAndoid SDKÖеÄÏà¹ØÀà¡£
Àà
˵Ã÷
XmlSerializer
Define an interface to serialziation of XML Infoset.¶¨ÒåÒ»¸ö½Ó¿ÚÀ´ÊµÏÖXMLÐÅÏ¢µÄ´®Ðл¯¡£
ʲôÊÇ´®Ðл¯£¿
¶ÔÏóµÄ´®ÐÍ»¯£¬Ò²ÓнÐ×ö¶ÔÏóµÄÐòÁл°£¬²¢²»Ö»ÊǼòµ¥µÄ°Ñ¶ÔÏó±£´æÔÚ´æ´¢Æ÷ÉÏ£¬Ëü¿ÉÒÔʹÎÒÃÇÔÚÁ÷Öд«Êä¶ÔÏó£¬Ê¹¶ÔÏó±äµÄ¿ÉÒÔÏñ»ù±¾Êý¾ÝÒ»Ñù´«µÝ¡£
ÏÂÃæ£¬ÎÒÃǾÍÖ±½ÓÀ´¿´¸ö¾ßÌåµÄÀý×ÓÀ´ËµÃ÷£¬ÈçºÎʹÓÃXmlSerializer¡£
private String writeXml(){
XmlSerializer serializer = Xml.newSerializer();
StringWriter writer = new StringWriter();
try{
serializer.setOutput(writer);
// <?xml version=”1.0″ encoding=”UTF-8″ standalone=”yes”?>
serializer.startDocument(”UTF-8″,true);
// <blog number=”1″>
serializer.startTag(”",”blog”);
serializer.attribute(”",”number”,String.valueOf(1));
//<message data=”2009-09-23″>
serializer.startTag(”",”message”);
serializer.attribute(”",”date”,”2009-09-23″);
// <title>Android XML</title>
serializer.startTag(”",”title”);
serializer.text(”Android XML”);
serializer.endTag(”",”title”);
// <url>http://www.moandroid.com/?p=508</url>
serializer.startTag(”",”url”);
serializer.text(”http://www.moandroid.com/?p=508″);
serializer.endTag(”",”url”);
//</message>
serializer.endTag(”",”message”);
// </blog>
serializer.endTag(”",”blog”);
serializer.endDocument();
return writer.toString();
}
catch(Exception e)
{
throw new RuntimeException(e
Ïà¹ØÎĵµ£º
ÔÚ
SQLServer2005
ÖжÔ
XML
µÄ´¦Àí¹¦ÄÜÏÔÈ»ÔöÇ¿Á˺ܶ࣬ÌṩÁË
query(),value(),exist(),modify(),nodes()
µÈº¯Êý¡£
¹ØÓÚ
xml
£¬ÄÑÒÔÀí½âµÄ²»ÊÇ
SQLServer
ÌṩµÄº¯Êý£¬¶øÊǶÔ
xml
±¾ÉíµÄÀí½â£¬¿´Ëƺܼòµ¥µÄÎļþ¸ñʽ£¬´¦ÀíÆðÀ´È´ÊǷdz£À§Äѵġ£±¾ÎÄÖ»Êdzõ̽һ϶øÒÑ¡£
Ïê¼û
SQLServer
Áª»ú°ïÖú£º
Ö÷Ìâ
˵ ......
һЩ×Ö·ûÔÚ URL »ò XML ÎĵµÖÐʹÓÃʱÓÐÌØÊâµÄº¬Ò壬Òò´Ë±ØÐëÕë¶ÔÕâЩº¬Òå¶Ô×Ö·û×öÊʵ±±àÂëÒÔʹÆäÉúЧ¡£
URL ÖеÄÌØÊâ×Ö·û
ÔÚ URL ÉÏÖ´ÐеIJéѯÖУ¬ÌØÊâ×Ö·û±»Ö¸¶¨Îª %xx£¬ÆäÖÐ xx ÊÇ×Ö·ûµÄÊ®Áù½øÖÆÖµ¡£Ï±íÁгöÁËÕâÐ©ÌØÊâ×Ö·û²¢ÃèÊöÁËËüÃǵĺ¬Òå¡£Óйظü¶àÐÅÏ¢£¬Çë²Î¼û http://www.faqs.org/rfcs/rfc1738.html ÖÐµÄ RFC ......
xmlÓÐʲôÓÅÊÆºÍÌØµã
“¿ÉÀ©Õ¹±ê¼ÇÓïÑÔ”(XML) ÌṩһÖÖÃèÊö½á¹¹»¯Êý¾ÝµÄ·½·¨¡£ÓëÖ÷ÒªÓÃÓÚ¿ØÖÆÊý¾ÝµÄÏÔʾºÍÍâ¹ÛµÄ
HTML ±ê¼Ç²»Í¬£¬XML ±ê¼ÇÓÃÓÚ¶¨ÒåÊý¾Ý±¾ÉíµÄ½á¹¹ºÍÊý¾ÝÀàÐÍ¡£
XML
ʹÓÃÒ»×é±ê¼ÇÀ´Ãè»æÊý¾ÝÔªËØ¡£Ã¿¸öÔªËØ·â×°¿ÉÄÜÊ®·Ö¼òµ¥Ò²¿ÉÄÜÊ®·Ö¸´ÔÓµÄÊý¾Ý¡£Äú¿ÉÒÔ¶¨ÒåÒ»×éÎÞÏÞÖÆµÄ XML ±ê¼Ç¡£ÀýÈç£ ......
---xml²ð·ÖÒÔ²»¶¨¿Õ¸ñΪ·Ö¸î·ûºÅµÄ×Ö·û´®
--²âÊÔÊý¾Ý
if object_id('[tb]') is not null drop table [tb]
create table [tb]([a] varchar(200))
go
insert [tb]
select 'aaaa bbbb cccc dddd'
insert [tb]
select 'eeeeee ffff hhhh   ......