C++使用VS+vcpkg+sqlpp11连接mysql

布满荆棘的人生 2022-10-16 04:53 131阅读 0赞

`注1：MySQL自带的库连接数据库看着太不和谐，这里使用sqlpp11以及其配套的sqlpp11-connector-mysql[mysql]连接数据库`  
`注2：sqlpp11-connector-mysql[mysql]安装有个坑，可以使用vcpkg install sqlpp11-connector-mysql[core,mysql]:x64-windows命令安装，详细参考https://github.com/microsoft/vcpkg/issues/12040`  
![注2图片][2]

## 一、vcpkg配置以及与VS集成 ##

`详情参考官方文档：https://github.com/Microsoft/vcpkg#quick-start-windows或https://gitee.com/mirrors/vcpkg?_from=gitee_search`  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NTc1Nzg5_size_16_color_FFFFFF_t_70]

## 二、安装相关库 ##

1.  安装`sqlpp11-connector-mysql[core,mysql]:x64-windows`  
    `使用文档及示例：https://github.com/rbock/sqlpp11-connector-mysql或https://gitee.com/warm_dawn/sqlpp11-connector-mysql?_from=gitee_search`

![在这里插入图片描述][2021052623005738.png]

1.  安装`sqlpp11:x64-windows`  
    `使用文档及示例：https://github.com/rbock/sqlpp11或https://gitee.com/mirrors/sqlpp11?_from=gitee_search`  
    `此库使用较为冗长，但还算较为好理解`  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NTc1Nzg5_size_16_color_FFFFFF_t_70 1]

## 三、集成进VS后直接在VS普通项目中使用 ##

1.  创建项目  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NTc1Nzg5_size_16_color_FFFFFF_t_70 2]
2.  创建测试表  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NTc1Nzg5_size_16_color_FFFFFF_t_70 3]
3.  项目位数与库保持一致  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NTc1Nzg5_size_16_color_FFFFFF_t_70 4]

`记得安装的库位数与项目一致`

1.  表描述代码table.h

#pragma once
    #include "sqlpp11/table.h"
    #include "sqlpp11/char_sequence.h"
    #include "sqlpp11/column_types.h"
    
    namespace test_table_
    { 
    
    	struct id_
    	{ 
    		struct _alias_t
    		{ 
    			static constexpr const char _literal[] = "id";
    			using _name_t = sqlpp::make_char_sequence<sizeof(_literal), _literal>;
    			template <typename T>
    			struct _member_t
    			{ 
    				T id;
    				T& operator()()
    				{ 
    					return id;
    				}
    				const T& operator()() const
    				{ 
    					return id;
    				}
    			};
    		};
    		using _traits = ::sqlpp::make_traits<::sqlpp::integer>;
    	};
    
    	struct account_
    	{ 
    		struct _alias_t
    		{ 
    			static constexpr const char _literal[] = "account";
    			using _name_t = sqlpp::make_char_sequence<sizeof(_literal), _literal>;
    			template <typename T>
    			struct _member_t
    			{ 
    				T account;
    				T& operator()()
    				{ 
    					return account;
    				}
    				const T& operator()() const
    				{ 
    					return account;
    				}
    			};
    		};
    		using _traits = ::sqlpp::make_traits<::sqlpp::varchar>;
    	};
    
    	struct password_
    	{ 
    		struct _alias_t
    		{ 
    			static constexpr const char _literal[] = "password";
    			using _name_t = sqlpp::make_char_sequence<sizeof(_literal), _literal>;
    			template <typename T>
    			struct _member_t
    			{ 
    				T password;
    				T& operator()()
    				{ 
    					return password;
    				}
    				const T& operator()() const
    				{ 
    					return password;
    				}
    			};
    		};
    		using _traits = ::sqlpp::make_traits<::sqlpp::varchar>;
    	};
    
    
    
    
    }
    
    struct test_table : sqlpp::table_t<test_table, test_table_::id_, test_table_::account_, test_table_::password_>
    { 
    	using _value_type = sqlpp::no_value_t;
    	struct _alias_t
    	{ 
    		static constexpr const char _literal[] = "test_table";
    		using _name_t = sqlpp::make_char_sequence<sizeof(_literal), _literal>;
    		template <typename T>
    		struct _member_t
    		{ 
    			T tb;
    			T& operator()()
    			{ 
    				return tb;
    			}
    			const T& operator()() const
    			{ 
    				return tb;
    			}
    		};
    	};
    };

1.  查询代码main.cpp

#include <iostream>
    #include <sqlpp11/sqlpp11.h>
    #include <sqlpp11/mysql/mysql.h>
    #include <iostream>
    #include <memory>
    #include "table.h"
    using namespace sqlpp;
    using namespace std;
    
    std::shared_ptr <mysql::connection> connect_database()
    { 
    	auto config = std::make_shared<mysql::connection_config>();
    	//数据库地址
    	config->host = "127.0.0.1";
    	//端口号
    	config->port = 3306;
    	//数据库登陆账号
    	config->user = "root";
    	//数据库登陆密码
    	config->password = "root";
    	//要操作的数据库
    	config->database = "test";
    	// config->debug = true;
    	return std::make_shared<mysql::connection>(config);
    }
    
    int main() { 
    	auto db = connect_database();
    	test_table tb{ };
    	uint32_t limit{  1 };
    	const auto& row = db->run(sqlpp::select(all_of(tb)).from(tb).unconditionally());
    	if (!row.empty()) { 
    		const auto& rs = row.front();
    		cout << rs.id << "\t" << rs.account.text << "\t" << rs.password.text << "\n";
    	}
    	return 0;
    }

1.  测试数据  
    ![在这里插入图片描述][20210526233149447.png]
2.  连接使用  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NTc1Nzg5_size_16_color_FFFFFF_t_70 5]

[2]: /images/20221014/7df9f2b94bf14a97ace179ab9d6e9e5d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NTc1Nzg5_size_16_color_FFFFFF_t_70]: /images/20221014/ab2dabea8cef4de0a0083c35f11ea197.png
[2021052623005738.png]: /images/20221014/34db0b9d0fb7471798603f72cd3e53d1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NTc1Nzg5_size_16_color_FFFFFF_t_70 1]: /images/20221014/11e71a3f106b4ef89146c1f4b7fb4206.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NTc1Nzg5_size_16_color_FFFFFF_t_70 2]: /images/20221014/a221fb4f2e914cc68a35e532a4030505.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NTc1Nzg5_size_16_color_FFFFFF_t_70 3]: /images/20221014/1d1baf603184439f9032d2a7fe7654c5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NTc1Nzg5_size_16_color_FFFFFF_t_70 4]: /images/20221014/3e41bdbb68a343c680e3b95496b7655d.png
[20210526233149447.png]: /images/20221014/943e9a0fc3e944b5b9b41bab99f06861.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0NTc1Nzg5_size_16_color_FFFFFF_t_70 5]: /images/20221014/e899cee4aad74e89910dceaf07bb9e0a.png