一:代码。
- /**连接sql server数据库
- *数据库名:abc
- *表名:SQL_2000
- *用户名:sa
- *密码:123
- *端口号:(默认)1433
- */
- void MainDialog::connectSql(QString sIp, int iPort, QString sDbNm, QString sUserNm, QString sPwd)
- {
- db = QSqlDatabase::addDatabase("QODBC");
- QString dsn = QString("Driver={sql server};SERVER=%1;PORT=%2;DATABASE=%3;UID=%4;PWD=%5;")
- .arg(sIp)
- .arg(iPort)
- .arg(sDbNm)
- .arg(sUserNm)
- .arg(sPwd);
- db.setDatabaseName(dsn);
- /*连接sql 2000*/
- bool r = db.open();
- if (r)
- {
- qDebug() << "SQL Server 2000 Connect OK!";
- /* 计算当前表中id*/
- QSqlQuery query1 = QSqlQuery(db);
- query1.clear();
- query1.prepare("select top 1 ID from SQL_2000 order by ID desc");
- bool a = query1.exec();
- int id;
- if (a)
- {
- while(query1.next())
- {
- id = query1.value(0).toInt();
- }