Witam mam problem z połączeniem z bazą danych w Qt mam błąd:
SqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7
dodam że mam zainstalowane pakiety mysqlclient, libqt5sql5-mysql
kod .cpp:
#include "artykuly.h"
#include "ui_artykuly.h"
#include <QSqlTableModel>
#include <QSqlError>
#include <QMessageBox>
#include <QSqlDriver>
#include <QSqlDriverPlugin>
Artykuly::Artykuly(QWidget *parent) :
QWidget(parent),
ui(new Ui::Artykuly)
{
ui->setupUi(this);
mDatabase = QSqlDatabase::addDatabase("QMYSQL");
mDatabase.setHostName("localhost");
mDatabase.setDatabaseName("faktury");
mDatabase.setPassword("root");
mDatabase.setUserName("root");
mDatabase.setPort(3306);
if (!mDatabase.open()) {
QMessageBox::critical(this, "Błąd", mDatabase.lastError().text());
return;
}
mModel = new QSqlTableModel(this);
mModel->setTable("artykuly");
mModel->select();
ui->tableView->setModel(mModel);
}
Artykuly::~Artykuly()
{
delete ui;
}
void Artykuly::on_nowy_clicked()
{
mModel->insertRow(mModel->rowCount());
}
void Artykuly::on_edytuj_clicked()
{
mModel->removeRow(ui->tableView->currentIndex().row());
}
void Artykuly::on_usun_clicked()
{
mModel->select();
}
.pro:
QT += core gui sql
QT += sql
greaterThan(QT_MAJOR_VERSION, 4): QT += widgets
TARGET = Faktury
TEMPLATE = app
# The following define makes your compiler emit warnings if you use
# any feature of Qt which as been marked as deprecated (the exact warnings
# depend on your compiler). Please consult the documentation of the
# deprecated API in order to know how to port your code away from it.
DEFINES += QT_DEPRECATED_WARNINGS
# You can also make your code fail to compile if you use deprecated APIs.
# In order to do so, uncomment the following line.
# You can also select to disable deprecated APIs only up to a certain version of Qt.
#DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000 # disables all the APIs deprecated before Qt 6.0.0
SOURCES += main.cpp\
mainwindow.cpp \
artykuly.cpp
HEADERS += mainwindow.h \
artykuly.h
FORMS += mainwindow.ui \
artykuly.ui
QMAKE_CXXFLAGS += -std=gnu++11