/****************************************************************************** $Id: qt/connection.cpp   3.3.4   edited Nov 14 2003 $**** Copyright (C) 1992-2002 Trolltech AS.  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 <qsqldatabase.h>#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;}