#include <QtCore>
#include <QtSql>
#include <QDebug>
int main(int argc, char *argv[])
{
db.setDatabaseName("testdb");
db.setUserName("test");
db.setPassword("password");
if (db.open()) {
bool ok = query.exec("create table employee (id int, name varchar(100), salary numeric)");
if (!ok) qDebug() << query.lastError();
ok = query.exec("insert into employee (id, name, salary) values (1, 'Fred', 99)");
if (!ok) qDebug() << query.lastError();
ok = query.exec("insert into employee (id, name, salary) values (2, 'George', 199)");
if (!ok) qDebug() << query.lastError();
ok = query.exec("select * from employee");
while (ok && query.next())
qDebug() << query.record();
ok = query.exec("drop table employee");
if (!ok) qDebug() << query.lastError();
}
else
qDebug() << db.lastError();
return 0;
}
#include <QtCore>
#include <QtSql>
#include <QDebug>
int main(int argc, char *argv[])
{
QCoreApplication app(argc, argv);
QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
db.setDatabaseName("testdb");
db.setUserName("test");
db.setPassword("password");
if (db.open()) {
QSqlQuery query;
bool ok = query.exec("create table employee (id int, name varchar(100), salary numeric)");
if (!ok) qDebug() << query.lastError();
ok = query.exec("insert into employee (id, name, salary) values (1, 'Fred', 99)");
if (!ok) qDebug() << query.lastError();
ok = query.exec("insert into employee (id, name, salary) values (2, 'George', 199)");
if (!ok) qDebug() << query.lastError();
ok = query.exec("select * from employee");
while (ok && query.next())
qDebug() << query.record();
ok = query.exec("drop table employee");
if (!ok) qDebug() << query.lastError();
}
else
qDebug() << db.lastError();
return 0;
}
To copy to clipboard, switch view to plain text mode
Bookmarks