from pymysql import connect
class JD(object):
def __init__(self):
pass
def show_all_items(self):
"""显示所有的商品"""
conn = connect(host="localhost",port=3306,user="root",password="root",database="jing_dong",charset="utf8")
cursor = conn.cursor()
cursor.execute("select * from goods;")
for temp in cursor.fetchall():
print(temp)
# 关闭Cursor对象
cursor.close()
conn.close()
def show_cates(self):
conn = connect(host="localhost",port=3306,user="root",password="root",database="jing_dong",charset="utf8")
cursor = conn.curson()
cursor.execute("select name from goods_cates;")
for temp in cursor.fetchall():
print(temp)
# 关闭Cursor对象
cursor.close()
conn.close()
def run(self):
while True:
print("------欢迎来到京东商城------")
print("1:所有的商品")
print("2:所有的商品分类")
print("3:所有的商品品牌分类")
num = input("请输入功能对应的序号:")
if num == "1":
# 查询所有商品
self.show_all_items()
elif num == "2":
# 查询分类
self.show_cates()
elif num == "3":
# 查询商品分类
pass
else:
print("输入有错,请重新输入!")
def main():
# 1.创建一个京东商城对象
jd = JD()
# 2.调用这个对象的run方法,让其运行
jd.run()
if __name__ == "__main__":
main()