//QSqlDatabase * dbconn;
bool Connection::connectDB()
{
dbconn = QSqlDatabase::database("drug",false);//与名为“drug”的数据库建立连接,并返回QSqlDatabase对象
if(dbconn.isValid()){
qDebug() <<"database is valid "<< dbconn.isValid();
//return true;
}else{
dbconn = QSqlDatabase::addDatabase("QODBC", "drug");//如果没有名为"drug"的数据库,则添加数据库"drug",并指定数据库驱动程序为"QODBC"
QString dsn = QString("DRIVER={Microsoft Access Driver (*.mdb)};FIL={MS Access};DBQ=drug.mdb;");
dbconn.setDatabaseName(dsn);//设置数据库名
}
if(!dbconn.isOpen()){ //打开与数据库的连接
if(!dbconn.open()){
//can not open the db
qDebug() <<"can not open database";
return false;
} else{
qDebug()<<"open database";
return true;
}
}else{
qDebug()<< "it had already open database.";
return true;
}
}