ΪʲôÓÃxmlÌá½»²»ÁË£¿
Private Sub Command1_Click()
Dim http As Object, q_post As String, User As String, Pass As String
Set http = CreateObject("Microsoft.XMLHTTP")
http.open "POST", "http://www.01xs.com/", False
http.setRequestHeader "Accept", "image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-silverlight, */*" '±íʾÎÒÃÇËùÓõÄä¯ÀÀÆ÷ÄܽÓÊܵÄContent-type
http.setRequestHeader "Referer", "http://www.01xs.com" 'µ±Ç°Ò³ÃæÊÇ´ÓÄǸöÒ³ÃæÁ´½ÓÀ´µÄ
http.setRequestHeader "Accept-Language", "zh-cn" 'ÓïÑÔ
http.setRequestHeader "Content-Type", "application/x-www-form-urlencoded" '±íʾ¿Í»§¶ËÌá½»¸ø·þÎñÆ÷Îı¾ÄÚÈݵıàÂ뷽ʽÊÇURL±àÂ룬¼´³ýÁ˱ê×¼×Ö·ûÍ⣬ÿ×Ö½ÚÒÔË«×Ö½Ú16½øÖÆÇ°¼Ó¸ö¡°%¡±±íʾ
http.setRequestHeader "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; QQPinyin 689; TencentTraveler 4.0; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; .NET CLR 2.0.50727)" 'ÏÔʾ³ö±¾»úµÄÏà¹ØÏµÐÅÏ¢,ºÇºÇ,ÕâÊÇÎÒµÄÐÅÏ¢´ó¼Ò¿ÉÒÔÈ¥µô²»Ó÷¢ÕâÌõ
http.setRequestHeader "Host", "www.01xs.com" 'ËùÇëÇóµÄÖ÷»ú
http.setRequestHeader "Content-Length", "90" '±íʾÌá½»µÄÊý¾Ý×Ö½Ú´óÐ
Ïà¹ØÎÊ´ð£º
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡
ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë
XML code:
<?xml version="1.0" encoding="utf-8"? ......
HTML code:
<div id="tessx">
<ALEXA VER="0.9" URL="163.com/" HOME="0" AID="=">
<RLS PREFIX="http://" more="79" ......
ÈçÌ⣬ÓÐûÓÐÕâÑùµÄphp´úÂë¡£ÎÒÏÖÔÚÏ뽫excelµÄÄÚÈݲåÈëmysqlÊý¾Ý¿â£¬Ï£Íû¿ÉÒÔ½«excelת³Éxml,È»ºó½âÎöxml²åÈëÊý¾Ý¿âÖС£Èç¹ûÓÐÕâÑùµÄ´úÂ룬ÉõÖÁÊÇÓÐÃûµÄ´úÂ룬һ¶¨Òª¸æËßÎÒ°¡¡£
ÏȶÁ excel => È»ºóÉú³É xml = ......
ÒÑÖªÎļþ1.xmlºÍÊý¾ÝÎļþdb.xml£¬ÈçºÎÓÃjava±àд³ÌÐò£¬µÃ³ö2.xmlÎļþ£¿
1.ÒÑÖªxmlÎļþ 1.xml½á¹¹ÈçÏ£º
<cs>
<cs name="cs1" details="This is cs1" country="China&q ......
ä¯ÀÀÆ÷IE6
ÔÚÒ»¸öÒ³ÃæÖÐÓÐÒ»¸öÁ¬½Ó£¬Á¬½ÓµÄÒ³ÃæÄÚÈÝÈçÏ£º
<%@ page contentType="text/xml; charset=UTF-8" language="java"%>
<?xml version="1.0" encoding=& ......