c_c_lai

¦^´_ 11# VBALearner
½Ð±Ð¬°¦ó·|µL select ÄÝ©Ê¡H

¤U¸ü (83.14 KB)

2017-2-9 19:52

§Ú¿é¤J¤º®e¬O§_¦³»~¡H

1. import requests
   
2. import time
   
3. from bs4 import BeautifulSoup
   
4. ¥D´£³æ¸¹½X=['160-69306532','608-10318674']
   
5. 
   
6. with requests.session() as r:
   
7.     res = r.get('https://accs.tradevan.com.tw/accsw-bin/APACCS/userLoginAction.do?userid=GUEST&password=GUEST')
   
8.     for code in ¥D´£³æ¸¹½X:
   
9.         print('¥D´£³æ¸¹½X¡G',code, '\n')
   
10.         payload = {'mawb_no':code,'¬d¸ß':'¬d¸ß'}
    
11.         res = r.post("https://accs.tradevan.com.tw/accsw-bin/APACCS/clmMergeQueryAction.do", data=payload)
    
12.         res.encoding = "big-5"
    
13.         html = BeautifulSoup(res.text,"html.parser")
    
14.         for tr in html.body.select('table')[4].select('tr')[1:]:  #½Ð¸Ô¾\w3school¸Ì¦³ÃöHTMLªºTable¼ÐÅÒª¾ÃÑ¡A´N¯àª¾¹D³o¸Ì¦b°µÔ£
    
15.             data = []  #«Ø¥ß°}¦C
    
16.             for td in tr.select('td'):
    
17.                 data.append(td.text.strip())
    
18.                 if td == tr.select('td')[len(tr.select('td'))-1]: #³o¸Ì¦³¤U¤@­ÓPOST©Ò»Ýªº¸ê°T (payload)¡A³z¹LÆ[¹îºô­¶­ì©l½X±oª¾
    
19.                     print('²Ä¤G¦¸POSTªº¸ê®Æ¡G',td,'\n')
    
20.             print('ºK­n¸ê°T¡G',data, '\n')   #²Ä¤@¦¸¬d¸ß±o¨ìªººK­n¸ê®Æ

½Æ»s¥N½X

c_c_lai

¦^´_ 15# VBALearner
¥[¤F #¡A±Æ°£ Select¡A±µ¤U¨Ó¬O¯Á¤Þ½d³ò¤F¡I

¤U¸ü (82.83 KB)

2017-2-10 04:58

c_c_lai

¦^´_ 17# VBALearner
¤Ó´Î¤F¡IÁÂÁ§A¡I

¤U¸ü (124.87 KB)

2017-2-10 17:40

c_c_lai

¦^´_ 21# VBALearner
ÆZ¤£¿ùªº¸àÄÀ¡I
ÁÂÁÂÅo¡I