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   # 創(chuàng)建數(shù)據(jù)連接和游標(biāo)對(duì)象 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() # 關(guān)閉游標(biāo)對(duì)象和數(shù)據(jù)庫(kù)連接對(duì)象 def close(self):  self.cur.close()  self.db.close() # 執(zhí)行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)