bool MysqlCon::Connection() { if (NULL == m_mysql) { m_mysql = mysql_init(NULL); } if (NULL == m_mysql) { return false; } if (mysql_real_connect(m_mysql, m_host.c_str(), m_usr.c_str(), m_pwd.c_str(), m_dbName.c_str(), m_port, m_socket, m_clientFlag)) { m_isConnect = true; ExcuteSql(m_CodeQuery.c_str()); } else { m_isConnect = false; uint32 err = mysql_errno(m_mysql); if (err) { std::cout<<"DB connection Err = "<<err<<std::endl; } Close(); return false; } return true; }
BOOL CSqlServerDB::ModifyField(_bstr_t strTableName, _bstr_t strFieldsFormat) { _bstr_t strSql; strSql = "ALTER TABLE " + strTableName + " ALTER COLUMN " + strFieldsFormat + ""; BOOL bRes; bRes = ExcuteSql(strSql, adCmdText); return bRes; }
BOOL CSqlServerDB::RenameTable(_bstr_t strOldTableName, _bstr_t strNewTableName) { _bstr_t strSql; strSql = "SP_RENAME '" + strOldTableName + "','" + strNewTableName + "'"; BOOL bRes; bRes = ExcuteSql(strSql, adCmdText); return bRes; }
int32 MysqlCon::ExcuteSql(std::string& sql) { return ExcuteSql(sql.c_str()); }