try cursorexecutesql dbcommit results = cursorfetchone if results # 如果找到了匹配的书名则将结果添加到列表中 selftableWidgetsetRowCount1

try: cursor.execute(sql) db.commit() results = cursor.fetchone() if results: # 如果找到了匹配的书名，则将结果添加到列表中 self.table_book.setItem(1, 0, QTableWidgetItem(results[0])) self.table_book.setItem(1, 1, QTableWidgetItem(results[1])) self.table_book.setItem(1, 2, QTableWidgetItem(results[2])) self.table_book.setItem(1, 3, QTableWidgetItem(results[3])) self.table_book.setItem(1, 4, QTableWidgetItem(results[4])) self.table_book.setItem(1, 5, QTableWidgetItem(results[5])) self.table_book.setItem(1, 6, QTableWidgetItem(results[6])) else: # 如果没有找到匹配的书名，则显示“无” self.table_book.clearContents() self.table_book.setRowCount(2) self.table_book.setItem(1, 0, QTableWidgetItem('无')) except: db.rollback(