Qt fiedls to postgresql tables

[LeHibou]

Hi there,

I am going crazy about a simple thing I guess. I seeked broadly all over the QSQL pages to find the answer; but..

My goal :
Linking my Qt interface fields to my postgresql database.
I read about QDataWidgetMapper but it doesn't fills my needs.
------------------------------------------------------------------------------
Context :

We will use my postgresql 's testing table.

There is
- a schema zero
- a table one
- a column two
------------------------------------------------------------------------------
The code I have :
I use Qt Creator and below is the code :

Gestion.pro

QT       += core gui
QT       += sql
TARGET = Gestion
TEMPLATE = app
 
 
SOURCES += main.cpp\
        mainwindow.cpp
 
HEADERS  += mainwindow.h
 
FORMS    += mainwindow.ui

QT       += core gui
QT       += sql
TARGET = Gestion
TEMPLATE = app


SOURCES += main.cpp\
        mainwindow.cpp

HEADERS  += mainwindow.h

FORMS    += mainwindow.ui

To copy to clipboard, switch view to plain text mode 

My main.cpp

#include <QtGui/QApplication>
#include <QCoreApplication>
#include <QtSql/QtSql>
#include <QtSql/QSqlDatabase>
#include <QtSql/QSqlQuery>
#include <iostream>
#include "mainwindow.h"
 
#define q2c(string) string.toStdString()
 
 
int main(int argc, char *argv[])
{
    QApplication a(argc, argv);
 
    QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
            db.setHostName("localhost");
            db.setPort(5433);
            db.setDatabaseName("totof");
            db.setUserName("postgres");
            db.setPassword("password");
 
            db.open();
 
    MainWindow w;
    w.show();
 
    return a.exec();
}

#include <QtGui/QApplication>
#include <QCoreApplication>
#include <QtSql/QtSql>
#include <QtSql/QSqlDatabase>
#include <QtSql/QSqlQuery>
#include <iostream>
#include "mainwindow.h"

#define q2c(string) string.toStdString()


int main(int argc, char *argv[])
{
    QApplication a(argc, argv);

    QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
            db.setHostName("localhost");
            db.setPort(5433);
            db.setDatabaseName("totof");
            db.setUserName("postgres");
            db.setPassword("password");

            db.open();

    MainWindow w;
    w.show();

    return a.exec();
}

To copy to clipboard, switch view to plain text mode 

and the mainwindows.cpp

#include "mainwindow.h"
#include "ui_mainwindow.h"
 
MainWindow::MainWindow(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::MainWindow)
{
    ui->setupUi(this);
 
   mapper = new QDataWidgetMapper(this);
 
      mapper->addMapping(ui->lineEdit,0);
}
 
 
MainWindow::~MainWindow()
{
    delete ui;
}

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

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

   mapper = new QDataWidgetMapper(this);

      mapper->addMapping(ui->lineEdit,0);
}


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

To copy to clipboard, switch view to plain text mode 

How could I tell the lineEdit to insert what i type in, into zero.un of my postgresql database ?

I rely on you, since i am not good enough to make it on my own,

LeHibou

[wysota]

Did you connect the widget mapper to a model?