使用QT对access数据库进行操作——数据库中表、记录和域的读取

开始学习QT和数据库了，边学习边写了一个玩具程序，读表记录域如果有什么更简单的方法，请大家指点。

#include <QtCore/QCoreApplication>

#include <QTextStream>

#include <QtDebug>

#include <QSqlDatabase>

#include <QStringList>

#include <QSqlError>

#include <QSqlIndex>

#include <QSqlRecord>

#include <QSqlQuery>

#include <QVariant>

int main(int argc, char *argv[])

{

    QCoreApplication a(argc, argv);

    //连接数据库

    QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");

    db.setDatabaseName("DRIVER={Microsoft Access Driver (*.mdb)};FIL={MS Access};DBQ=I:/mycode/ConnectAccess/test.mdb");

    QString out_str;

    QTextStream out(stdout);

    QSqlError err;

    QSqlRecord record;

    bool ok = db.open();

    if(ok){//success

        //读数据库中的表

        QStringList tables;

        QString tabName,sqlString;

        tables = db.tables(QSql::Tables);

        //读表中记录

        for (int i = 0; i < tables.size(); ++i){

            tabName = tables.at(i);

            qDebug()<<tabName;

            sqlString = "select * from " + tabName;

            QSqlQuery q(sqlString);

            //QSqlQuery q("select * from product");

            QSqlRecord rec = q.record();

            int fieldCount = rec.count();

            qDebug() << "Number of columns: " << fieldCount;

            int i;

            QString fieldName;

            for(i=0;i<fieldCount;i++){

                fieldName = rec.fieldName(i);

                out<<fieldName<<"\t";

            }

            out<<endl;

            while(q.next()){

              for(int i=0;i<fieldCount;i++){

                        out<<q.value(i).toString();

                        out<<"\t";

                    }

                    out<<endl;

                }

        }

        }

        else{//fail

            out_str="open fail\n";

            out << out_str <<endl;

            err = db.lastError();

            out_str = err.databaseText();

            out << out_str <<endl;

            out_str = err.driverText();

            out << out_str <<endl;

        }

    return a.exec();

}

文章出自http://blog.csdn.net/apn172/article/details/7085212