QSqlDatabase acDb = QSqlDatabase::addDatabase("QODBC", "accessDB");
const QString dsn(QString("DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};FIL={MS Access};DBQ=%1;Uid=%2;Pwd=%3")
.arg("H:/qtBao/idr.mdb")
.arg("admin")
.arg("routon2005"));
acDb.setDatabaseName(dsn);
if(acDb.open()){
qDebug()<<"连接AccessDB成功";
QSqlQuery conn=QSqlQuery(acDb);
QString sql="select * from iDRTable";
conn.exec(sql);
while (conn.next()) {
qDebug()<<conn.value("姓名").toString()<<conn.value("公民身份号码").toString();
}
}else {
qDebug()<<"连接AccessDB失败"<<acDb.lastError().text();
}
qt 连接access数据库
最新推荐文章于 2024-07-08 17:11:23 发布