qt連接數(shù)據(jù)庫(kù)(MySQL)

1、.代碼 C/C+/Objective-C代碼QSqlDatabase db =QSqlDatabase:addDatabase(QMYSQL/*QODBC*/); / becomes the new default connection db.setUserName(root);/用戶名 db.setPassword(password);/密碼 db.setHostName(localhost); db.setDatabaseName(test);/數(shù)據(jù)庫(kù)名 db.setConnectOptions(CLIENT_SSL=1;CLIENT_IGNORE_SPACE=1);/使用SSL db.s

2、etPort(3306);/端口 if(db.open() qDebug()openndb.lastError().driverText()n; else qDebug()open failen; 實(shí)例：#include #include /連接函數(shù)bool createConnection() QSqlDatabase db = QSqlDatabase:addDatabase(QMYSQL); db.setHostName(localhost); db.setDatabaseName(test); db.setUserName(root); db.setPassword(123456);

3、if(!db.open() QMessageBox:critical(0, QObject:tr(Database Error), db.lastError().text(); return false; /如果連接成功，執(zhí)行查詢QSqlQuery query; query.exec(select * from student); while (query.next() QString name = query.value(3).toString(); QString major = query.value(1).toString(); QMessageBox:critical(0,name,

4、major); return true; /主函數(shù)int main(int argc,char* argv) QApplication app(argc, argv); if (!createConnection() return 1; return app.exec(); 實(shí)例-2求Qt的mysql驅(qū)動(dòng)libqsqlmysql.a, qsqlmysql.dll#include #include #include bool connectDatabase() QSqlDatabase conn=QSqlDatabase:addDatabase(QMYSQL); conn.setHostName(localhost); conn.setUserName(root); conn.setPassword(123456); conn.setDatabaseName(test); if(!conn.open() QMessageBox:critical(0,QLabel:trUtf8(數(shù)據(jù)庫(kù)連接失敗),conn.lastError().text(); return false; return true; int main(int argc, char *argv) QApplica