1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75
| #include <QtSql>
#include <QSqlQuery>
#include <QSqlDatabase>
#include <QWidget>
#include <QVBoxLayout>
#include <QFormLayout>
#include "essai2.h"
fenetre::fenetre() : QWidget()
{
QLabel *titre = new QLabel(this);
titre->setText("Saisie des mouvements bancaires");
QLineEdit *date = new QLineEdit;
QComboBox *banque = new QComboBox(this);
banque->addItem("BNA");
banque->addItem("ATB");
QComboBox *sens = new QComboBox(this);
sens->addItem("DEBIT");
sens->addItem("CREDIT");
QLineEdit *libelle = new QLineEdit;
QLineEdit *montant = new QLineEdit;
QLineEdit *etatServeur = new QLineEdit;
QFormLayout *grille = new QFormLayout;
grille->addRow("Etat serveur", etatServeur);
grille->addRow("Date", date);
grille->addRow("Banque", banque);
grille->addRow("Sens", sens);
grille->addRow("Libellé", libelle);
grille->addRow("Montant", montant);
QPushButton *valider = new QPushButton;
valider->setText("Valider");
QVBoxLayout *grille_p = new QVBoxLayout;
grille_p->addWidget(titre);
grille_p->addLayout(grille);
grille_p->addWidget(valider);
this->setLayout(grille_p);
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setUserName("root");
db.setPassword("sliman");
db.setDatabaseName("lpct");
db.open();
if(db.open())
{
etatServeur->setText("Connecté à la base de données!");
}
else
{
QMessageBox::critical(0, "Database Error", db.lastError().text());
}
connect(valider, SIGNAL(clicked()), SLOT(enregistrer()));
}
void fenetre::enregistrer()
{
// QString datev;
// datev = "2011-05-05";
// requete = "INSERT INTO mouv_banque VALUES ('"+datev+"', "ATB", "DEBIT", "remise",1345)";
QSqlQuery requeteur;
requeteur.exec("INSERT INTO mouv_banque (dat, banque, sens, libel, montant) VALUES ("2010-05-05", "ATB", "DEBIT", "remise", 1345)");
} |
Partager