qt连接数据库(MySQL).docx
代码0CH/Objc以ivcC代码QSqIDatabascdb=QSqgabaSe:addDalabase('QMYSQWQODBCr/);"becomes(henewdefaultconnectiondbsertJscrNamcCmoCW用户名db.sctP於SWOrd('pa*sw<>M"?系Wdb.se<HostNameClocalhost*);db.setDatabaseNane('esi"故据库名db.selConncctOptk)ns(C1.IENT_SS1.=I:C1.IENT_IGNORE_SPACE=*)½PSS1.db.s以PM33O6)ft-Iif(db.open()(qDebug()<<,oen'n"<<db.lastE11x)rO.driverTexi(><<>',»clsc(qDcbug()<<wopcnfailed"实例：Winulude<QtSql>#inc)u(lc<QtGui>连接函数bc>lCruHeConneCI沁n()QSqIDatabascdb=QSq11)atabasc:addI)atabasc("QMYSQ1.");db.se(HostName(',localhosl,tXdb.setDaiabaseName<lest'*)：db.sctUscrNamc("root*);db.setPasswordC,123456w);if(!db.open()(QMessageBox:xrilical(O.QObject:tr("DalabaseError")，db.lastErrort).tcxt();returnfalse:I假如连接胜利，执行杳询QSqIQueryquery:query.excx<"selectfromstu<len,);while(querj'.next()QSuingname=query.value(3).toString(>:QStringmajor=query.valuc(1).toS(ring(>QMessagcBox:cri(ical(0.nanw.major);Jreturntrue;I”主函数intmain(intargc.char4*argv)<Q/Xpplicalionap(argc.argv);i(!crealeConnection()rctumI;returnapp.exec():实例2求Qt的mysql驱动IibqsqImysq1.arqsqlmysql.dllWinclude<QCore>Wincludc<QtGui>#includc<QtSql>boolCooneciDatabaseOQS<IDatabaseconn=QSqlDatabasc:addDatabasc("QMYSQ1.");conn.se(HostName(''localhosi',conn.setUserName(,'roo,):conn.selPassword(1123456h);conn.sc<DatabscNamc("lest");if(!conn.open()QMeSSageBox:CriIiC叫OQ1.abd:IrUtf8(“数据库连接失败),conn.lastE11r().tcxt();returnfalse;Ireturntrue;intmain(intargc.char*argv)QApplicalionapp(ar*c.argv);i1(!connectI)atabasc()return1;returna.exec():
