文档介绍:[代码] [C/C++/Objective-C]代码
QSqlDatabase db =QSqlDatabase::addDatabase("QMYSQL"/*"QODBC"*/); // becomes the new default connection
("root");//用户名
("password");//密码
("localhost");
("test");//数据库名
("CLIENT_SSL=1;CLIENT_IGNORE_SPACE=1");//使用SSL
(3306);//端口
if(()){
qDebug()<<"open\n"<<().driverText()<<"\n";
}
else{
qDebug()<<"open faile\n";
}
实例:
#include <QtSql>
#include <QtGui>
//连接函数
bool createConnection(){
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
("localhost");
("test");
("root");
("123456");
if(!()){
QMessageBox::critical(0, QObject::tr("Database Error"),
().text());
return false;
}
//如果连接成功,执行查询
QSqlQuery query;
("select * from student");
while (()) {
QString name = (3).toString();
QString major = (1).toString();
QMessageBox::critical(0,name,major);
}
return true;
}
//主函数
int main(int argc,char** argv){
QApplication app(argc, argv);
if (!createConnection()){
return 1;
}
return ();