在vs中使用Qt連接配接SQLServer資料庫

更多0

c++資料庫

//1.添加SQL庫:“Qt project setting”–>“Qt Modules”,在SQL library複選框前打勾.

//2.添加頭檔案

#include

#include <QtSql/QSqlDatabase>

#include <QtSql/QSqlTableModel>

#include<QtSql/QSqlError>

//3.建立連接配接

qDebug()<<“available driver:”;

QStringList drivers=QSqlDatabase::drivers();

foreach(QString driver,drivers)

qDebug()<<"/t"<<driver;

QSqlDatabase db=QSqlDatabase::addDatabase(“QODBC3”);

qDebug()<<“ODBC driver?”<<db.isValid();

QString dsn=QString::fromLocal8Bit(“DRIVER={SQL SERVER};SERVER=192.168.0.123;DATABASE=test”); db.setHostName(“192.168.0.123”);

db.setDatabaseName(dsn);

db.setUserName(“sa”);

db.setPassword(“111111”);

if(!db.open())

{

qDebug()<<db.lastError().text();

QMessageBox::critical(0,QObject::tr(“Database Error”),db.lastError().text());

return false;

}

//4.查詢資料

QSqlQuery query;

query.exec(“select * from mytable”);

while(query.next())

{

…

}

//該片段來自于http://outofmemory.cn