用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 sys

def ycl(word):
    try:
        url = "http://www.iciba.com/{}".format(word)
        headers = {
    'Host': 'www.iciba.com', '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': 'http://www.baidu.com', 'Connection': 'keep-alive', 'Cache-Control': 'max-age=0', }
        response = requests.get(url = url,headers = headers)
        soup = BeautifulSoup(response.text,"lxml")
        #输出单词词性
        cx = soup.find(class_='base-list switch_part')(class_='prop')
        #输出词性词义
        mp3 = soup.find_all(class_='new-speak-step')[1]
        pattern = re.compile(r'http://(?:[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 = requests.get(mp3url)
        #单词音频输出路径
        dress = "E:\\sound\\"
        mp3path