C++Mysql使用库及实例

1、头文件引用 $(MySql_DIR)\include 2、lib引用 $(MySql_DIR)\$(PlatformTarget) libmysql mysql-5.7.27-win32、mysql-8.0.12-winx64 #include "MySqlFunc.h" MySqlFunc* m_pMySqlFuncDlg; m_pMySqlFuncDlg->ConnectDatabase(host, user, psw, table, port); BOOL CFFMPEGLib::SaveFileName(char* fileName, int fileIsSub, int cameraIndex) { char sql[MAX_PATH]; string str = fileName; string::size_type pos = 0; while ((pos = str.find("\\", pos)) != std::string::npos) { str.replace(pos, 1, "/"); pos += 1; } sprintf_s(sql, "insert into t_imagefilestore (FilePath,FileIsSub,CameraIndex) values('%s',%d,%d)", str.c_str(), fileIsSub, cameraIndex); return m_pMySqlFuncDlg->Query(sql); } BOOL CFFMPEGLib::DeleteSubFile(char* fileName) { char sql[MAX_PATH]; string str = fileName; string::size_type pos = 0; while ((pos = str.find("\\", pos)) != std::string::npos) { str.replace(pos, 1, "/"); pos += 1; } sprintf_s(sql, "delete from t_imagefilestore where FilePath='%s'", str.c_str()); return m_pMySqlFuncDlg->Query(sql); } if (m_pMySqlFuncDlg) { m_pMySqlFuncDlg->FreeConnect(); delete m_pMySqlFuncDlg; }