qt连接数据库(MySQL)
[代码] [C/C++/Objective-C]代码
01 | QSqlDatabase db =QSqlDatabase::addDatabase( "QMYSQL" /*"QODBC"*/ ); // becomes the new default connection |
02 | db.setUserName( "root" ); //用户名 |
03 | db.setPassword( "password" ); //密码 |
04 | db.setHostName( "localhost" ); |
05 | db.setDatabaseName( "test" ); //数据库名 |
06 | db.setConnectOptions( "CLIENT_SSL=1;CLIENT_IGNORE_SPACE=1" ); //使用SSL |
07 | db.setPort(3306); //端口 |
08 | if (db.open()){ |
09 | qDebug()<< "open/n" <<db.lastError().driverText()<< "/n" ; |
10 | } |
11 | else { |
12 | qDebug()<< "open faile/n" ; |
13 | } |