本文共 3131 字，大约阅读时间需要 10 分钟。

要求：

+需要连接MYSQL数据库，并进行数据库操作

相关代码如下

import pymysql.cursorsconn = Nonecursor = Noneconn = pymysql.Connect(host="localhost", user="root", password="123", database="adiga", charset="utf8")cursor = conn.cursor()sql = "SELECT * FROM Vegetables ORDER BY id desc ;"cursor.execute(sql)# 执行SQL语句pubList=[]idd = []mck = cursor.fetchall()for rek in mck:    idd.append(rek[0])    m = {
           "id": rek[0],        "菜名": rek[1],        "类型": rek[2],        "价格": rek[3],        "营养指数": rek[4]    }    pubList.append(m)while True:    print("欢迎使用【我太菜管理系统】\n1.新建我菜\n2.显示全菜\n3.查询太菜\n\n0.哭了，是因为我太菜")    inx = int(input("请输入功能："))    if inx == 1:        a1 = input("请输入id：")        a2 = input("请输入菜名：")        a3 = input("请输入类型：")        a4 = input("请输入价格：")        a5 = input("输入营养指数")        if len(a1) == 0:            print("id不能为空")        elif a1 in idd:            print("id重复")        else:            idd.append(a1)            m = {
                   "id": a1,                "菜名": a2,                "类型": a3,                "价格": a4,                "营养指数":a5            }            pubList.append(m)            sql = "INSERT INTO Vegetables VALUES ('%s','%s','%s','%s','%s');"            sql = sql %(a1,a2,a3,a4,a5)            cursor.execute(sql)            print("添加成功")    if inx == 2:        sql = "SELECT * FROM Vegetables ORDER BY id desc ;"        cursor.execute(sql)        # 执行SQL语句        pubList = []        idd = []        for rek in cursor.fetchall():            idd.append(rek[0])            m = {
                   "id": rek[0],                "菜名": rek[1],                "类型": rek[2],                "价格": rek[3],                "营养指数": rek[4]            }            pubList.append(m)        print("ID\t菜名\t类型\t价格\t营养指数")        for strk in pubList:            print("%s\t%s\t%s\t%s\t%s"%(strk["id"],strk["菜名"],strk["类型"],strk["价格"],strk["营养指数"]))    if inx == 3:        suc = input("请输入查找ID")        for strk in pubList:            if strk["id"] == suc:                print("已经查找到：",strk)                inx3 = int(input("请输入功能：\n1.修改\n2.删除\n3.返回"))                if inx3 == 1:                    a2 = input("请输入菜名：")                    a3 = input("请输入类型：")                    a4 = input("请输入价格：")                    a5 = input("输入营养指数")                    strk["菜名"]= a2                    strk["类型"]= a3                    strk["价格"]= a4                    strk["营养指数"]= a5                    sql ="update Vegetables set 菜名=%s,类型=%s,价格=%s,营养指数=%s where id=%s;"                    sql = sql%(a2,a3,a4,a5,suc)                    cursor.execute(sql)                    break                if inx3 == 2:                    idd.remove(strk["id"])                    del pubList[(pubList.index(strk))]                    sql = "delete from Vegetables where id="+suc                    cursor.execute(sql)                    break                if inx3 == 3:                    break        else:            print("查找的ID不存在")    if inx == 0:        print("笑了，是因为有人带")        conn.commit()        if cursor is not None: cursor.close()        if conn is not None: conn.close()        exit(0)

转载地址：http://rfuhf.baihongyu.com/