python 我试图使一个污垢,但当使用插入的按钮发生错误

093gszye  于 5个月前  发布在  Python
关注(0)|答案(1)|浏览(55)

我尝试做一个crud,但当使用插入的按钮发生错误,每次我尝试添加在crud这发生:

Traceback (most recent call last):
      File "C:\Users\mclov\AppData\Local\Programs\Python\Python39\lib\tkinter\__init__.py", line                           1892, in __call__
        return self.func(*args)
      File "C:\Users\mclov\pythonProject1\fluxo.py", line 53, in insertdata
        inserir(lista)
      File "C:\Users\mclov\pythonProject1\lira.py", line 14, in inserir
        cursor = conexao.cursor()
      File "C:\Users\mclov\abadabado\lib\site-packages\mysql\connector\connection_cext.py", line     706,         in cursor
        raise OperationalError("MySQL Connection not available.")
    mysql.connector.errors.OperationalError: MySQL Connection not available.

字符串
代码:

def insertdata():
    tempo = entry_tempo.get()
    evento = entry_descrição.get()
    debito = entry_entrada.get()
    credito = entry_saida.get()
    lista = [tempo, evento, debito, credito]
    if evento == '' or tempo == '' or credito=='' or debito=='':
        messagebox.showerror("campo não pode ser vazio")
    else:
        inserir(lista)
        messagebox.showinfo("todos os dados foram registrados")
        entry_tempo.delete(0, "end")
        entry_descrição.delete(0, "end")
        entry_entrada.delete(0, "end")
        entry_saida.delete(0, "end")

    for widget in frame_tabela.winfo_children():
        widget.destroy()

    showitself()

kyks70gy

kyks70gy1#

似乎主要问题是MySQL连接,我建议:

  • 从终端或任何其他工具(如MySQL)测试MySQL连接
  • 检查“inserir”函数,并从那里评估数据插入是否有效
  • 也可以从其他方法中调用代码,例如:连接、CRUD函数等

相关问题