from pymysql import *class Mysqlpython: def __init__(self,database,host="localhost",     user="root",password="123456",     charset="utf8",port=3306):  self.database = database  self.host = host  self.user = user  self.password = password  self.charset = charset  self.port = port   # 創建數據連接和游標對象 def open(self):  self.db = connect(host=self.host,     user=self.user,     password=self.password,     port=self.port,     database=self.database,     charset=self.charset)  self.cur = self.db.cursor() # 關閉游標對象和數據庫連接對象 def close(self):  self.cur.close()  self.db.close() # 執行sql命令 def zhixing(self,sql,L=[]):  self.open()  self.cur.execute(sql,L)  self.db.commit()  self.close() # 查詢功能 def all(self,sql,L=[]):  self.open()  self.cur.execute(sql,L)  result = self.cur.fetchall()  return resultif __name__ == "__main__": sqlh = Mysqlpython("dictionary")  sel = "select * from user" r = sqlh.all(sel) print(r)

import reimport sysfrom mysqlpython import Mysqlpythonsqlh = Mysqlpython("dictionary")def insert(data): arr = data.split() name = arr[0] description = " ".join(arr[1:]) ins = "insert into words(name,description) values(%s,%s)" sqlh.zhixing(ins,[name,description])def get_addr(): f = open('./dict.txt') lines=f.readlines() for line in lines:  insert(line) f.close() return ''if __name__ =='__main__': print(get_addr())

a    indef art oneabacus   n.frame with beads that slide along parallel rods, used for teaching numbers to children, and (in some countries) for countingabandon   v. go away from (a person or thing or place) not intending to return; forsake; desertabandonment  n. abandoningabase   v. ~ oneself/sb lower oneself/sb in dignity; degrade oneself/sb ;abash   to destroy the self-possession or self-confidence of:disconcertabashed   adj. ~ embarrassed; ashamedabate   v. make or become lessabattoir   n. = slaughterhouse (slaughter)