手把手教你用qt链接sqlserver数据库

#include "mainwindow.h" #include "ui_mainwindow.h" MainWindow::MainWindow(QWidget *parent) : QMainWindow(parent) , ui(new Ui::MainWindow) { ui->setupUi(this); ConnectSql(); qDebug()<<"nNodeID nParentID strNodeName:"; ui->textEdit->append("nNodeID nParentID strNodeName:"); for(int i = 0;i<m_lstNodeInSql.count();i++) { QString str = " "+QString::number(m_lstNodeInSql[i].nNodeID)+", "+QString::number(m_lstNodeInSql[i].nParentID)+", "+m_lstNodeInSql[i].strNodeName; ui->textEdit->append(str); qDebug()<<" "<<m_lstNodeInSql[i].nNodeID<<" "<<m_lstNodeInSql[i].nParentID<<" "<<m_lstNodeInSql[i].strNodeName; } } void MainWindow::ConnectSql() { QSqlDatabase db= QSqlDatabase::addDatabase("QODBC", "dbTemp"); db.setDatabaseName(QString("DRIVER={SQL SERVER};" "SERVER=%1;" //服务器名称 "DATABASE=%2;"//数据库名 "UID=%3;" //登录名 "PWD=%4;" //密码 ).arg("127.0.0.1,1433")//默认的sqlserver的端口号是1433 .arg("TestSql") .arg("sa") .arg("Qwerty*963.-+")//填写你的sa账号的密码 ); //数据库连接 bool ok = db.open(); if(ok) { ui->textEdit->append("database open success"); qDebug()<<"database open success"; } else { ui->textEdit->append(db.lastError().text()); qDebug()<<db.lastError(); return; } //数据库查询 QSqlQuery query(db); ui->textEdit->append("SELECT * FROM TableTopo"); query.exec("SELECT * FROM TableTopo;"); while(query.next()) { NodeInSql node; if(query.value(1).isValid()) node.nNodeID = query.value(1).toInt(); if(query.value(2).isValid()) node.nParentID = query.value(2).toInt(); if(query.value(3).isValid()) node.strNodeName = query.value(3).toString(); m_lstNodeInSql.append(node); } db.close(); } MainWindow::~MainWindow() { delete ui; }