Qt4连接mysql5数据库

#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();    
}    

 

 

 

数据库图: