import sys
from PyQt6.QtWidgets import *
import pymysql
app = QApplication(sys.argv)
try:
# Подключение
conn = pymysql.connect(
host="localhost",
port=3306,
user="root",
password="",
database="avtozapravka"
)
cursor = conn.cursor()
# Запрос
cursor.execute("SELECT * FROM clients")
data = cursor.fetchall()
names = [desc[0] for desc in cursor.description]
# Окно
win = QMainWindow()
table = QTableWidget()
win.setCentralWidget(table)
table.setColumnCount(len(names))
table.setHorizontalHeaderLabels(names)
table.setRowCount(len(data))
for i, row in enumerate(data):
for j, val in enumerate(row):
table.setItem(i, j, QTableWidgetItem(str(val)))
cursor.close()
conn.close()
win.show()
sys.exit(app.exec())
except pymysql.Error as e:
print("Ошибка подключения:", e)
input("Нажми Enter чтобы выйти...")