16,216
社区成员
发帖
与我相关
我的任务
分享
#include <QtCore/QCoreApplication>
#include <QtSql>
#include <QDebug>
int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);
QSqlDatabase dbAc = QSqlDatabase::addDatabase("QODBC");
qDebug() << "ODBC driver valid?" << dbAc.isValid();
dbAc.setDatabaseName(QString("DRIVER={Microsoft Access Driver (*.mdb)};FIL={MS Access};DBQ=Files.mdb;UID=;PWD="));
qDebug()<<dbAc.databaseName();
if ( !dbAc.open("",""))
{ qDebug()<<"DB open error!"; }
else
{ qDebug()<<"DB open Sucess!"; }
return a.exec();
}
#include <qapplication.h>
#include <qsqldatabase.h>
#include <qsqlquery.h>
#define DB_NaSCoM_DRIVER "QODBC3"
#define DB_NaSCoM_DBNAME "manoj"
#define DB_NaSCoM_USER "scicom"
#define DB_NaSCoM_PASSWD ""
#define DB_NaSCoM_HOST "hpstryker"
int main( int argc, char *argv[] )
{
QApplication app ( argc, argv, FALSE );
QSqlDatabase *defaultDB = QSqlDatabase::addDatabase(
DB_NaSCoM_DRIVER );
defaultDB->setDatabaseName( DB_NaSCoM_DBNAME );
defaultDB->setUserName( DB_NaSCoM_USER );
defaultDB->setPassword( DB_NaSCoM_PASSWD );
defaultDB->setHostName( DB_NaSCoM_HOST );
if ( defaultDB->open() ) {
// Database successfully opened; we can now issue SQL
commands.
QSqlQuery query(QString::null, defaultDB);
query.exec ("SELECT * FROM igifile");
if ( query.isActive()) {
While (query.next ()) {
qDebug (query.value (1).toString() + ": " +
query.value (2).toString ());
}
}
}
return 0;
}