VS2022通过CMake配置MySQL C++ Connector

cmake_minimum_required (VERSION 3.8)
set(CMAKE_PREFIX_PATH "D:/c.app/mysql-connector-c++(release)")
set(MYSQL_CONCPP_ROOT "D:/c.app/mysql-connector-c++(release)")
set(MYSQL_CONCPP_LIBRARIES
    ${MYSQL_CONCPP_ROOT}/lib64/vs14/mysqlcppconn.lib
    ${MYSQL_CONCPP_ROOT}/lib64/vs14/mysqlcppconn8.lib
)
project ("rapidjsontest")
find_package(mysql-concpp REQUIRED)
add_executable (rapidjsontest "rapidjsontest.cpp" "rapidjsontest.h")
target_link_libraries(rapidjsontest ${MYSQL_CONCPP_LIBRARIES})

上面的D盘下的目录就是博主从mysql官网下载的C++ Connector库的目录，博主下载的是release版的。 

关键语句是set(CMAKE_PREFIX_PATH "D:/c.app/mysql-connector-c++(release)")，如果没有这个语句就会不断出现以下的错误(这不是同一个项目，这是之前博主的另一个项目出现了下面的问题，就是因为没加这条代码)

1> [CMake] CMake Error at D:\CodeLamp\C++\MYSQL\test2\CMakeLists.txt:17 (find_package):
1> [CMake]   By not providing "Findmysql-concpp.cmake" in CMAKE_MODULE_PATH this project
1> [CMake]   has asked CMake to find a package configuration file provided by
1> [CMake]   "mysql-concpp", but CMake did not find one.
1> [CMake] 
1> [CMake]   Could not find a package configuration file provided by "mysql-concpp" with
1> [CMake]   any of the following names:
1> [CMake] 
1> [CMake]     mysql-concppConfig.cmake
1> [CMake]     mysql-concpp-config.cmake
1> [CMake] 
1> [CMake]   Add the installation prefix of "mysql-concpp" to CMAKE_PREFIX_PATH or set
1> [CMake]   "mysql-concpp_DIR" to a directory containing one of the above files.  If
1> [CMake]   "mysql-concpp" provides a separate development package or SDK, be sure it
1> [CMake]   has been installed.
1> [CMake] 
1> [CMake] 
1> [CMake] -- Configuring incomplete, errors occurred!

如果要运行和数据库操作有关的代码，还要把几个动态链接库加到.exe目录下，具体可以看我之前的文章 http://t.csdnimg.cn/qyCKT

在包含了mysql里面的statement.h头文件的情况下成功运行了代码，说明库导入成功了。

成功在对应的mysql数据库中创建了学生表。