GUI_MySQL_class.py 文件源码

def deleteRecord(self):
        # connect to MySQL
        conn, cursor = self.connect()   

        self.useGuiDB(cursor)      

        try: 
            # execute command
            cursor.execute("SELECT Book_ID FROM books WHERE Book_Title = 'Design Patterns'")
            primKey = cursor.fetchall()[0][0]
            # print(primKey)

            cursor.execute("DELETE FROM books WHERE Book_ID = (%s)", (primKey,))

            # commit transaction
            conn.commit ()
        except:
            pass

        # close cursor and connection
        self.close(cursor, conn)     


#==========================================================