用python创建自己的单词词库，方便背单词

用python创建自己的单词词库，方便背单词

基本思路：以COCA两万单词表为基础，用python爬取金山词霸的单词词性，词义，音频分别存入sqllite。背单词的时候根据需要自定义数据的选择方式。
效果如下:

代码写的比较随意，还请见谅。
创建数据库

   cu.execute('create table test (id INTEGER PRIMARY KEY AUTOINCREMENT,dc varchar(20),cx varchar(20),cy varchar(50),mp3 varchar(50));') 

完整代码，效率不高，不过够用了

import requests
from bs4 import BeautifulSoup
import re
import traceback
import sqlite3
import time
import sysdef ycl(word):try:url = "/{}".format(word)headers = { 'Host': 'www.iciba', 'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:43.0) Gecko/20100101 Firefox/43.0', 'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'Accept-Language': 'zh-CN,zh;q=0.8,en-US;q=0.5,en;q=0.3', 'Accept-Encoding': 'gzip, deflate', 'Referer': '', 'Connection': 'keep-alive', 'Cache-Control': 'max-age=0', }response = (url = url,headers = headers)soup = ,"lxml")#输出单词词性cx = soup.find(class_='base-list switch_part')(class_='prop')#输出词性词义mp3 = soup.find_all(class_='new-speak-step')[1]pattern = repile(r'(?:[a-zA-Z]|[0-9]|[$-_@.&+]|[!*(),]|(?:%[0-9a-fA-F][0-9a-fA-F]))+.mp3')mp3url = re.findall(pattern,mp3['ms-on-mouseover'])mp3url = '.'.join(mp3url)r = (mp3url)#单词音频输出路径dress =