From bd0f3345a938b35ce6a12f6150373b0955b8dd12 Mon Sep 17 00:00:00 2001 From: Timothy Pearson Date: Sun, 10 Jul 2011 15:24:15 -0500 Subject: Add Qt3 development HEAD version --- examples/sql/overview/connection.cpp | 50 ++++++++++++++++++++++++++++++++++++ 1 file changed, 50 insertions(+) create mode 100644 examples/sql/overview/connection.cpp (limited to 'examples/sql/overview/connection.cpp') diff --git a/examples/sql/overview/connection.cpp b/examples/sql/overview/connection.cpp new file mode 100644 index 0000000..6afaa53 --- /dev/null +++ b/examples/sql/overview/connection.cpp @@ -0,0 +1,50 @@ +/**************************************************************************** +** +** Copyright (C) 1992-2008 Trolltech ASA. All rights reserved. +** +** This file is part of an example program for Qt. This example +** program may be used, distributed and modified without limitation. +** +*****************************************************************************/ +#include +#include "connection.h" + +bool createConnections() +{ + + QSqlDatabase *defaultDB = QSqlDatabase::addDatabase( DB_SALES_DRIVER ); + defaultDB->setDatabaseName( DB_SALES_DBNAME ); + defaultDB->setUserName( DB_SALES_USER ); + defaultDB->setPassword( DB_SALES_PASSWD ); + defaultDB->setHostName( DB_SALES_HOST ); + if ( ! defaultDB->open() ) { + qWarning( "Failed to open sales database: " + defaultDB->lastError().text() ); + return FALSE; + } + + QSqlDatabase *oracle = QSqlDatabase::addDatabase( DB_ORDERS_DRIVER, "ORACLE" ); + oracle->setDatabaseName( DB_ORDERS_DBNAME ); + oracle->setUserName( DB_ORDERS_USER ); + oracle->setPassword( DB_ORDERS_PASSWD ); + oracle->setHostName( DB_ORDERS_HOST ); + if ( ! oracle->open() ) { + qWarning( "Failed to open orders database: " + oracle->lastError().text() ); + return FALSE; + } + + QSqlQuery q(QString::null, defaultDB); + q.exec("create table people (id integer primary key, name char(40))"); + q.exec("create table staff (id integer primary key, forename char(40), " + "surname char(40), salary float, statusid integer)"); + q.exec("create table status (id integer primary key, name char(30))"); + q.exec("create table creditors (id integer primary key, forename char(40), " + "surname char(40), city char(30))"); + q.exec("create table prices (id integer primary key, name char(40), price float)"); + q.exec("create table invoiceitem (id integer primary key, " + "pricesid integer, quantity integer, paiddate date)"); + + QSqlQuery q2(QString::null, oracle); + q2.exec("create table people (id integer primary key, name char(40))"); + + return TRUE; +} -- cgit v1.2.1