devbox
我家小花儿
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

基于PysimpleGUI+pymysql建立的简单管理系统（5）—修改功能_pysimplegui连接mysql

作者：我家小花儿 | 2024-08-09 22:56:48

赞

踩

pysimplegui连接mysql

         紧接上文，我们接下来来讲revise.py

        通过之前文章的menu.py登录界面，我们选择第三个功能，修改功能。

         我们在已有的数据表和列表框元素的基础上，我们需要考虑的是如何去修改客户的信息。相对于让用户全部重新再输入一次信息，不如给出一条信息提示，让用户去选择修改什么地方。除此之外，对于数据量较大的情况下，我增添了查找功能，可以更快更迅速的找出某个客户的所有信息。

        revise.py代码如下：（代码量较大，有很大一部分的结构是重复的）

  1. import pymysql                #导入库文件
  2. import PySimpleGUI as sg
  3. import pandas as pd
  4. import os
  5. import time
  6. import threading
  7. import datetime
  8.  
  9. conn = pymysql.connect(host="localhost",            #建立mysql的连接  
  10.                            user="root",  
  11.                            password="",   
  12.                            db="user_information",       
  13.                            charset="utf8")     
  14. cursor = conn.cursor()  
  15. sql ="select * from custome_information"            #导入mysql数据表信息
  16. cursor.execute(sql)                                
  17. result = cursor.fetchall()
  18. all = list(result)                                 #将数据列表化
  19. cursor.close()
  20. conn.close()                          
  21. layout = [[sg.Text("客户名 订单名 时间 材料 尺寸 数量 单价 金额")],     #gui界面设计
  22.           [sg.Listbox(all, key='-TEXT-', select_mode='single',size=(80, 6))],
  23.           [sg.Button('返回'),sg.Button('修改'),sg.Button('查找'),sg.Button('退出')]]
  24. window = sg.Window('修改客户账单', layout)
  25. while True:
  26.     event, values = window.read()                 #获取用户动作以及值
  27.     if event == sg.WINDOW_CLOSED or event == '退出':
  28.         break 
  29.     if  event == '返回':                           #返回菜单界面
  30.         time.sleep(0.5)
  31.         window.close()
  32.         os.system('python menu.py')
  33.         break    
  34.     if  event == '修改':                            #修改功能
  35.         values = pd.DataFrame.from_dict(values,orient='index')
  36.         str1 = str(values.iat[0,0])                #提取相应字符串
  37.         custome_name = str1.split("\'")[1]
  38.         order_name = str1.split("\'")[3]
  39.         material = str1.split("\'")[5]
  40.         size = str1.split("\'")[7]
  41.         quantity = str1.split(",")[9]
  42.         price = str1.split(",")[10]
  43.         amount = str1.split(",")[11].strip(')')
  44.         time.sleep(0.5)
  45.         window.close()
  46.         layout = [[sg.Text("请输入要修改的序号：")],        #修改位置界面
  47.             [sg.Text("1.客户名 2.订单名 3.时间 4.材料 ")],
  48.             [sg.Text("5.尺寸   6.数量   7.单价 8.金额 ")],
  49.             [sg.Input(key='-INPUT-')],
  50.             [sg.Button('确定'),sg.Button('返回')]]
  51.         window = sg.Window('修改', layout)
  52.         while True:
  53.             event, values = window.read() 
  54.             if event == sg.WINDOW_CLOSED :
  55.                 break
  56.             if event == '返回':                    #返回修改界面
  57.                 time.sleep(0.5)
  58.                 window.close()
  59.                 os.system('python revise.py')
  60.                 break
  61.             if event == '确定':
  62.                 values = pd.DataFrame([values])
  63.                 if values.iat[0,0] == '':               #判断为空报错
  64.                     window.close()
  65.                     layout = [[sg.Text("填写为空！")],
  66.                             [sg.Button('返回')]]
  67.                     window = sg.Window('错误', layout)
  68.                     while True:
  69.                         event, values = window.read()
  70.                         if event == sg.WINDOW_CLOSED:
  71.                             break 
  72.                         if  event == '返回':            #返回修改界面
  73.                             time.sleep(0.5)
  74.                             window.close()
  75.                             os.system('python revise.py')
  76.                             break
  77.                 choice = int(values.iat[0,0])  
  78.                 time.sleep(0.5)
  79.                 window.close()
  80.                 if choice == 1:
  81.                     layout = [[sg.Text("请输入要修改的内容：")],   #修改内容界面
  82.                                 [sg.Input(key='-INPUT-')],
  83.                                 [sg.Button('确定'),sg.Button('返回')]]
  84.                     window = sg.Window('修改', layout)
  85.                     while True:
  86.                         event, values = window.read() 
  87.                         if event == sg.WINDOW_CLOSED :
  88.                             break
  89.                         if event == '返回':           #返回修改界面
  90.                             time.sleep(0.5)        
  91.                             window.close()
  92.                             os.system('python revise.py')
  93.                             break
  94.                         if event == '确定':
  95.                             values = pd.DataFrame([values])
  96.                             content = str(values.iat[0,0])
  97.                             cursor = conn.cursor()  
  98.                             conn.ping(reconnect=True)       #添加互斥锁，以防mysql连接丢失
  99.                             thread_lock = threading.Lock()        
  100.                             thread_lock.acquire()
  101.                             sql ="update custome_information set custome_name = '%s' where order_name = '%s' and material = '%s' and size = '%s'  and quantity = '%s' and price = '%s' and amount = '%s'" %(content,order_name,material,size,quantity,price,amount)
  102.                             cursor.execute(sql)
  103.                             conn.commit()
  104.                             conn.close()
  105.                             thread_lock.release()
  106.                             time.sleep(0.5)
  107.                             window.close()
  108.                             os.system('python revise.py')
  109.                             break
  110.                 if choice == 2:                         #同上，唯一区别在于mysql语句不同
  111.                     layout = [[sg.Text("请输入要修改的内容：")],
  112.                                 [sg.Input(key='-INPUT-')],
  113.                                 [sg.Button('确定'),sg.Button('返回')]]
  114.                     window = sg.Window('修改', layout)
  115.                     while True:
  116.                         event, values = window.read() 
  117.                         if event == sg.WINDOW_CLOSED :
  118.                             break
  119.                         if event == '返回':
  120.                             time.sleep(0.5)
  121.                             window.close()
  122.                             os.system('python revise.py')
  123.                             break
  124.                         if event == '确定':
  125.                             values = pd.DataFrame([values])
  126.                             content = str(values.iat[0,0])
  127.                             cursor = conn.cursor()  
  128.                             conn.ping(reconnect=True)
  129.                             thread_lock = threading.Lock()
  130.                             thread_lock.acquire()
  131.                             sql ="update custome_information set order_name = '%s' where custome_name = '%s' and material = '%s' and size = '%s' and quantity = '%s' and price = '%s'  and amount = '%s'" %(content,custome_name,material,size,quantity,price,amount)
  132.                             cursor.execute(sql)
  133.                             conn.commit()
  134.                             conn.close()
  135.                             thread_lock.release()
  136.                             time.sleep(0.5)
  137.                             window.close()
  138.                             os.system('python revise.py')
  139.                             break
  140.                 if choice == 3:
  141.                     layout = [[sg.Text("请输入要修改的内容：(年.月.日)")],
  142.                                 [sg.Input(key='-INPUT-')],
  143.                                 [sg.Button('确定'),sg.Button('返回')]]
  144.                     window = sg.Window('修改', layout)
  145.                     while True:
  146.                         event, values = window.read() 
  147.                         if event == sg.WINDOW_CLOSED :
  148.                             break
  149.                         if event == '返回':
  150.                             time.sleep(0.5)
  151.                             window.close()
  152.                             os.system('python revise.py')
  153.                             break
  154.                         if event == '确定':
  155.                             values = pd.DataFrame([values])
  156.                             content = str(values.iat[0,0])
  157.                             format_str = '%Y.%m.%d'
  158.                             content = datetime.datetime.strptime(content, format_str) 
  159.                             cursor = conn.cursor()  
  160.                             conn.ping(reconnect=True)
  161.                             thread_lock = threading.Lock()
  162.                             thread_lock.acquire()
  163.                             sql ="update custome_information set time = '%s'  where custome_name = '%s'and order_name = '%s' and material = '%s' and size = '%s' and quantity = '%s' and price = '%s' and amount = '%s'" %(content,custome_name,order_name,material,size,quantity,price,amount)
  164.                             cursor.execute(sql)
  165.                             conn.commit()
  166.                             conn.close()
  167.                             thread_lock.release()
  168.                             time.sleep(0.5)
  169.                             window.close()
  170.                             os.system('python revise.py')
  171.                             break
  172.                 if choice == 4:
  173.                     layout = [[sg.Text("请输入要修改的内容：")],
  174.                                 [sg.Input(key='-INPUT-')],
  175.                                 [sg.Button('确定'),sg.Button('返回')]]
  176.                     window = sg.Window('修改', layout)
  177.                     while True:
  178.                         event, values = window.read() 
  179.                         if event == sg.WINDOW_CLOSED :
  180.                             break
  181.                         if event == '返回':
  182.                             time.sleep(0.5)
  183.                             window.close()
  184.                             os.system('python revise.py')
  185.                             break
  186.                         if event == '确定':
  187.                             values = pd.DataFrame([values])
  188.                             content = str(values.iat[0,0])
  189.                             cursor = conn.cursor()  
  190.                             conn.ping(reconnect=True)
  191.                             thread_lock = threading.Lock()
  192.                             thread_lock.acquire()
  193.                             sql ="update custome_information set material = '%s' where custome_name = '%s' and  order_name= '%s' and size = '%s' and quantity = '%s' and price = '%s' and amount = '%s'" %(content,custome_name,order_name,size,quantity,price,amount)
  194.                             cursor.execute(sql)
  195.                             conn.commit()
  196.                             conn.close()
  197.                             thread_lock.release()
  198.                             time.sleep(0.5)
  199.                             window.close()
  200.                             os.system('python revise.py')
  201.                             break        
  202.                 if choice == 5:
  203.                     layout = [[sg.Text("请输入要修改的内容：")],
  204.                                 [sg.Input(key='-INPUT-')],
  205.                                 [sg.Button('确定'),sg.Button('返回')]]
  206.                     window = sg.Window('修改', layout)
  207.                     while True:
  208.                         event, values = window.read() 
  209.                         if event == sg.WINDOW_CLOSED :
  210.                             break
  211.                         if event == '返回':
  212.                             time.sleep(0.5)
  213.                             window.close()
  214.                             os.system('python revise.py')
  215.                             break
  216.                         if event == '确定':
  217.                             values = pd.DataFrame([values])
  218.                             content = str(values.iat[0,0])
  219.                             cursor = conn.cursor()  
  220.                             conn.ping(reconnect=True)
  221.                             thread_lock = threading.Lock()
  222.                             thread_lock.acquire()
  223.                             sql ="update custome_information set size = '%s' where custome_name = '%s' and  order_name= '%s' and  material= '%s' and quantity = '%s' and price = '%s' and amount = '%s'" %(content,custome_name,order_name,material,quantity,price,amount)
  224.                             cursor.execute(sql)
  225.                             conn.commit()
  226.                             conn.close()
  227.                             thread_lock.release()
  228.                             time.sleep(0.5)
  229.                             window.close()
  230.                             os.system('python revise.py')
  231.                             break   
  232.                 if choice == 6:
  233.                     layout = [[sg.Text("请输入要修改的内容：")],
  234.                                 [sg.Input(key='-INPUT-')],
  235.                                 [sg.Button('确定'),sg.Button('返回')]]
  236.                     window = sg.Window('修改', layout)
  237.                     while True:
  238.                         event, values = window.read() 
  239.                         if event == sg.WINDOW_CLOSED :
  240.                             break
  241.                         if event == '返回':
  242.                             time.sleep(0.5)
  243.                             window.close()
  244.                             os.system('python revise.py')
  245.                             break
  246.                         if event == '确定':
  247.                             values = pd.DataFrame([values])
  248.                             content = int(values.iat[0,0])
  249.                             cursor = conn.cursor()  
  250.                             conn.ping(reconnect=True)
  251.                             thread_lock = threading.Lock()
  252.                             thread_lock.acquire()
  253.                             sql ="update custome_information set quantity = '%s' where custome_name = '%s' and  order_name= '%s' and  material= '%s' and size = '%s' and price = '%s' and amount = '%s'" %(content,custome_name,order_name,material,size,price,amount)
  254.                             cursor.execute(sql)
  255.                             conn.commit()
  256.                             conn.close()
  257.                             thread_lock.release()
  258.                             time.sleep(0.5)
  259.                             window.close()
  260.                             os.system('python revise.py')
  261.                             break        
  262.                 if choice == 7:
  263.                     layout = [[sg.Text("请输入要修改的内容：")],
  264.                                 [sg.Input(key='-INPUT-')],
  265.                                 [sg.Button('确定'),sg.Button('返回')]]
  266.                     window = sg.Window('修改', layout)
  267.                     while True:
  268.                         event, values = window.read() 
  269.                         if event == sg.WINDOW_CLOSED :
  270.                             break
  271.                         if event == '返回':
  272.                             time.sleep(0.5)
  273.                             window.close()
  274.                             os.system('python revise.py')
  275.                             break
  276.                         if event == '确定':
  277.                             values = pd.DataFrame([values])
  278.                             content = float(values.iat[0,0])
  279.                             cursor = conn.cursor()  
  280.                             conn.ping(reconnect=True)
  281.                             thread_lock = threading.Lock()
  282.                             thread_lock.acquire()
  283.                             sql ="update custome_information set price = '%s' where custome_name = '%s' and  order_name= '%s' and  material= '%s' and size = '%s' and  quantity= '%s' and amount = '%s'" %(content,custome_name,order_name,material,size,quantity,amount)
  284.                             cursor.execute(sql)
  285.                             conn.commit()
  286.                             conn.close()
  287.                             thread_lock.release()
  288.                             time.sleep(0.5)
  289.                             window.close()
  290.                             os.system('python revise.py')
  291.                             break            
  292.                 if choice == 8:
  293.                     layout = [[sg.Text("请输入要修改的内容：")],
  294.                                 [sg.Input(key='-INPUT-')],
  295.                                 [sg.Button('确定'),sg.Button('返回')]]
  296.                     window = sg.Window('修改', layout)
  297.                     while True:
  298.                         event, values = window.read() 
  299.                         if event == sg.WINDOW_CLOSED :
  300.                             break
  301.                         if event == '返回':
  302.                             time.sleep(0.5)
  303.                             window.close()
  304.                             os.system('python revise.py')
  305.                             break
  306.                         if event == '确定':
  307.                             values = pd.DataFrame([values])
  308.                             content = float(values.iat[0,0])
  309.                             cursor = conn.cursor()  
  310.                             conn.ping(reconnect=True)
  311.                             thread_lock = threading.Lock()
  312.                             thread_lock.acquire()
  313.                             sql ="update custome_information set amount = '%s' where custome_name = '%s' and  order_name= '%s' and  material= '%s' and size = '%s' and  quantity= '%s' and price = '%s'" %(content,custome_name,order_name,material,size,quantity,price)
  314.                             cursor.execute(sql)
  315.                             conn.commit()
  316.                             conn.close()
  317.                             thread_lock.release()
  318.                             time.sleep(0.5)
  319.                             window.close()
  320.                             os.system('python revise.py')
  321.                             break
  322.     if  event == '查找':                        #查找功能界面
  323.         window.close()
  324.         layout = [[sg.Text("请输入要查找的客户名：")],
  325.           [sg.Input(key='-INPUT-')],
  326.           [sg.Button('确定'),sg.Button('返回'),sg.Button('退出')]]
  327.         window = sg.Window('查找', layout)
  328.         while True:
  329.             event, values = window.read() 
  330.             if event == sg.WINDOW_CLOSED or event == '退出':
  331.                 break 
  332.             if  event == '返回':                #返回修改界面
  333.                 time.sleep(0.5)
  334.                 window.close()
  335.                 os.system('python revise.py')
  336.                 break    
  337.             if event == '确定':
  338.                 window.close()
  339.                 values = pd.DataFrame([values])
  340.                 custome_name = str(values.iat[0,0])
  341.                 cursor = conn.cursor() 
  342.                 conn.ping(reconnect=True)            #添加互斥锁，以防mysql连接丢失
  343.                 thread_lock = threading.Lock()
  344.                 thread_lock.acquire() 
  345.                 sql ="select * from custome_information where custome_name = '%s'"%(custome_name)
  346.                 cursor.execute(sql)
  347.                 result = cursor.fetchall()
  348.                 all = list(result)
  349.                 cursor.close()
  350.                 conn.close()
  351.                 thread_lock.release()
  352.                 layout = [[sg.Text("客户名 订单名 时间 材料 尺寸 数量 单价 金额")],
  353.                         [sg.Listbox(all, key='-TEXT-', select_mode='single',size=(80, 6))],
  354.                         [sg.Button('返回'),sg.Button('修改'),sg.Button('退出')]]
  355.                 window = sg.Window('查找', layout)
  356.                 while True:
  357.                     event, values = window.read()
  358.                     if event == sg.WINDOW_CLOSED or event == '退出':
  359.                         break 
  360.                     if  event == '返回':
  361.                         time.sleep(0.5)
  362.                         window.close()
  363.                         os.system('python revise.py')
  364.                         break  
  365.                     if  event == '修改':            #同上操作
  366.                         values = pd.DataFrame.from_dict(values,orient='index')
  367.                         str1 = str(values.iat[0,0])
  368.                         custome_name = str1.split("\'")[1]
  369.                         order_name = str1.split("\'")[3]
  370.                         material = str1.split("\'")[5]
  371.                         size = str1.split("\'")[7]
  372.                         quantity = str1.split(",")[9]
  373.                         price = str1.split(",")[10]
  374.                         amount = str1.split(",")[11].strip(')')
  375.                         time.sleep(0.5)
  376.                         window.close()
  377.                         layout = [[sg.Text("请输入要修改的序号：")],
  378.                                 [sg.Text("1.客户名 2.订单名 3.时间 4.材料 ")],
  379.                                 [sg.Text("5.尺寸   6.数量   7.单价 8.金额 ")],
  380.                                 [sg.Input(key='-INPUT-')],
  381.                                 [sg.Button('确定'),sg.Button('返回')]]
  382.                         window = sg.Window('修改', layout)
  383.                         while True:
  384.                             event, values = window.read() 
  385.                             if event == sg.WINDOW_CLOSED :
  386.                                 break
  387.                             if event == '返回':
  388.                                 time.sleep(0.5)
  389.                                 window.close()
  390.                                 os.system('python revise.py')
  391.                                 break
  392.                             if event == '确定':
  393.                                 values = pd.DataFrame([values])
  394.                                 choice = int(values['-INPUT-'])
  395.                                 time.sleep(0.5)
  396.                                 window.close()
  397.                                 if choice == 1:
  398.                                     layout = [[sg.Text("请输入要修改的内容：")],
  399.                                             [sg.Input(key='-INPUT-')],
  400.                                             [sg.Button('确定'),sg.Button('返回')]]
  401.                                     window = sg.Window('修改', layout)
  402.                                     while True:
  403.                                         event, values = window.read() 
  404.                                         if event == sg.WINDOW_CLOSED :
  405.                                             break
  406.                                         if event == '返回':
  407.                                             time.sleep(0.5)
  408.                                             window.close()
  409.                                             os.system('python revise.py')
  410.                                             break
  411.                                         if event == '确定':
  412.                                             values = pd.DataFrame([values])
  413.                                             content = str(values.iat[0,0])
  414.                                             cursor = conn.cursor()  
  415.                                             conn.ping(reconnect=True)
  416.                                             thread_lock = threading.Lock()
  417.                                             thread_lock.acquire()
  418.                                             sql ="update custome_information set custome_name = '%s' where order_name = '%s' and material = '%s' and size = '%s'  and quantity = '%s' and price = '%s' and amount = '%s'" %(content,order_name,material,size,quantity,price,amount)
  419.                                             cursor.execute(sql)
  420.                                             conn.commit()
  421.                                             conn.close()
  422.                                             thread_lock.release()
  423.                                             time.sleep(0.5)
  424.                                             window.close()
  425.                                             os.system('python revise.py')
  426.                                             break
  427.                                 if choice == 2:
  428.                                     layout = [[sg.Text("请输入要修改的内容：")],
  429.                                                 [sg.Input(key='-INPUT-')],
  430.                                                 [sg.Button('确定'),sg.Button('返回')]]
  431.                                     window = sg.Window('修改', layout)
  432.                                     while True:
  433.                                         event, values = window.read() 
  434.                                         if event == sg.WINDOW_CLOSED :
  435.                                             break
  436.                                         if event == '返回':
  437.                                             time.sleep(0.5)
  438.                                             window.close()
  439.                                             os.system('python revise.py')
  440.                                             break
  441.                                         if event == '确定':
  442.                                             values = pd.DataFrame([values])
  443.                                             content = str(values.iat[0,0])
  444.                                             cursor = conn.cursor()  
  445.                                             conn.ping(reconnect=True)
  446.                                             thread_lock = threading.Lock()
  447.                                             thread_lock.acquire()
  448.                                             sql ="update custome_information set order_name = '%s' where custome_name = '%s' and material = '%s' and size = '%s' and quantity = '%s' and price = '%s'  and amount = '%s'" %(content,custome_name,material,size,quantity,price,amount)
  449.                                             cursor.execute(sql)
  450.                                             conn.commit()
  451.                                             conn.close()
  452.                                             thread_lock.release()
  453.                                             time.sleep(0.5)
  454.                                             window.close()
  455.                                             os.system('python revise.py')
  456.                                             break
  457.                                 if choice == 3:
  458.                                     layout = [[sg.Text("请输入要修改的内容：(年.月.日)")],
  459.                                                 [sg.Input(key='-INPUT-')],
  460.                                                 [sg.Button('确定'),sg.Button('返回')]]
  461.                                     window = sg.Window('修改', layout)
  462.                                     while True:
  463.                                         event, values = window.read() 
  464.                                         if event == sg.WINDOW_CLOSED :
  465.                                             break
  466.                                         if event == '返回':
  467.                                             time.sleep(0.5)
  468.                                             window.close()
  469.                                             os.system('python revise.py')
  470.                                             break
  471.                                         if event == '确定':
  472.                                             values = pd.DataFrame([values])
  473.                                             content = str(values.iat[0,0])
  474.                                             format_str = '%Y.%m.%d'
  475.                                             content = datetime.datetime.strptime(content, format_str) 
  476.                                             cursor = conn.cursor()  
  477.                                             conn.ping(reconnect=True)
  478.                                             thread_lock = threading.Lock()
  479.                                             thread_lock.acquire()
  480.                                             sql ="update custome_information set time = '%s'  where custome_name = '%s'and order_name = '%s' and material = '%s' and size = '%s' and quantity = '%s' and price = '%s' and amount = '%s'" %(content,custome_name,order_name,material,size,quantity,price,amount)
  481.                                             cursor.execute(sql)
  482.                                             conn.commit()
  483.                                             conn.close()
  484.                                             thread_lock.release()
  485.                                             time.sleep(0.5)
  486.                                             window.close()
  487.                                             os.system('python revise.py')
  488.                                             break
  489.                                 if choice == 4:
  490.                                     layout = [[sg.Text("请输入要修改的内容：")],
  491.                                                 [sg.Input(key='-INPUT-')],
  492.                                                 [sg.Button('确定'),sg.Button('返回')]]
  493.                                     window = sg.Window('修改', layout)
  494.                                     while True:
  495.                                         event, values = window.read() 
  496.                                         if event == sg.WINDOW_CLOSED :
  497.                                             break
  498.                                         if event == '返回':
  499.                                             time.sleep(0.5)
  500.                                             window.close()
  501.                                             os.system('python revise.py')
  502.                                             break
  503.                                         if event == '确定':
  504.                                             values = pd.DataFrame([values])
  505.                                             content = str(values.iat[0,0])
  506.                                             cursor = conn.cursor()  
  507.                                             conn.ping(reconnect=True)
  508.                                             thread_lock = threading.Lock()
  509.                                             thread_lock.acquire()
  510.                                             sql ="update custome_information set material = '%s' where custome_name = '%s' and  order_name= '%s' and size = '%s' and quantity = '%s' and price = '%s' and amount = '%s'" %(content,custome_name,order_name,size,quantity,price,amount)
  511.                                             cursor.execute(sql)
  512.                                             conn.commit()
  513.                                             conn.close()
  514.                                             thread_lock.release()
  515.                                             time.sleep(0.5)
  516.                                             window.close()
  517.                                             os.system('python revise.py')
  518.                                             break        
  519.                                 if choice == 5:
  520.                                     layout = [[sg.Text("请输入要修改的内容：")],
  521.                                                 [sg.Input(key='-INPUT-')],
  522.                                                 [sg.Button('确定'),sg.Button('返回')]]
  523.                                     window = sg.Window('修改', layout)
  524.                                     while True:
  525.                                         event, values = window.read() 
  526.                                         if event == sg.WINDOW_CLOSED :
  527.                                             break
  528.                                         if event == '返回':
  529.                                             time.sleep(0.5)
  530.                                             window.close()
  531.                                             os.system('python revise.py')
  532.                                             break
  533.                                         if event == '确定':
  534.                                             values = pd.DataFrame([values])
  535.                                             content = str(values.iat[0,0])
  536.                                             cursor = conn.cursor()  
  537.                                             conn.ping(reconnect=True)
  538.                                             thread_lock = threading.Lock()
  539.                                             thread_lock.acquire()
  540.                                             sql ="update custome_information set size = '%s' where custome_name = '%s' and  order_name= '%s' and  material= '%s' and quantity = '%s' and price = '%s' and amount = '%s'" %(content,custome_name,order_name,material,quantity,price,amount)
  541.                                             cursor.execute(sql)
  542.                                             conn.commit()
  543.                                             conn.close()
  544.                                             thread_lock.release()
  545.                                             time.sleep(0.5)
  546.                                             window.close()
  547.                                             os.system('python revise.py')
  548.                                             break   
  549.                                 if choice == 6:
  550.                                     layout = [[sg.Text("请输入要修改的内容：")],
  551.                                                 [sg.Input(key='-INPUT-')],
  552.                                                 [sg.Button('确定'),sg.Button('返回')]]
  553.                                     window = sg.Window('修改', layout)
  554.                                     while True:
  555.                                         event, values = window.read() 
  556.                                         if event == sg.WINDOW_CLOSED :
  557.                                             break
  558.                                         if event == '返回':
  559.                                             time.sleep(0.5)
  560.                                             window.close()
  561.                                             os.system('python revise.py')
  562.                                             break
  563.                                         if event == '确定':
  564.                                             values = pd.DataFrame([values])
  565.                                             content = int(values.iat[0,0])
  566.                                             cursor = conn.cursor()  
  567.                                             conn.ping(reconnect=True)
  568.                                             thread_lock = threading.Lock()
  569.                                             thread_lock.acquire()
  570.                                             sql ="update custome_information set quantity = '%s' where custome_name = '%s' and  order_name= '%s' and  material= '%s' and size = '%s' and price = '%s' and amount = '%s'" %(content,custome_name,order_name,material,size,price,amount)
  571.                                             cursor.execute(sql)
  572.                                             conn.commit()
  573.                                             conn.close()
  574.                                             thread_lock.release()
  575.                                             time.sleep(0.5)
  576.                                             window.close()
  577.                                             os.system('python revise.py')
  578.                                             break        
  579.                                 if choice == 7:
  580.                                     layout = [[sg.Text("请输入要修改的内容：")],
  581.                                                 [sg.Input(key='-INPUT-')],
  582.                                                 [sg.Button('确定'),sg.Button('返回')]]
  583.                                     window = sg.Window('修改', layout)
  584.                                     while True:
  585.                                         event, values = window.read() 
  586.                                         if event == sg.WINDOW_CLOSED :
  587.                                             break
  588.                                         if event == '返回':
  589.                                             time.sleep(0.5)
  590.                                             window.close()
  591.                                             os.system('python revise.py')
  592.                                             break
  593.                                         if event == '确定':
  594.                                             values = pd.DataFrame([values])
  595.                                             content = float(values.iat[0,0])
  596.                                             cursor = conn.cursor()  
  597.                                             conn.ping(reconnect=True)
  598.                                             thread_lock = threading.Lock()
  599.                                             thread_lock.acquire()
  600.                                             sql ="update custome_information set price = '%s' where custome_name = '%s' and  order_name= '%s' and  material= '%s' and size = '%s' and  quantity= '%s' and amount = '%s'" %(content,custome_name,order_name,material,size,quantity,amount)
  601.                                             cursor.execute(sql)
  602.                                             conn.commit()
  603.                                             conn.close()
  604.                                             thread_lock.release()
  605.                                             time.sleep(0.5)
  606.                                             window.close()
  607.                                             os.system('python revise.py')
  608.                                             break            
  609.                                 if choice == 8:
  610.                                     layout = [[sg.Text("请输入要修改的内容：")],
  611.                                                 [sg.Input(key='-INPUT-')],
  612.                                                 [sg.Button('确定'),sg.Button('返回')]]
  613.                                     window = sg.Window('修改', layout)
  614.                                     while True:
  615.                                         event, values = window.read() 
  616.                                         if event == sg.WINDOW_CLOSED :
  617.                                             break
  618.                                         if event == '返回':
  619.                                             time.sleep(0.5)
  620.                                             window.close()
  621.                                             os.system('python revise.py')
  622.                                             break
  623.                                         if event == '确定':
  624.                                             values = pd.DataFrame([values])
  625.                                             content = float(values.iat[0,0])
  626.                                             cursor = conn.cursor()  
  627.                                             conn.ping(reconnect=True)
  628.                                             thread_lock = threading.Lock()
  629.                                             thread_lock.acquire()
  630.                                             sql ="update custome_information set amount = '%s' where custome_name = '%s' and  order_name= '%s' and  material= '%s' and size = '%s' and  quantity= '%s' and price = '%s'" %(content,custome_name,order_name,material,size,quantity,price)
  631.                                             cursor.execute(sql)
  632.                                             conn.commit()
  633.                                             conn.close()
  634.                                             thread_lock.release()
  635.                                             time.sleep(0.5)
  636.                                             window.close()
  637.                                             os.system('python revise.py')
  638.                                             break
  639.                                 else:
  640.                                     window['-OUTPUT-'].update("请输入正确的序号!")

代码运行截图：

 

 

 

之后将持续更新，search.py查找操作。 

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/我家小花儿/article/detail/955552
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号