《qt连接数据库(MySQL).doc》由会员分享，可在线阅读，更多相关《qt连接数据库(MySQL).doc（7页珍藏版）》请在三一文库上搜索。
1、/代码C/C+/Objective-C代码QSqlDatabase db =QSqlDatabase:addDatabase("QMYSQL"/*"QODBC"*/); becomes the new default conn ecti ondb.setUserName("root"); 用户名db.setPassword("password");密码db.setHostName("localhost");使用SSLdb.setDatabaseName("test");数据库
2、名db.setCo nn ectOptio ns("CLIENT_SSL=1;CLIENT_IGNORE_SPACE=1");db.setPort(3306); 端口if(db.ope n()qDebug()«"ope nn"vvdb.lastError().driverText()vv"n"elseqDebug()vv"ope n failen"实例：#i nclude vQtSql>#in clude vQtGui>/连接函数bool createC onn ecti on()QSqlDa
3、tabase db = QSqlDatabase:addDatabase("QMYSQL");db.setHostName("localhost");db.setDatabaseName("test");db.setUserName("root");db.setPassword("123456");if(!db.ope n()QMessageBox:critical(O, QObject:tr("Database Error"), db.lastError().text();
4、return false;/如果连接成功，执行查询QSqlQuery query;query.exec("select * from stude nt");while (query. next() QStri ng n ame = query.value(3).toStri ng();QStri ng major = query.value(1).toStri ng();QMessageBox:critical( 0,n ame,major);return true;/主函数int main (i nt argc,char* argv)QApplicati on app(a
5、rgc, argv);if (!createC onnection()return 1;retur n app.exec();实例-2求 Qt 的 mysql 马驱动 libqsqlmysql.a, qsqlmysql.dll#i nclude <QtCore>#i nclude <QtGui>#i nclude <QtSql>bool conn ectDatabase()QSqlDatabase conn=QSqlDatabase:addDatabase("QMYSQL");conn .setHostName("localho
6、st");conn. setUserName("root");conn .setPassword("123456");conn. setDatabaseName("test");if(!c onn. ope n()QMessageBox:critical(0,QLabel:trUtf8("数 据库连接失败"),c onnastError().text();return false;return true;int main (i nt argc, char *argv)QApplicati on app(argc, argv);if(!c onn ectDatabase()return 1;return app.exec();感谢下载!欢迎您的下载，资料仅供参考