在这里插入代码片
from pymysql import *
import hashlib
from hashlib import sha1
class JD():
def __init__(self):
self.mysql=connect(host='localhost',port=,user=,password=' ',database=' ',charset='utf8')
self.conn=self.mysql.cursor()
def __del__(self):
self.conn.close()
self.mysql.close()
def execute_sql(self,sql):
self.conn.execute(sql)
for temp in self.conn.fetchall():
print(temp)
def show_all_items(self):
sql="select *from goods"
self.execute_sql(sql)
def show_all_cates(self):
sql="select name from goods_cates"
self.execute_sql(sql)
def show_all_brands(self):
sql="select name from goods_brands"
self.execute_sql(sql)
def add_cates(self):
cate_name=input("请输入要添加的商品类别:")
sql="""insert into goods_cates (name)