import
sys
from
PyQt5
import
QtCore, QtGui, QtWidgets, QtSql
class
Ui_MainWindow(
object
): have
def
setupUi(
self
, MainWindow):
MainWindow.setObjectName(
"MainWindow"
)
MainWindow.resize(
432
,
813
)
MainWindow.setMinimumSize(QtCore.QSize(
432
,
813
))
MainWindow.setMaximumSize(QtCore.QSize(
432
,
813
))
self
.centralwidget
=
QtWidgets.QWidget(MainWindow)
self
.centralwidget.setObjectName(
"centralwidget"
)
self
.frame
=
QtWidgets.QFrame(
self
.centralwidget)
self
.frame.setGeometry(QtCore.QRect(
0
,
0
,
781
,
821
))
self
.frame.setFrameShape(QtWidgets.QFrame.StyledPanel)
self
.frame.setFrameShadow(QtWidgets.QFrame.Raised)
self
.frame.setObjectName(
"frame"
)
self
.tableWidget
=
QtWidgets.QTableWidget(
self
.frame)
self
.tableWidget.setGeometry(QtCore.QRect(
0
,
10
,
431
,
731
))
self
.tableWidget.setRowCount(
10
)
self
.tableWidget.setColumnCount(
2
)
self
.tableWidget.setObjectName(
"tableWidget"
)
item
=
QtWidgets.QTableWidgetItem()
item1
=
QtWidgets.QTableWidgetItem()
self
.tableWidget.setHorizontalHeaderItem(
0
, item)
self
.tableWidget.setHorizontalHeaderItem(
1
, item1)
self
.tableWidget.horizontalHeader().setDefaultSectionSize(
185
)
self
.tableWidget.verticalHeader().setMinimumSectionSize(
50
)
MainWindow.setCentralWidget(
self
.centralwidget)
self
.retranslateUi(MainWindow)
QtCore.QMetaObject.connectSlotsByName(MainWindow)
self
.QSqlDatabase.addDatabase(
"QMYSQL"
)
self
.db.setHostName(
"geeksforgeeks"
)
self
.db.setDatabaseName(
"gfgdb"
)
self
.db.setUserName(
"geeks"
)
self
.db.setPassword(
"gfg"
)
self
.qry
=
QString(
"SELECT * FROM employee"
)
self
.query
=
QSqlQuery()
self
.query.prepare(
self
.qry)
self
.query.
exec
()
for
row_number, row_data
in
enumerate
(
self
.query.result()):
for
column_number, data
in
enumerate
(row_data):
self
.tableWidget.setItem(row_number, column_number, QtWidgets.QTableWidgetItem(data)
def
retranslateUi(
self
, MainWindow):
_translate
=
QtCore.QCoreApplication.translate
MainWindow.setWindowTitle(_translate(
"MainWindow"
,
"List of All Employee(GFGdb)"
))
item
=
self
.tableWidget.horizontalHeaderItem(
0
)
item.setText(_translate(
"MainWindow"
,
"NAME"
))
item1
=
self
.tableWidget.horizontalHeaderItem(
1
)
item1.setText(_translate(
"MainWindow"
,
"SALARY"
))
if
__name__
=
=
"__main__"
:
import
sys
app
=
QtWidgets.QApplication(sys.argv)
MainWindow
=
QtWidgets.QMainWindow()
ui
=
Ui_MainWindow()
ui.setupUi(MainWindow)
MainWindow.show()
sys.exit(app.exec_())