1 2 3 4 5 6 7 8 9 10 11 12 13 14
| con = cx_Oracle.connect("user/Pass@adresse:1521/LN")
self.tableWidget.setRowCount(0)
NumAssFind = self.NumAss.text()
query = "Select * From Client Where NumClient = :Num"
cur = con.cursor()
result = cur.execute(query,{'Num': NumAssFind})
self.tableWidget.setRowCount(0)
for row_number, row_data in enumerate(result):
self.tableWidget.insertRow(row_number)
for column_number, data in enumerate(row_data):
self.tableWidget(row_number, column_number, QTableWidgetItem(str(data)))
con.close() |
Partager