以后再说吧? 2022-01-18 14:06 采纳率: 33.3%
浏览 49

python更新不了mysql数据库而且不报错

database代码:


    def update(self, **kwargs):
        try:
            param = [kwargs['ITEM_CLASS'], kwargs['CODE_HIS'], kwargs['NAME_HIS'], kwargs['CODE_LOCAL_YB'], kwargs['NAME_LOCAL_YB'],
                     kwargs['NATION_CODE'], kwargs['FEE_GRADE'], kwargs['OUTP_INDI'], kwargs['INP_INDI'],
                     kwargs['MEMO']]

            self.cursor.execute(self._update, param)

            self.conn.commit()
            return True
        except mysql.Error as e:
            print("错误信息:%s" % str(e))
            return False

GUI代码

    def update(self, event):
        ITEM_CLASS = self.view.entry_ITEM_CLASS.get()
        CODE_HIS = self.view.entry_CODE_HIS.get()
        NAME_HIS = self.view.entry_NAME_HIS.get()
        CODE_LOCAL_YB = self.view.entry_CODE_LOCAL_YB.get()
        NAME_LOCAL_YB = self.view.entry_NAME_LOCAL_YB.get()
        NATION_CODE = self.view.entry_NATION_CODE.get()
        FEE_GRADE = self.view.entry_FEE_GRADE.get()
        OUTP_INDI = self.view.entry_OUTP_INDI.get()
        INP_INDI = self.view.entry_INP_INDI.get()
        MEMO = self.view.entry_MEMO.get()

        print(1)
        if ITEM_CLASS != '' and CODE_HIS != '' and NAME_HIS != '' and CODE_LOCAL_YB != '' and NAME_LOCAL_YB != '' and \
                NATION_CODE != '' and FEE_GRADE != '' and OUTP_INDI != '' and INP_INDI != '':

            if self.db.update(ITEM_CLASS=ITEM_CLASS, CODE_HIS=CODE_HIS, NAME_HIS=NAME_HIS, CODE_LOCAL_YB=CODE_LOCAL_YB,
                              NAME_LOCAL_YB=NAME_LOCAL_YB, NATION_CODE=NATION_CODE, FEE_GRADE=FEE_GRADE,
                              OUTP_INDI=OUTP_INDI, INP_INDI=INP_INDI, MEMO=MEMO):

                self.refresh('')

                _thread.start_new_thread(lambda: tk.messagebox.showinfo(message='更新成功~'), ())
            else:

                _thread.start_new_thread(lambda: tk.messagebox.showinfo(message='更新失败!'), ())
        else:

            _thread.start_new_thread(lambda: tk.messagebox.showinfo(message='请补全信息'), ())

**
不报任何错误,但就是更新不了,求帮忙看看**

  • 写回答

3条回答 默认 最新

  • 於黾 2022-01-18 14:27
    关注

    self._update里存的是什么呢

    评论

报告相同问题?

问题事件

  • 创建了问题 1月18日