建立连接是这样的
bool DataBaseControl::initConnection(const QString &databasename,const QString &username, const QString &password,const QString &conname){ if(db.isOpen()){ db.close(); } QSqlDatabase::removeDatabase(conname); db = QSqlDatabase::addDatabase("QMYSQL3",conname); db.setHostName(serverIP);//设置主机 db.setDatabaseName(databasename); //设置数据库名称 db.setUserName(username); //设置用户名 db.setPassword(password); //设置密码 m_dbname = databasename; m_username = username; m_password = password; m_conname = conname; db.setConnectOptions("MYSQL_OPT_CONNECT_TIMEOUT = 3");
dbopenState = db.open(); //连接数据库 。。。。}
关闭连接是要 if(db.isOpen()){ db.close(); QSqlDatabase::removeDatabase(conname); }这样对么