Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #include <QSqlDatabase>
- #include <QSqlQuery>
- #include <QVariant>
- #include <stdio.h>
- int main(int argc, char * argv[])
- {
- Q_UNUSED(argc);
- Q_UNUSED(argv);
- /** Connect to database */
- QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
- /** Set database name (and login for other db drivers) */
- db.setDatabaseName(":memory:");
- //db.setDatabaseName("test.db");
- /** Open database */
- if (!db.open())
- {
- return 1;
- }
- /* Do some queries with the default connectin */
- QSqlQuery query;
- query.exec("CREATE TABLE test (id int primary key, name varchar(20))");
- query.exec("INSERT INTO test VALUES (1, 'Name 1')");
- query.exec("INSERT INTO test VALUES (2, 'Name 2')");
- query.exec("INSERT INTO test VALUES (3, 'Name 3')");
- query.prepare("INSERT INTO test VALUES (4, :bindval)");
- query.bindValue(":bindval", "Name 4");
- query.exec();
- query.exec("SELECT * FROM test WHERE id > '2'");
- while (query.next())
- {
- QString name = query.value(1).toString();
- printf("Name: %s\n", name.toLatin1().constData());
- }
- /** Database closed in destructor */
- return 0;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement