¸ß·ÖÇóvbµÄftpÕûÌå½â¾ö·½°¸ - VB / VBA
ÐèÇóÃèÊö£º½«ÍøµãÊý¾Ý¿âµÄÊý¾ÝÉÏ´«µ½×ܹ«Ë¾Êý¾Ý¿âÖС££¨ÆäÖУº1×ܹ«Ë¾ÓõÄÊÇshhÐÒ飬·Ö¹«Ë¾ÓõÄÊÇftpÐÒ飻2.Êý¾ÝÓпÉÄÜÊÇÍøµãÖ±½ÓÉϵ½×ܹ«Ë¾£¬Ò²ÓпÉÄÜÊÇÍøµãµ½·Ö¹«Ë¾ÔÙµ½×ܹ«Ë¾£¬Õâ¸öÓÉÏÂÃæµÄÍøÂç¶ø¶¨£©
¶ÔÓÚÍøµãÖ±½ÓÉϵ½×ܹ«Ë¾ÎÒĿǰµÄʵÏÖÊÇ£º½«ÍøµãÊý¾Ý¿âµÄÊý¾Ýµ¼³ö³ÉÎļþ£¬È»ºóÉú³É½Å±¾À´µ÷psftpÈí¼þÉÏ´«Îļþµ½×ܹ«Ë¾£»µ«ÊÇÕâ¸ö·½·¨ÎÞ·¨ÅжÏÎļþÉÏ´«µÄÍêÕûÐÔ£¬Ò²¾ÍÊDz»ÄÜÈ·±£³É¹¦Óë·ñ
°ïÂ¥Ö÷¶¥ÉÏ¡£¡£¡£
ÔÚÒ»¸öµØ·½¼û¹ý¡£http://hackcode.net/Article/html/HackCode862.html
Visual Basic ×÷Ϊһ¸ö¼¯Ó¦ÓóÌÐò¿ª·¢¡¢²âÊÔ¡¢²é´í¹¦ÄÜÓÚÒ» ÌåµÄ¼¯³Éʽ¿ª·¢»·¾³,Ô½À´Ô½Êܵ½³ÌÐòÔ±µÄÇàíù¡£±ÊÕßÔÚ¿ª·¢Ä³Êý¾Ý ¿âά»¤ÏµÍ³µÄ¹ý³ÌÖÐ,Ñ¡ÔñÁËVB5.0×÷Ϊ¿ª·¢Æ½Ì¨,Unix×÷Ϊ·þÎñÆ÷¶Ë ²Ù×÷ϵͳ,Informix ×÷Ϊ·þÎñÆ÷Êý¾Ý¿â¡£
¡¡¡¡ ÎÊÌâµÄ³öÏÖ
¡¡¡¡ ÔÚ¿ª·¢¸Ãά»¤ÏµÍ³µÄ¹ý³ÌÖÐ,×¢Òâµ½Informix Êý¾Ý¿âµÄ×Ö¶Î ÀàÐÍCLOB ÌîÈëÊý¾ÝʱÐèÒªº¯ÊýFILETOCLOB("FILENAME","SERVER") , ÆäÖеÄ"FILENAME"ÐèÒªÖ¸³öÎļþ·¾¶ºÍÎļþÃû³Æ¡£È»¶ø,ÔÚά»¤¹ý³Ì ÖдËÎļþÊÇÔÚ¿Í»§¶ËÖ´ÐеÄ,ÕâÑù¾ÍÒªÇó¼´Ê±½«Îļþ´«Êäµ½·þÎñÆ÷¶Ë ¡£
¡¡¡¡ ½â¾ö°ì·¨
¡¡¡¡ 1. FTP´«Ê乤¾ß
¡¡¡¡ ÎÒÃÇÊ×ÏÈʹÓÃFTP´«Ê乤¾ß,ÓÃVB5.0ÖÐSHELL ÃüÁîµ÷ÓÃDOSÅú´¦Àí ÎļþÀ´ÊµÏÖ´«ÊäµÄÐèÒª¡£
¡¡¡¡ Shellµ÷Óøñʽ:
¡¡¡¡ Shell(pathname[,windowstyle])
¡¡¡¡ Àý×Ó:Shell("c:\windows\upload.bat")
¡¡¡¡ Åú´¦ÀíÎļþupload.bat µÄÄÚÈÝ:
¡¡¡¡ c:\windows\ftp hostname
¡¡¡¡ username
¡¡¡¡ password
¡¡¡¡ send c:\zrh\upload.txt
Ïà¹ØÎÊ´ð£º
DIM ds as new DataSet
ÎÒÕâÑùÉùÃ÷ ÔõÀÏÊDZ¨ Óû§¶¨ÒåÀàÐÍ䶨Ò壿 Õâ¸öÐèÒªÒýÓÃʲôÂ𣿣¿
ǰÌáÊÇDataSet¶ÔÏóÒª´æÔÚ,¾ÍÊǶÔÏóä¯ÀÀÆ÷ÖÐÓÐËü.ûÓоÍÒªÒýÓÃ.
datasetÊÇADO.NET¶ÔÏó
Èç¹ûÄãÓõÄÊÇvb.net£¬ÄÇôÔÚ´ ......
ÏÖÔÚÓиöxmlÎļþÊÇ<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xm ......
xmlDoc1.loadXML(h)×ÜÊÇ·µ»Øfalse£¬ÎªÊ²Ã´£¿Ð»Ð»°ïæ»Ø´ðÒ»ÏÂ
hÊÇÊ²Ã´ÄØ¡£¡£¡£¡£¡£¡£¡£¡£¡£
hÊÇxml¸ñʽµÄ×Ö·û´®
ÄãÊÇÏë´ò¿ª¡£XML¸ñʽµÄÎļþ°É£¿
ÎÒÊǰÑh·ÅÔÚxmlDoc1ÀÓÃxmlDoc1.loadXML(h)£¬È»ºóÈ¡xmlDo ......
dim a as string,b as string£¬c as string
a="¹¤³Ì±àºÅ,µ¥Î»¹¤³ÌÃû³Æ,·Ö²¿¹¤³Ì±àºÅ"
b="µ¥Î»¹¤³ÌÃû³Æ"
c="µ¥Î»"
Ôõô²ÅÄÜÅжϳöa×Ö·û´®ÖдæÔÚb×Ö·û´®£¬¶ø²»´æÔÚc×Ö·û´®
¿´¿´i ......
form1ÖÐÓÐtext1-8£¬ ºÍcommand1
text8ÖÐΪ³ÌÐò´úÂ루Éú³É´°ÌåΪform2£¨ÒÑ×öºÃ£©£©
µ¥»÷command1ºó½«text2ÖеĴúÂëÉú³ÉEXEµ½d:\ ²¢ÇÒtext1-7·Ö±ð¶ÔÓ¦
²úÆ·Ãû ¹«Ë¾Ãû ºÏ·¨°æÈ¨ ºÏ·¨É̱ê ÎļþÃèÊö ×¢ÊÍ ±êÌâ
......