废话不多说，直接上代码。
import paramiko
ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh.connect('YOUR_HOST', YOUR_PORT, 'YOUR_USERNAME', 'YOUR_PASSWORD')
stdin, stdout, stderr = ssh.exec_command('ls')
print (stdout.read())
ssh.close()
from bs4 import BeautifulSoup
import re
import sqlite3
conn = sqlite3.connect('onenav.db3')
print("数据库打开成功")
c = conn.cursor()
c.execute('''delete from on_links;''')
c.execute('''update sqlite_sequence SET seq = 0 where name ='on_links';''')
c.execute('''delete from on_categorys;''')
c.execute('''update sqlite_sequence SET seq = 0 where name ='on_categorys';''')
conn.commit()
print("数据清空完毕")
f = open('555.txt', encoding='utf-8')
html = f.read()
f.close()
soup = BeautifulSoup(html, 'html.parser')
div_tags = soup.find_all('div', {'class': 'site-main-li'})
category_id = 0
for div_tag in div_tags[1:-1]:
category_id += 1
category = div_tag.find('div', {'class', 'site-tit'}).get_text().strip()
links = div_tag.find_all('div', {'class', 'list siteList'})
print(category)
c.execute('''insert into on_categorys (`id`, `name`) values (?, ?);''', (category_id, category))
for link in links:
link_id = link.get('data-id')
if link_id:
url = link['data-links']
title = re.sub(r'<.*>', '', link.find('p', class_="title").get_text().strip())
print('\t'.join([url, title]))
c.execute('''insert into on_links (`fid`, `title`, `url`) values (?, ?, ?);''', (category_id, title, url))
print('---')
conn.commit()
conn.close()
各种云的DNS实现显性转发需要ICP，本来不用服务器就可以302转发的这下操作麻烦了。自己搭建一个DNS服务器，动作太大，且使用可信度不高。奇思妙想通过cname和txt记录，实现一下无服务器DNS显性302跳转。
搭建：
1）cname302.com解析到服务器IP，比如：IP.IP.IP.IP
2）建立一个PHP网站，并设置为默认网站（即解析到这个IP的域名都可以访问）：
代码内容：