QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("DRIVER={Microsoft Access Driver (*.mdb)};FIL={MS Access};DBQ=d:/ppp/aaa.mdb");
bool ok = db.open();
if(ok)
{
QSqlQuery query;
QString s1,s2;
query.exec("select * from t1");
while(query.next())
{
s1=query.value(0).toString();
s2=query.value(1).toString();
if(lineEdit1->text()==s1&&lineEdit2->text()==s2)
QMessageBox::about(this,tr("Welcome!"),tr("欢迎光临!"));
else
QMessageBox::about(this,tr("Error!"),tr("用户名或密码错误!"));
}
}
else
QMessageBox::about(this,tr("Welcome!"),tr("数据库打开失败!"));
db.close();
}
错误:
D:/ppp/logdialog.cpp:23: undefined reference to `_imp___ZN12QSqlDatabase17defaultConnectionE'
D:/ppp/logdialog.cpp:23: undefined reference to `_imp___ZN12QSqlDatabase11addDatabaseERK7QStringS2_'
D:/ppp/logdialog.cpp:24: undefined reference to `_imp___ZN12QSqlDatabase15setDatabaseNameERK7QString'
D:/ppp/logdialog.cpp:25: undefined reference to `_imp___ZN12QSqlDatabase4openEv'
D:/ppp/logdialog.cpp:29: undefined reference to `_imp___ZN12QSqlDatabaseC1Ev'
D:/ppp/logdialog.cpp:29: undefined reference to `_imp___ZN9QSqlQueryC1ERK7QString12QSqlDatabase'
D:/ppp/logdialog.cpp:29: undefined reference to `_imp___ZN12QSqlDatabaseD1Ev'
D:/ppp/logdialog.cpp:29: undefined reference to `_imp___ZN12QSqlDatabaseD1Ev'
D:/ppp/logdialog.cpp:31: undefined reference to `_imp___ZN9QSqlQuery4execERK7QString'
D:/ppp/logdialog.cpp:32: undefined reference to `_imp___ZN9QSqlQuery4nextEv'
D:/ppp/logdialog.cpp:34: undefined reference to `_imp___ZNK9QSqlQuery5valueEi'
D:/ppp/logdialog.cpp:36: undefined reference to `_imp___ZNK9QSqlQuery5valueEi'
D:/ppp/logdialog.cpp:40: undefined reference to `_imp___ZN9QSqlQueryD1Ev'
D:/ppp/logdialog.cpp:40: undefined reference to `_imp___ZN9QSqlQueryD1Ev'
D:/ppp/logdialog.cpp:45: undefined reference to `_imp___ZN12QSqlDatabase5closeEv'
D:/ppp/logdialog.cpp:45: undefined reference to `_imp___ZN12QSqlDatabaseD1Ev'
:-1: error: collect2: ld returned 1 exit status