qt连接数据库(MySQL)(3页).doc

-qt连接数据库(MySQL)-第 3 页代码 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");/数据库名 db.setConnectOptions("CLIENT_SSL=1;CLIENT_IGNORE_SPACE=1");/使用SSL db.setPort(3306);/端口 if(db.open() qDebug()<<"openn"<<db.lastError().driverText()<<"n" else qDebug()<<"open failen" 实例：#include <QtSql> #include <QtGui> /连接函数bool createConnection() QSqlDatabase db = QSqlDatabase:addDatabase("QMYSQL"); db.setHostName("localhost"); db.setDatabaseName("test"); db.setUserName("root"); db.setPassword("123456"); if(!db.open() QMessageBox:critical(0, QObject:tr("Database Error"), db.lastError().text(); return false; /如果连接成功，执行查询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,major); return true; /主函数int main(int argc,char* argv) QApplication app(argc, argv); if (!createConnection() return 1; return app.exec(); 实例-2#include <QtCore> #include <QtGui> #include <QtSql> 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("数据库连接失败"),conn.lastError().text(); return false; return true; int main(int argc, char *argv) QApplication app(argc, argv); if(!connectDatabase() return 1; return app.exec();