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
|
// Qt
#include <QtCore>
#include <QtGui>
#include <QtSql>
int main(int argc, char* argv[])
{
QApplication app(argc, argv);
// BD
QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
db.setHostName("localhost");
db.setUserName("lumz");
db.setPassword("*********");
db.setDatabaseName("ma_bdd");
if(!db.open())
{
QMessageBox::critical(0, QObject::trUtf8("Erreur de connexion"), QObject::trUtf8("Impossible de se connecter à la base de données."), QMessageBox::Cancel);
}
// Modèle
QSqlTableModel *model = new QSqlTableModel;
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
model->setTable("t_events");
model->select();
model->record(0).setValue(2, "Test");
model->submitAll();
return app.exec();
} |