qt连接数据库(MySQL).doc

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);/数据库名 db.setConnectOptions(CLIENT_SSL=1;CLIENT_IGNORE_SPACE=1);/使用SSL db.

2、setPort(3306);/端口 if(db.open() qDebug()openndb.lastError().driverText()n; else qDebug()open failen; 实例：#include #include /连接函数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; /如果连接成功，执行查询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; /主函数int main(int argc,char* argv) QApplication app(argc, argv); if (!createConnection() return 1; return app.exec(); 实例-2求Qt的mysql驱动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(数据库连接失败),conn.lastError().text(); return false; return true; int main(int argc, char *argv) QApplication app(argc, argv