将数据从SqlLite3数据库插入到QTableWidget中

import sqlite3
from PyQt5.QtWidgets import QApplication, QMainWindow, QTableWidget, QTableWidgetItem

table_widget = QTableWidget()

conn = sqlite3.connect('database.db')
cursor = conn.cursor()

cursor.execute("SELECT * FROM table_name")
data = cursor.fetchall()

table_widget.setRowCount(len(data))
table_widget.setColumnCount(len(data[0]))

for i, row in enumerate(data):
    for j, value in enumerate(row):
        item = QTableWidgetItem(str(value))
        table_widget.setItem(i, j, item)

conn.close()

table_widget.show()

import sqlite3
from PyQt5.QtWidgets import QApplication, QMainWindow, QTableWidget, QTableWidgetItem

class MainWindow(QMainWindow):
    def __init__(self):
        super().__init__()
        self.initUI()

    def initUI(self):
        self.setWindowTitle("Data from SqlLite3 to QTableWidget")
        self.setGeometry(100, 100, 800, 600)

        table_widget = QTableWidget(self)
        table_widget.setGeometry(50, 50, 700, 500)

        conn = sqlite3.connect('database.db')
        cursor = conn.cursor()

        cursor.execute("SELECT * FROM table_name")
        data = cursor.fetchall()

        table_widget.setRowCount(len(data))
        table_widget.setColumnCount(len(data[0]))

        for i, row in enumerate(data):
            for j, value in enumerate(row):
                item = QTableWidgetItem(str(value))
                table_widget.setItem(i, j, item)

        conn.close()

        self.show()

if __name__ == '__main__':
    app = QApplication([])
    window = MainWindow()
    app.exec_()