import pymysql from pymysql import connect class PDD(object): def __init__(self): # 创建Connection连接 self.conn = pymysql.connect(host='localhost', port=3306, user='root', password='12345', database='goodsmanager',charset='utf8') self.cursor = self.conn.cursor(pymysql.cursors.DictCursor) def __del__(self): # 关闭Cursor对象 self.cursor.close() self.conn.close() def execute_sql(self,sql): self.cursor.execute(sql) for temp in self.cursor.fetchall(): print(temp) def show_all_items(self): #显示所有商品 sql="select * from goods;" self.execute_sql(sql) def show_goods_id(self): sql="select id,name from goods" self.execute_sql(sql) def show_goods_price(self): sql="select name,price from goods" self.execute_sql(sql) def show_goods_count(self): sql = "select name,count from goods" self.execute_sql(sql) def add_goods(self,name="null",price=0,count=0): name=input("请输入商品的名称:") price=input("请输入商品的价格:") count=input("请输入商品的库存:") sql= "insert into goods(name,price,count) values(%s,%s,%s)" try: if self.cursor.execute(sql,(name,price,count)): print("数据输入成功") self.conn.commit() except: print("数据输入失败") self.conn.rollback() @staticmethod def print_menu(): print("———————————PDD商城—————————") print("1:查看所有的商品信息") print("2:查看商品的编号") print("3:查看商品的价格") print("4:查看商品的库存") print("5:添加商品信息") num = input("请输入功能对应的序号:") return num def run(self): while True: num=self.print_menu() if num == "1": #查询所有商品 self.show_all_items() elif num=="2": #查询编号 self.show_goods_id() elif num=="3": #查询价格 self.show_goods_price() elif num=="4": #查询库存 self.show_goods_count() elif num=="5": #添加商品 self.add_goods() else : print("输入有误,请重新输入:") def main(): #创建PDD商城对象 pdd=PDD() #调用对象的run方法,让它运行 pdd.run() if __name__=="__main__": main()