{"id":5275,"date":"2021-05-30T00:17:47","date_gmt":"2021-05-29T16:17:47","guid":{"rendered":"https:\/\/damogame.cn\/wordpress\/?p=5275"},"modified":"2021-05-30T00:17:47","modified_gmt":"2021-05-29T16:17:47","slug":"mysql_use","status":"publish","type":"post","link":"https:\/\/i007.cc\/wordpress\/archives\/5275","title":{"rendered":"mysql++_use"},"content":{"rendered":"<p class=\"_1RuRku\"><a href=\"https:\/\/www.jianshu.com\/p\/d521af69dcc6\">\u539f\u6587\u5730\u5740<\/a><\/p>\n<p>&nbsp;<\/p>\n<div class=\"rEsl9f\">\n<div class=\"_2mYfmT\"><a class=\"_1qp91i _1OhGeD\" href=\"https:\/\/www.jianshu.com\/u\/a19dd09a1fa4\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"_13D2Eh\" src=\"https:\/\/cdn2.jianshu.io\/assets\/default_avatar\/3-9a2bcc21a5d89e21dafc73b39dc5f582.jpg\" alt=\"\" \/><\/a><\/p>\n<div>\n<div class=\"_3U4Smb\"><span class=\"FxYr8x\"><a class=\"_1OhGeD\" href=\"https:\/\/www.jianshu.com\/u\/a19dd09a1fa4\" target=\"_blank\" rel=\"noopener noreferrer\">\u4e00\u652f\u82c7\u8349<\/a><\/span><button class=\"_3kba3h _1OyPqC _3Mi9q9 _34692-\" type=\"button\" data-locale=\"zh-CN\">\u5173\u6ce8<\/button><\/div>\n<div class=\"s-dsoj\"><span class=\"_3tCVn5\"><i class=\"anticon\" aria-label=\"ic-diamond\"><\/i>0.096<\/span><time datetime=\"2017-07-30T03:13:22.000Z\">2017.07.30 11:13:22<\/time>\u5b57\u6570 605\u9605\u8bfb 3,041<\/div>\n<\/div>\n<\/div>\n<\/div>\n<article class=\"_2rhmJa\">\n<hr \/>\n<p>title: Mysql++ \u4f7f\u7528<br \/>\ndate: 2017-07-26 20:42<br \/>\ntags: [Mysql++]<br \/>\ncategories: C++<\/p>\n<hr \/>\n<p>\u539f\u6587\u5730\u5740 soundblog.top<\/p>\n<h1>Mysql++ \u4f7f\u7528\u8bb0\u5f55<\/h1>\n<h2>\u524d\u8a00<\/h2>\n<p>\u6700\u8fd1\u56e0\u4e3a\u8981\u4f7f\u7528mysql \u7684c\u63a5\u53e3\uff0c\u67e5\u4e86\u597d\u591a\u8d44\u6599\u53d1\u73b0\u7f51\u4e0a\u5173\u4e8emysql\u7684c \u8d44\u6599\u662f\u771f\u7684\u4e0d\u591a\u3002\u4e0d\u8fc7\u8fd8\u597d\u67e5\u5230\u4e86\u4e00\u4e2aMysql++\u8fd9\u4e2a\u5e93\uff0c\u53ef\u4ee5\u65b9\u4fbf\u6211\u66f4\u597d\u7684\u8fdb\u884c\u5f00\u53d1\u3002\u4f46\u662f\u5373\u4f7f\u8fd9\u6837\uff0c\u5176\u4f7f\u7528\u96be\u5ea6\u4e5f\u6bd4\u4e00\u822c\u7684Java\u548cpython\u63a5\u53e3\u8981\u96be\u5f97\u591a\uff0c\u56e0\u6b64\u975e\u5e38\u6709\u5fc5\u8981\u8bb0\u5f55\u4e00\u4e0b\u8fd9\u51e0\u5929\u67e5\u5230\u7684\u8d44\u6599\uff0c\u505a\u4e00\u4e2a\u7b80\u5355\u7684\u603b\u7ed3\u3002<\/p>\n<h2>Mysql ++ \u8fde\u63a5<\/h2>\n<h3>\u5b89\u88c5<\/h3>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i class=\"anticon anticon-copy\" aria-label=\"icon: copy\"><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-bash\"><code class=\"bash  language-bash\"># http:\/\/tangentsoft.net\/mysql++\/\uff0c\u4ece\u5b98\u7f51\u4e0b\u8f7d\u7a33\u5b9a\u7248\u672cmysql++-3.2.3.tar.gz\r\ntar -zxvf mysql++-3.2.3.tar.gz\r\ncd  mysql++-3.2.3\r\n.\/configure --prefix=\/your\/install\/path\r\nmake\r\nmake install\r\n\r\n<\/code><\/pre>\n<\/div>\n<h3>\u539f\u59cb\u8fde\u63a5\u65b9\u5f0f<\/h3>\n<p>\u6211\u4eec\u53ef\u4ee5\u91c7\u53d6\u6700\u539f\u59cb\u7684\u8fde\u63a5\u65b9\u5f0f\uff0c\u4e5f\u6bd4\u8f83\u7b80\u5355\u3002<\/p>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i class=\"anticon anticon-copy\" aria-label=\"icon: copy\"><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-c\"><code class=\"c++ ++  language-c\">include <span class=\"token operator\">&lt;<\/span>mysql<span class=\"token operator\">++<\/span><span class=\"token punctuation\">.<\/span>h<span class=\"token operator\">&gt;<\/span>\r\n<span class=\"token macro property\">#<span class=\"token directive keyword\">include<\/span> <span class=\"token string\">&lt;stdlib.h&gt;<\/span><\/span>\r\n<span class=\"token macro property\">#<span class=\"token directive keyword\">include<\/span> <span class=\"token string\">&lt;stdio.h&gt;<\/span><\/span>\r\n<span class=\"token macro property\">#<span class=\"token directive keyword\">include<\/span> <span class=\"token string\">&lt;string&gt;<\/span><\/span>\r\n<span class=\"token macro property\">#<span class=\"token directive keyword\">include<\/span> <span class=\"token string\">&lt;iostream&gt;<\/span><\/span>\r\n<span class=\"token macro property\">#<span class=\"token directive keyword\">include<\/span> <span class=\"token string\">&lt;typeinfo&gt;<\/span><\/span>\r\nusing namespace std<span class=\"token punctuation\">;<\/span>\r\nusing namespace mysqlpp<span class=\"token punctuation\">;<\/span>\r\n\r\n<span class=\"token macro property\">#<span class=\"token directive keyword\">define<\/span> DATEBASE_NAME \"search\"<\/span>\r\n<span class=\"token macro property\">#<span class=\"token directive keyword\">define<\/span> DATEBASE_IP \"localhost:3306\"<\/span>\r\n<span class=\"token macro property\">#<span class=\"token directive keyword\">define<\/span> DATEBASE_USERNAME \"root\"<\/span>\r\n<span class=\"token macro property\">#<span class=\"token directive keyword\">define<\/span> DATEBASE_PWD \"DeepLearning\"<\/span>\r\n\r\n<span class=\"token keyword\">int<\/span> <span class=\"token function\">main<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\r\n<span class=\"token punctuation\">{<\/span>\r\n    Connection <span class=\"token function\">conn<\/span><span class=\"token punctuation\">(<\/span>false<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token keyword\">if<\/span><span class=\"token punctuation\">(<\/span>conn<span class=\"token punctuation\">.<\/span><span class=\"token function\">connect<\/span><span class=\"token punctuation\">(<\/span>DATEBASE_NAME<span class=\"token punctuation\">,<\/span> DATEBASE_IP<span class=\"token punctuation\">,<\/span> DATEBASE_USERNAME<span class=\"token punctuation\">,<\/span> DATEBASE_PWD<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\r\n        cout <span class=\"token operator\">&lt;&lt;<\/span> <span class=\"token string\">\"connect success !!!\"<\/span> <span class=\"token operator\">&lt;&lt;<\/span> endl<span class=\"token punctuation\">;<\/span>\r\n    Query query <span class=\"token operator\">=<\/span> conn<span class=\"token punctuation\">.<\/span><span class=\"token function\">query<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token keyword\">char<\/span><span class=\"token operator\">*<\/span> sql <span class=\"token operator\">=<\/span> <span class=\"token string\">\"select * from test\"<\/span><span class=\"token punctuation\">;<\/span>\r\n    query <span class=\"token operator\">&lt;&lt;<\/span> sql<span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token keyword\">return<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">;<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n\r\n<\/code><\/pre>\n<\/div>\n<h3>\u8fde\u63a5\u6c60\u4f7f\u7528<\/h3>\n<blockquote><p>\u8fde\u63a5\u6c60\u8fd9\u4e2a\u6982\u5ff5\u5728\u6570\u636e\u5e93\u4f7f\u7528\u4e2d\u5e38\u5e38\u4f1a\u7528\u5230\uff0c\u5bf9\u4e8e\u4e00\u822c\u7684\u4f7f\u7528\uff0c\u5bf9\u4e8e\u6570\u636e\u5e93\u7684\u8bbf\u95ee\u4e0d\u662f\u592a\u9891\u7e41\u6211\u4eec\u53ef\u4ee5\u6bcf\u6b21\u5efa\u7acb\u8fde\u63a5\uff0c\u4f7f\u7528\u5b8c\u5c31\u91ca\u653e\u8fde\u63a5\u3002\u4f46\u662f\u5bf9\u4e8e\u4e00\u4e2a\u590d\u6742\u7684\u6570\u636e\u5e93\u5e94\u7528\uff0c\u60c5\u51b5\u5c31\u5b8c\u5168\u4e0d\u540c\u4e86\uff0c\u9891\u7e41\u7684\u5efa\u7acb\u3001\u5173\u95ed\u8fde\u63a5\uff0c\u4f1a\u6781\u5927\u7684\u51cf\u4f4e\u7cfb\u7edf\u7684\u6027\u80fd\uff0c\u56e0\u4e3a\u5bf9\u4e8e\u8fde\u63a5\u7684\u4f7f\u7528\u6210\u4e86\u7cfb\u7edf\u6027\u80fd\u7684\u74f6\u9888\u3002\u8fde\u63a5\u6c60\u7684\u539f\u7406\u662f\u5148\u5728\u5185\u90e8\u5efa\u7acb\u597d\u5f88\u591a\u8fde\u63a5\uff0c\u7528\u6237\u4f7f\u7528\u7684\u65f6\u5019\u76f4\u63a5\u4ece\u8fde\u63a5\u6c60\u4e2d\u83b7\u53d6\u8fde\u63a5\u5373\u53ef\uff0c\u7528\u6237\u4f7f\u7528\u5b8c\u518d\u5f52\u8fd8\u8fde\u63a5\uff0c\u4f46\u662f\u8fde\u63a5\u5e76\u6ca1\u6709\u522b\u65ad\u5f00\uff0c\u800c\u662f\u4e3a\u4e0b\u4e00\u6b21\u4f7f\u7528\u505a\u51c6\u5907\u3002<\/p><\/blockquote>\n<ul>\n<li>mysql++ \u5185\u90e8\u5df2\u7ecf\u5b9e\u73b0\u597d\u8fde\u63a5\u6c60<\/li>\n<\/ul>\n<p>mysql++-3.2.3\/lib\/cpool.cpp \u8fd9\u662f\u6e90\u7801\u6587\u4ef6<\/p>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i class=\"anticon anticon-copy\" aria-label=\"icon: copy\"><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-c\"><code class=\"c++ ++  language-c\">virtual Connection<span class=\"token operator\">*<\/span> <span class=\"token function\">exchange<\/span><span class=\"token punctuation\">(<\/span><span class=\"token keyword\">const<\/span> Connection<span class=\"token operator\">*<\/span> pc<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/\u5c06\u5f53\u524d\u8fde\u63a5\u65ad\u5f00\u91cd\u65b0\u5f00\u542f\u4e00\u4e2a\u8fde\u63a5<\/span>\r\nvirtual Connection<span class=\"token operator\">*<\/span> <span class=\"token function\">grab<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000<span class=\"token comment\">\/\/\u4ece\u8fde\u63a5\u6c60\u83b7\u53d6\u4e00\u4e2a\u8fde\u63a5\uff0c\u5982\u679c\u6ca1\u6709\u521b\u5efa\u4e00\u4e2a<\/span>\r\nConnection<span class=\"token operator\">*<\/span> <span class=\"token function\">safe_grab<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000  <span class=\"token comment\">\/\/\u4ece\u8fde\u63a5\u6c60\u83b7\u53d6\u4e00\u4e2a\u53ef\u7528\u7684\u8fde\u63a5<\/span>\r\nvirtual <span class=\"token keyword\">void<\/span> <span class=\"token function\">release<\/span><span class=\"token punctuation\">(<\/span><span class=\"token keyword\">const<\/span> Connection<span class=\"token operator\">*<\/span> pc<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\u3000\u3000\u3000\u3000\u3000\u3000<span class=\"token comment\">\/\/\u5c06\u4e00\u4e2a\u8fde\u63a5\u7f6e\u4e3a\u672a\u4f7f\u7528\u72b6\u6001<\/span>\r\n<span class=\"token keyword\">void<\/span> <span class=\"token function\">shrink<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>                                       <span class=\"token comment\">\/\/\u4ece\u8fde\u63a5\u6c60\u5220\u9664\u672a\u4f7f\u7528\u7684\u8fde\u63a5<\/span>\r\n<span class=\"token keyword\">void<\/span> <span class=\"token function\">remove<\/span><span class=\"token punctuation\">(<\/span><span class=\"token keyword\">const<\/span> Connection<span class=\"token operator\">*<\/span> pc<span class=\"token punctuation\">)<\/span> <span class=\"token comment\">\/\/\u4ece\u8fde\u63a5\u6c60\u4e2d\u5220\u9664\u6307\u5b9a\u8fde\u63a5<\/span>\r\n\r\n<\/code><\/pre>\n<\/div>\n<ul>\n<li>\u7ee7\u627fmysqlpp::ConnectionPool \u5b9e\u73b0\u81ea\u5df1\u7684\u8fde\u63a5\u6c60<\/li>\n<\/ul>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i class=\"anticon anticon-copy\" aria-label=\"icon: copy\"><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-c\"><code class=\"c++ ++  language-c\">class MysqlConnectPool <span class=\"token operator\">:<\/span> public mysqlpp<span class=\"token operator\">::<\/span>ConnectionPool\r\n<span class=\"token punctuation\">{<\/span>\r\npublic<span class=\"token operator\">:<\/span>\r\n    <span class=\"token function\">MysqlConnectPool<\/span><span class=\"token punctuation\">(<\/span>std<span class=\"token operator\">::<\/span>string dbname<span class=\"token punctuation\">,<\/span>\r\n                    std<span class=\"token operator\">::<\/span>string serverip<span class=\"token punctuation\">,<\/span>\r\n                    std<span class=\"token operator\">::<\/span>string user<span class=\"token punctuation\">,<\/span>\r\n                    std<span class=\"token operator\">::<\/span>string passwd<span class=\"token punctuation\">,<\/span>\r\n                    <span class=\"token keyword\">int<\/span> port<span class=\"token punctuation\">,<\/span>\r\n                    std<span class=\"token operator\">::<\/span>string charset<span class=\"token punctuation\">,<\/span>\r\n                    <span class=\"token keyword\">int<\/span> max_size<span class=\"token punctuation\">)<\/span>\r\n        <span class=\"token operator\">:<\/span><span class=\"token function\">m_dbname<\/span><span class=\"token punctuation\">(<\/span>dbname<span class=\"token punctuation\">)<\/span>\r\n        <span class=\"token punctuation\">,<\/span><span class=\"token function\">m_server_ip<\/span><span class=\"token punctuation\">(<\/span>serverip<span class=\"token punctuation\">)<\/span>\r\n        <span class=\"token punctuation\">,<\/span><span class=\"token function\">m_user<\/span><span class=\"token punctuation\">(<\/span>user<span class=\"token punctuation\">)<\/span>\r\n        <span class=\"token punctuation\">,<\/span><span class=\"token function\">m_password<\/span><span class=\"token punctuation\">(<\/span>passwd<span class=\"token punctuation\">)<\/span>\r\n        <span class=\"token punctuation\">,<\/span><span class=\"token function\">m_charset<\/span><span class=\"token punctuation\">(<\/span>charset<span class=\"token punctuation\">)<\/span>\r\n        <span class=\"token punctuation\">,<\/span><span class=\"token function\">m_port<\/span><span class=\"token punctuation\">(<\/span>port<span class=\"token punctuation\">)<\/span>\r\n    <span class=\"token punctuation\">{<\/span>\r\n        m_max_size <span class=\"token operator\">=<\/span> max_size<span class=\"token punctuation\">;<\/span>\r\n        conns_in_use_ <span class=\"token operator\">=<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">;<\/span>\r\n        m_max_idle_time <span class=\"token operator\">=<\/span> <span class=\"token number\">300<\/span><span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token punctuation\">}<\/span>\r\n    \u00b7\u00b7\u00b7\u00b7\u00b7\u00b7\r\n    \u00b7\u00b7\u00b7\u00b7\u00b7\r\n<span class=\"token comment\">\/\/\u4ee3\u7801\u592a\u591a\uff0c\u6682\u65f6\u5c31\u4e0d\u8d34\u4e86\u3002\u3002\u3002https:\/\/github.com\/yqyao\/MyGit\/tree\/master\/mysql_c%2B%2B<\/span>\r\n\u8fd9\u4e2agithub\u6709\r\n<span class=\"token punctuation\">}<\/span>\r\n\r\n<\/code><\/pre>\n<\/div>\n<h3>mysql++ API\u8c03\u7528\u65b9\u5f0f<\/h3>\n<ul>\n<li>\u8f93\u5165\u5904\u7406<\/li>\n<\/ul>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i class=\"anticon anticon-copy\" aria-label=\"icon: copy\"><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-c\"><code class=\"c++ ++  language-c\"><span class=\"token macro property\">#<span class=\"token directive keyword\">include<\/span> <span class=\"token string\">&lt;memory&gt;<\/span><\/span>\r\n<span class=\"token macro property\">#<span class=\"token directive keyword\">include<\/span> <span class=\"token string\">&lt;iostream&gt;<\/span><\/span>\r\n<span class=\"token macro property\">#<span class=\"token directive keyword\">include<\/span> <span class=\"token string\">&lt;fstream&gt;<\/span><\/span>\r\n<span class=\"token macro property\">#<span class=\"token directive keyword\">include<\/span> <span class=\"token string\">&lt;vector&gt;<\/span><\/span>\r\n<span class=\"token macro property\"># <span class=\"token directive keyword\">include<\/span> <span class=\"token string\">\"unistd.h\"<\/span><\/span>\r\n<span class=\"token macro property\">#<span class=\"token directive keyword\">include<\/span> <span class=\"token string\">\"MysqlConnectPool.h\"<\/span><\/span>\r\n\r\nstd<span class=\"token operator\">::<\/span>shared_ptr<span class=\"token operator\">&lt;<\/span>MysqlConnectPool<span class=\"token operator\">&gt;<\/span> db_pool <span class=\"token operator\">=<\/span> nullptr<span class=\"token punctuation\">;<\/span>\r\nstd<span class=\"token operator\">::<\/span>string db_name <span class=\"token operator\">=<\/span> <span class=\"token string\">\"search\"<\/span><span class=\"token punctuation\">;<\/span>\r\nstd<span class=\"token operator\">::<\/span>string db_ip <span class=\"token operator\">=<\/span> <span class=\"token string\">\"localhost\"<\/span><span class=\"token punctuation\">;<\/span>\r\nstd<span class=\"token operator\">::<\/span>string db_user <span class=\"token operator\">=<\/span> <span class=\"token string\">\"root\"<\/span><span class=\"token punctuation\">;<\/span>\r\nstd<span class=\"token operator\">::<\/span>string db_passwd <span class=\"token operator\">=<\/span> <span class=\"token string\">\"DeepLearning\"<\/span><span class=\"token punctuation\">;<\/span>\r\n<span class=\"token keyword\">int<\/span> db_port <span class=\"token operator\">=<\/span> <span class=\"token number\">3306<\/span><span class=\"token punctuation\">;<\/span>\r\nstd<span class=\"token operator\">::<\/span>string db_charset <span class=\"token operator\">=<\/span> <span class=\"token string\">\"utf8\"<\/span><span class=\"token punctuation\">;<\/span>\r\n<span class=\"token keyword\">int<\/span> max_size <span class=\"token operator\">=<\/span> <span class=\"token number\">10<\/span><span class=\"token punctuation\">;<\/span>\r\n<span class=\"token keyword\">int<\/span> BUFF_SIZE <span class=\"token operator\">=<\/span> <span class=\"token number\">1024<\/span><span class=\"token punctuation\">;<\/span>\r\n<span class=\"token keyword\">char<\/span> buff<span class=\"token punctuation\">[<\/span><span class=\"token number\">1024<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span>\r\n<span class=\"token keyword\">char<\/span><span class=\"token operator\">*<\/span> createTableFormat <span class=\"token operator\">=<\/span> <span class=\"token string\">\"create table %s ;\"<\/span><span class=\"token punctuation\">;<\/span>\r\n\r\nstd<span class=\"token operator\">::<\/span>string <span class=\"token function\">getCreateString<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\r\n<span class=\"token punctuation\">{<\/span>\r\n    <span class=\"token function\">memset<\/span><span class=\"token punctuation\">(<\/span>buff<span class=\"token punctuation\">,<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> BUFF_SIZE<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token keyword\">char<\/span><span class=\"token operator\">*<\/span> temp <span class=\"token operator\">=<\/span> <span class=\"token string\">\"Student(id int, name varchar(20), status varchar(10))\"<\/span><span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token function\">snprintf<\/span><span class=\"token punctuation\">(<\/span>buff<span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">sizeof<\/span><span class=\"token punctuation\">(<\/span>buff<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> createTableFormat<span class=\"token punctuation\">,<\/span> temp<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    std<span class=\"token operator\">::<\/span>string buffAsStdStr <span class=\"token operator\">=<\/span> buff<span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token keyword\">return<\/span> buffAsStdStr<span class=\"token punctuation\">;<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n\r\n<span class=\"token keyword\">int<\/span> <span class=\"token function\">main<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\r\n<span class=\"token punctuation\">{<\/span>\r\n    db_pool <span class=\"token operator\">=<\/span> std<span class=\"token operator\">::<\/span>make_shared<span class=\"token operator\">&lt;<\/span>MysqlConnectPool<span class=\"token operator\">&gt;<\/span><span class=\"token punctuation\">(<\/span>db_name<span class=\"token punctuation\">,<\/span> db_ip<span class=\"token punctuation\">,<\/span> db_user<span class=\"token punctuation\">,<\/span> db_passwd<span class=\"token punctuation\">,<\/span> db_port<span class=\"token punctuation\">,<\/span> db_charset<span class=\"token punctuation\">,<\/span> max_size<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    std<span class=\"token operator\">::<\/span>string createTablesql <span class=\"token operator\">=<\/span> <span class=\"token function\">getCreateString<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    std<span class=\"token operator\">::<\/span>cout <span class=\"token operator\">&lt;&lt;<\/span> <span class=\"token string\">\"createTableFormat: \"<\/span> <span class=\"token operator\">&lt;&lt;<\/span> createTablesql <span class=\"token operator\">&lt;&lt;<\/span> std<span class=\"token operator\">::<\/span>endl<span class=\"token punctuation\">;<\/span>\r\n    \r\n    <span class=\"token comment\">\/\/out:createTableFormat: create table Student(id int, name varchar(20), status varchar(10))<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n\r\n<\/code><\/pre>\n<\/div>\n<ul>\n<li>\u5b9e\u9645\u6267\u884c\u8fc7\u7a0b<\/li>\n<\/ul>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i class=\"anticon anticon-copy\" aria-label=\"icon: copy\"><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-c\"><code class=\"c++ ++  language-c\"><span class=\"token keyword\">void<\/span> <span class=\"token function\">createTable<\/span><span class=\"token punctuation\">(<\/span>std<span class=\"token operator\">::<\/span>string sql<span class=\"token punctuation\">)<\/span>\r\n<span class=\"token punctuation\">{<\/span>\r\n    mysqlpp<span class=\"token operator\">::<\/span>ScopedConnection <span class=\"token function\">conn<\/span><span class=\"token punctuation\">(<\/span><span class=\"token operator\">*<\/span>db_pool<span class=\"token punctuation\">,<\/span> false<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    mysqlpp<span class=\"token operator\">::<\/span>Query query <span class=\"token operator\">=<\/span> conn<span class=\"token operator\">-&gt;<\/span><span class=\"token function\">query<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    query <span class=\"token operator\">&lt;&lt;<\/span> sql<span class=\"token punctuation\">;<\/span>\r\n    mysqlpp<span class=\"token operator\">::<\/span>SimpleResult res <span class=\"token operator\">=<\/span> query<span class=\"token punctuation\">.<\/span><span class=\"token function\">execute<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    std<span class=\"token operator\">::<\/span>cout <span class=\"token operator\">&lt;&lt;<\/span> res<span class=\"token punctuation\">.<\/span><span class=\"token function\">info<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&lt;&lt;<\/span> std<span class=\"token operator\">::<\/span>endl<span class=\"token punctuation\">;<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n<span class=\"token keyword\">int<\/span> <span class=\"token function\">main<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\r\n<span class=\"token punctuation\">{<\/span>\r\n    db_pool <span class=\"token operator\">=<\/span> std<span class=\"token operator\">::<\/span>make_shared<span class=\"token operator\">&lt;<\/span>MysqlConnectPool<span class=\"token operator\">&gt;<\/span><span class=\"token punctuation\">(<\/span>db_name<span class=\"token punctuation\">,<\/span> db_ip<span class=\"token punctuation\">,<\/span> db_user<span class=\"token punctuation\">,<\/span> db_passwd<span class=\"token punctuation\">,<\/span> db_port<span class=\"token punctuation\">,<\/span> db_charset<span class=\"token punctuation\">,<\/span> max_size<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    std<span class=\"token operator\">::<\/span>string createTablesql <span class=\"token operator\">=<\/span> <span class=\"token function\">getCreateString<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    std<span class=\"token operator\">::<\/span>cout <span class=\"token operator\">&lt;&lt;<\/span> <span class=\"token string\">\"createTableFormat: \"<\/span> <span class=\"token operator\">&lt;&lt;<\/span> createTablesql <span class=\"token operator\">&lt;&lt;<\/span> std<span class=\"token operator\">::<\/span>endl<span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token function\">createTablesql<\/span><span class=\"token punctuation\">(<\/span>createTablesql<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token comment\">\/\/out:createTableFormat: create table Student(id int, name varchar(20), status varchar(10))<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n\r\n<\/code><\/pre>\n<\/div>\n<p><strong>\u56e0\u4e3aselect \u64cd\u4f5c\u6d89\u53ca\u5230\u6570\u636e\u53d6\u51fa\uff0c\u56e0\u6b64\u9700\u8981\u91cd\u70b9\u4ecb\u7ecd<\/strong><\/p>\n<ul>\n<li>search\u64cd\u4f5c<\/li>\n<\/ul>\n<p>\u8868\u7ed3\u6784\u4e3a\u4e0a\u4e00\u6b65\u4ecb\u7ecdcreate\u6240\u521b\u5efa\u7684\u7ed3\u6784<\/p>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i class=\"anticon anticon-copy\" aria-label=\"icon: copy\"><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-c\"><code class=\"c++ ++  language-c\">std<span class=\"token operator\">::<\/span>string <span class=\"token function\">getSearchString<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\r\n<span class=\"token punctuation\">{<\/span>\r\n    <span class=\"token function\">memset<\/span><span class=\"token punctuation\">(<\/span>buff<span class=\"token punctuation\">,<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> BUFF_SIZE<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token keyword\">char<\/span><span class=\"token operator\">*<\/span> status <span class=\"token operator\">=<\/span> <span class=\"token string\">\"false\"<\/span><span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token function\">snprintf<\/span><span class=\"token punctuation\">(<\/span>buff<span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">sizeof<\/span><span class=\"token punctuation\">(<\/span>buff<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> searchFormat<span class=\"token punctuation\">,<\/span> status<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    std<span class=\"token operator\">::<\/span>string buffAsStdStr <span class=\"token operator\">=<\/span> buff<span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token keyword\">return<\/span> buffAsStdStr<span class=\"token punctuation\">;<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n\r\n<span class=\"token keyword\">void<\/span> <span class=\"token function\">search<\/span><span class=\"token punctuation\">(<\/span>std<span class=\"token operator\">::<\/span>string sql<span class=\"token punctuation\">)<\/span>\r\n<span class=\"token punctuation\">{<\/span>\r\n    <span class=\"token comment\">\/\/this scopedConnection will get the connection and release the connection to the connection pool after ~scopedConnection<\/span>\r\n    mysqlpp<span class=\"token operator\">::<\/span>ScopedConnection <span class=\"token function\">conn<\/span><span class=\"token punctuation\">(<\/span><span class=\"token operator\">*<\/span>db_pool<span class=\"token punctuation\">,<\/span> false<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    mysqlpp<span class=\"token operator\">::<\/span>Query query <span class=\"token operator\">=<\/span> conn<span class=\"token operator\">-&gt;<\/span><span class=\"token function\">query<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    query <span class=\"token operator\">&lt;&lt;<\/span> sql<span class=\"token punctuation\">;<\/span>\r\n    mysqlpp<span class=\"token operator\">::<\/span>StoreQueryResult ares <span class=\"token operator\">=<\/span> query<span class=\"token punctuation\">.<\/span><span class=\"token function\">store<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    std<span class=\"token operator\">::<\/span>cout <span class=\"token operator\">&lt;&lt;<\/span> <span class=\"token string\">\"ares.num_rows() = \"<\/span> <span class=\"token operator\">&lt;&lt;<\/span> ares<span class=\"token punctuation\">.<\/span><span class=\"token function\">num_rows<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&lt;&lt;<\/span> std<span class=\"token operator\">::<\/span>endl<span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token keyword\">for<\/span> <span class=\"token punctuation\">(<\/span>size_t i <span class=\"token operator\">=<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">;<\/span> i <span class=\"token operator\">&lt;<\/span> ares<span class=\"token punctuation\">.<\/span><span class=\"token function\">num_rows<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> i<span class=\"token operator\">++<\/span><span class=\"token punctuation\">)<\/span>\r\n    <span class=\"token punctuation\">{<\/span>\r\n        std<span class=\"token operator\">::<\/span>cout <span class=\"token operator\">&lt;&lt;<\/span> <span class=\"token string\">\"your data\"<\/span> <span class=\"token operator\">&lt;&lt;<\/span> std<span class=\"token operator\">::<\/span>endl<span class=\"token punctuation\">;<\/span>\r\n        std<span class=\"token operator\">::<\/span>cout <span class=\"token operator\">&lt;&lt;<\/span> <span class=\"token string\">\"name: \"<\/span> <span class=\"token operator\">&lt;&lt;<\/span> ares<span class=\"token punctuation\">[<\/span>i<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">\"name\"<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&lt;&lt;<\/span> <span class=\"token string\">\"\\tid: \"<\/span> <span class=\"token operator\">&lt;&lt;<\/span> ares<span class=\"token punctuation\">[<\/span>i<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">\"id\"<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&lt;&lt;<\/span> <span class=\"token string\">\"\\tstatus: \"<\/span> <span class=\"token operator\">&lt;&lt;<\/span> ares<span class=\"token punctuation\">[<\/span>i<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">\"status\"<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&lt;&lt;<\/span> std<span class=\"token operator\">::<\/span>endl<span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token punctuation\">}<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n<span class=\"token keyword\">int<\/span> <span class=\"token function\">main<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\r\n<span class=\"token punctuation\">{<\/span>\r\n    db_pool <span class=\"token operator\">=<\/span> std<span class=\"token operator\">::<\/span>make_shared<span class=\"token operator\">&lt;<\/span>MysqlConnectPool<span class=\"token operator\">&gt;<\/span><span class=\"token punctuation\">(<\/span>db_name<span class=\"token punctuation\">,<\/span> db_ip<span class=\"token punctuation\">,<\/span> db_user<span class=\"token punctuation\">,<\/span> db_passwd<span class=\"token punctuation\">,<\/span> db_port<span class=\"token punctuation\">,<\/span> db_charset<span class=\"token punctuation\">,<\/span> max_size<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    std<span class=\"token operator\">::<\/span>string searchSql <span class=\"token operator\">=<\/span> <span class=\"token function\">getSearchString<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    std<span class=\"token operator\">::<\/span>cout <span class=\"token operator\">&lt;&lt;<\/span> <span class=\"token string\">\"searchFormat: \"<\/span> <span class=\"token operator\">&lt;&lt;<\/span> searchSql <span class=\"token operator\">&lt;&lt;<\/span> std<span class=\"token operator\">::<\/span>endl<span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token function\">search<\/span><span class=\"token punctuation\">(<\/span>searchSql<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token keyword\">return<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">;<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n\r\n<\/code><\/pre>\n<\/div>\n<h3>\u6ce8\u610f\u4e8b\u9879<\/h3>\n<blockquote><p>\u6211\u4eec\u8fd9\u91cc\u7684\u4f7f\u7528\u7684\u662fMysql++ \u5b98\u65b9\u4f7f\u7528\u7684scopedConnection \u7c7b\u81ea\u52a8\u83b7\u53d6conn\uff0c\u540c\u65f6\u5229\u7528\u6790\u6784\u51fd\u6570\u53bbrelease conn\u3002\u6211\u4eec\u4e5f\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528\u539f\u59cbapi\u53bb\u4f7f\u7528\u8fd9\u4e2a\u8fde\u63a5\u3002<\/p><\/blockquote>\n<div class=\"_2Uzcx_\"><button class=\"VJbwyy\" type=\"button\" aria-label=\"\u590d\u5236\u4ee3\u7801\"><i class=\"anticon anticon-copy\" aria-label=\"icon: copy\"><\/i><\/button><\/p>\n<pre class=\"line-numbers  language-c\"><code class=\"c++ ++  language-c\">\r\n<span class=\"token keyword\">int<\/span> <span class=\"token function\">main<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\r\n<span class=\"token punctuation\">{<\/span>\r\n    db_pool <span class=\"token operator\">=<\/span> std<span class=\"token operator\">::<\/span>make_shared<span class=\"token operator\">&lt;<\/span>MysqlConnectPool<span class=\"token operator\">&gt;<\/span><span class=\"token punctuation\">(<\/span>db_name<span class=\"token punctuation\">,<\/span> db_ip<span class=\"token punctuation\">,<\/span> db_user<span class=\"token punctuation\">,<\/span> db_passwd<span class=\"token punctuation\">,<\/span> db_port<span class=\"token punctuation\">,<\/span> db_charset<span class=\"token punctuation\">,<\/span> max_size<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    <span class=\"token keyword\">const<\/span> <span class=\"token keyword\">char<\/span><span class=\"token operator\">*<\/span> search <span class=\"token operator\">=<\/span> <span class=\"token string\">\"select * from yyq\"<\/span><span class=\"token punctuation\">;<\/span>\r\n    mysqlpp<span class=\"token operator\">::<\/span>Connection<span class=\"token operator\">*<\/span> conn<span class=\"token punctuation\">;<\/span>\r\n    conn <span class=\"token operator\">=<\/span> db_pool<span class=\"token operator\">-&gt;<\/span><span class=\"token function\">grab<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\r\n    db_pool<span class=\"token operator\">-&gt;<\/span><span class=\"token function\">release<\/span><span class=\"token punctuation\">(<\/span>conn<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/\u5c06conn\u653e\u56de\u8fde\u63a5\u6c60<\/span>\r\n    db_pool<span class=\"token operator\">-&gt;<\/span><span class=\"token function\">remove<\/span><span class=\"token punctuation\">(<\/span>conn<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/\u5c06conn\u4ece\u8fde\u63a5\u6c60\u53bb\u9664<\/span>\r\n    std<span class=\"token operator\">::<\/span>cout <span class=\"token operator\">&lt;&lt;<\/span> db_pool<span class=\"token operator\">-&gt;<\/span><span class=\"token function\">getSize<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&lt;&lt;<\/span> std<span class=\"token operator\">::<\/span>endl<span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/\u5f53\u524d\u8fde\u63a5\u6c60\u8fde\u63a5\u4e2a\u6570<\/span>\r\n<span class=\"token punctuation\">}<\/span>\r\n\r\n<\/code><\/pre>\n<\/div>\n<p>\u8fd9\u79cd\u65b9\u5f0f\u8c03\u7528\u8fde\u63a5\u6c60\u7684\u65f6\u5019\u9700\u8981\u6ce8\u610f\uff0c\u6bcf\u6b21\u4f7f\u7528\u5b8cconn\u8fde\u63a5\u540e\u9700\u8981\u624b\u52a8\u7684\u53bbrelease\u8fd9\u4e2a\u8fde\u63a5\uff0c\u4e0d\u7136\u8fde\u63a5\u6c60\u4f1a\u91cd\u590d\u7684\u5efa\u7acb\u65b0\u8fde\u63a5\uff0c\u8fbe\u4e0d\u5230\u6211\u4eec\u9700\u8981\u7684\u6548\u679c\u3002<\/p>\n<\/article>\n<div><\/div>\n<div class=\"_1kCBjS\">\n<div class=\"_18vaTa\">\n<div class=\"_3BUZPB\">\n<div class=\"_2Bo4Th\" tabindex=\"-1\" role=\"button\" aria-label=\"\u7ed9\u6587\u7ae0\u70b9\u8d5e\"><\/div>\n<p><span class=\"_1LOh_5\" tabindex=\"-1\" role=\"button\" aria-label=\"\u67e5\u770b\u70b9\u8d5e\u5217\u8868\">1\u4eba\u70b9\u8d5e<i class=\"anticon anticon-right\" aria-label=\"icon: right\"><\/i><\/span><\/div>\n<div class=\"_3BUZPB\">\n<div class=\"_2Bo4Th\" tabindex=\"-1\" role=\"button\"><\/div>\n<\/div>\n<\/div>\n<div class=\"_18vaTa\"><a class=\"_3BUZPB _1x1ok9 _1OhGeD\" href=\"https:\/\/www.jianshu.com\/nb\/8077795\" target=\"_blank\" rel=\"noopener noreferrer\"><i class=\"anticon\" aria-label=\"ic-notebook\"><\/i>\u65e5\u8bb0\u672c<\/a><\/p>\n<div class=\"_3BUZPB ant-dropdown-trigger\">\n<div class=\"_2Bo4Th\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u539f\u6587\u5730\u5740 &nbsp; \u4e00\u652f\u82c7\u8349\u5173\u6ce8 0<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[],"tags":[118],"class_list":["post-5275","post","type-post","status-publish","format-standard","hentry","tag-02-"],"_links":{"self":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/5275","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/comments?post=5275"}],"version-history":[{"count":0,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/5275\/revisions"}],"wp:attachment":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/media?parent=5275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/categories?post=5275"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/tags?post=5275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}