How to show connected sqlite database in Tableview

[Clandeik]

So hello,I have an existing database in my project.I connected my database to my prog.I can't understand how to show my database in Tableview.Please look at my project, what I'm doing wrong?

qt.jpg

mainwindow.cpp

#include "mainwindow.h"
#include "ui_mainwindow.h"
 
MainWindow::MainWindow(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::MainWindow)
{
    ui->setupUi(this);
 
    QSqlDatabase mydb=QSqlDatabase::addDatabase("QSQLITE");
    mydb.setDatabaseName("C:/GLOSSARIY/Ядерная медицина.sqlite");
    mydb.open();
 
    if (!mydb.open())
        ui->label->setText("Failed to open your database");
    else
        ui->label->setText("Connected succesfully...");
 
}
 
 
MainWindow::~MainWindow()
{
    delete ui;
}
void MainWindow::on_pushButton_clicked()
 
{
QSqlQueryModel * model = new QSqlQueryModel();
    QSqlQuery query;
    query.exec("SELECT * FROM Глоссарий по радиобиологии");
    model->setQuery(query);
    ui->tableView->setModel(model);
}

#include "mainwindow.h"
#include "ui_mainwindow.h"

MainWindow::MainWindow(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::MainWindow)
{
    ui->setupUi(this);

    QSqlDatabase mydb=QSqlDatabase::addDatabase("QSQLITE");
    mydb.setDatabaseName("C:/GLOSSARIY/Ядерная медицина.sqlite");
    mydb.open();

    if (!mydb.open())
        ui->label->setText("Failed to open your database");
    else
        ui->label->setText("Connected succesfully...");

}


MainWindow::~MainWindow()
{
    delete ui;
}
void MainWindow::on_pushButton_clicked()

{
QSqlQueryModel * model = new QSqlQueryModel();
    QSqlQuery query;
    query.exec("SELECT * FROM Глоссарий по радиобиологии");
    model->setQuery(query);
    ui->tableView->setModel(model);
}

To copy to clipboard, switch view to plain text mode 

mainwindow.h

#ifndef MAINWINDOW_H
#define MAINWINDOW_H
 
#include <QMainWindow>
#include <QtSql>
#include <QtDebug>
#include <QFileInfo>
 
 
namespace Ui {
class MainWindow;
}
 
class MainWindow : public QMainWindow
{
    Q_OBJECT
 
//public:
    //QSqlDatabase mydb;
 
public:
    explicit MainWindow(QWidget *parent = 0);
    ~MainWindow();
 
private slots:
    void on_pushButton_clicked();
 
private:
    Ui::MainWindow *ui;
 
   QSqlQueryModel *model;
   QSqlDatabase mydb;
};
 
#endif // MAINWINDOW_H

#ifndef MAINWINDOW_H
#define MAINWINDOW_H

#include <QMainWindow>
#include <QtSql>
#include <QtDebug>
#include <QFileInfo>


namespace Ui {
class MainWindow;
}

class MainWindow : public QMainWindow
{
    Q_OBJECT

//public:
    //QSqlDatabase mydb;

public:
    explicit MainWindow(QWidget *parent = 0);
    ~MainWindow();

private slots:
    void on_pushButton_clicked();

private:
    Ui::MainWindow *ui;

   QSqlQueryModel *model;
   QSqlDatabase mydb;
};

#endif // MAINWINDOW_H

To copy to clipboard, switch view to plain text mode