学步园

一个读取access的例子

1。--------------mydialog.cpp--------------

#include "mydialog.h"
#include <QtGui/QMessageBox>
#include <QtGui/QFileDialog>
#include <QtCore/QString>
#include <QtGui/QFontDialog>
#include <QtGui/QIcon>
#include <QtSql/QSqlDatabase>
#include <QtSql/QSqlQuery>

MyDialog::MyDialog(QWidget *parent) : QDialog(parent)
{
 setupUi(this);
 connect(pushButton_3,SIGNAL(clicked()),this,SLOT(pb3_cli()));
}

MyDialog::~MyDialog()
{

}

void MyDialog::pb3_cli()
{
 QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
 db.setDatabaseName("DRIVER={Microsoft Access Driver (*.mdb)};FIL={MS Access};DBQ=d:/pr/aa.mdb");
 bool ok = db.open();
 if(ok)
 {
   QMessageBox::information(this,"database","OK,database is opened");
   QSqlQuery  query;
   QString s1,s2,s3,s4;
   query.exec("select * from t");
   while(query.next())
   {
     s1 =query.value(0).toString();
     lineEdit_1->setText(s1);
     s2 =query.value(1).toString();
     lineEdit_2->setText(s2);
     s3=query.value(2).toString();
     lineEdit_3->setText(s3);
     s4 =query.value(3).toString();
     lineEdit_4->setText(s4);
     QMessageBox::information(this,"database","next recorder");
   }
 }
 else
    QMessageBox::information(this,"database","database Failture");
 db.close();
    }
2.---------------------------------mydialog.h-------------------------------------

#include "ui_mydialog.h"
class MyDialog : public QDialog, private Ui::MyDialog
{
     Q_OBJECT
public:
    MyDialog(QWidget *parent = 0);
 ~MyDialog();
 
public slots:
 void pb3_cli();
};
3.--------------------main.cpp---------------------------------

#include <QApplication>
#include <QLabel>
#include "mydialog.h"
#include <QtGui/QIcon>
int main(int argc, char *argv[])
{
    QApplication app (argc, argv);
   
    MyDialog *my = new MyDialog;
    my->show();
    return app.exec();
}
4.--------------pr.pro------------------------

TEMPLATE = app
TARGET =
DEPENDPATH += . release
INCLUDEPATH += .

# Input
HEADERS += mydialog.h pr_private.h
FORMS += mydialog.ui
SOURCES += main.cpp mydialog.cpp
RESOURCES += pr.qrc
RC_FILE = pr.rc
QT += sql

5.--------------------pr.rc-----------------------

IDI_ICON1               ICON    DISCARDABLE     "/img/pr.ico"