ConnSQLServer("127.0.0.1","test1","sa","123456");
bool ConnSQLServer(const QString ip,const QString dbName,const QString userName,const QString passwd)
{
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC"); //数据库驱动类型为SQL Server
qDebug()<<"ODBC driver?"<<db.isValid();
QString dsn = QString("DRIVER={SQL SERVER};SERVER=%1;DATABASE=%2").arg(ip).arg(dbName);
db.setDatabaseName(dsn);
db.setUserName(userName); //登录用户
db.setPassword(passwd); //密码
if(!db.open()) //打开数据库
{
qDebug()<<db.lastError().text();
QMessageBox::critical(0, QObject::tr("Database error"), db.lastError().text());
return false; //打开失败
}
else
{
qDebug()<<"database open success!";
QMessageBox::critical(0, QObject::tr("Database ok"),"数据库打开成功");
QSqlQuery query(db); //查询Card表并输出,测试能否正常操作数据库
query.exec("select * from test");
qDebug()<<"select start";
while(query.next())
{
qDebug()<<query.value(0).toString() <<query.value(1).toString() ;
}
qDebug()<<"select end";
}
return true;
}