python检测代理

import re,pymysql,requests,sys,json,time
import telnetlib
connect = pymysql.connect(user = 'm',
                password = 'M',
                db = 'xi',
                host = 'r',
                port = 3306,
                charset = 'utf8'
                )
con = connect.cursor()
sql1="select ip,port from daili where bzz='0'"
try:
    count1=con.execute(sql1)
    connect.commit()
except:
    connect.commit()
lbaa=con.fetchall()
for i in lbaa:
    if i:
 
        try:
            tn = telnetlib.Telnet(i[0],port=i[1],timeout=20)
        except:
            print('该代理IP  无效')
        else:
            print('该代理IP  有效')
        time.sleep(10)
sys.exit(0)

 

import telnetlib
try:
    tn = telnetlib.Telnet('218.2.214.107',port=80,timeout=20)
except:
    print('该代理IP  无效')
else:
    print('该代理IP  有效')