pyqt5表格显示mysql_PyQt5调入数据库数据在表格中显示

数据库为Postgresql

import sys

from form import Ui_Form

from PyQt5.Qt import QWidget, QApplication,QTableWidgetItem

import psycopg2

class myform(QWidget,Ui_Form):

def __init__(self):

super().__init__()

self.setupUi(self)

self.btn1.clicked.connect(self.clear)

self.btn2.clicked.connect(self.load)

self.show()

def clear(self):

pass

def load(self):

conn=psycopg2.connect("dbname=test1_data user=jm password=123")

cur=conn.cursor()

cur.execute('select * from table1')

rows=cur.fetchall()

row=cur.rowcount #取得记录个数，用于设置表格的行数

vol=len(rows[0]) #取得字段数，用于设置表格的列数

cur.close