\u4eca\u5929\u5904\u7406\u4e86\u4e00\u4e0b\u914d\u7f6e\u6587\u4ef6\u7684\u95ee\u9898\uff0c\u6bd5\u7adf\u4e0d\u80fd\u5565\u90fd\u5f80\u7a0b\u5e8f\u91cc\u5199\u5bf9\u5427\u2026\u2026\u5176\u5b9e\u6211\u4ee5\u524d\u4e00\u76f4\u662f\u8bb0\u597d\u4e86\u7b2c\u51e0\u884c\u662f\u5565\uff0c\u7136\u540e\u76f4\u63a5\u8bfb\u8fdb\u6765\u3002\u4e0d\u8fc7\u8fd9\u6837\u663e\u7136\u4e0d\u592a\u4f18\u96c5\uff0c\u6240\u4ee5\u8981\u7528\u70b9\u5565\u683c\u5f0f\u3002\u672c\u6765\u662f\u60f3\u7528GKeyFile\u6765\u5904\u7406\u7684\uff0c\u7136\u540e\u5b83\u8981include\u4e00\u4e2aglib.h\u7684\u5934\u6587\u4ef6\uff0c\u5927\u8725\u8734\u91cc\u9762\u8fd9\u4e2a\u6587\u4ef6\u6709\u70b9\u95ee\u9898\uff0c\u8def\u5f84\u5404\u79cd\u4e0d\u5bf9\u3002JSON\u5427\uff0c\u6309\u8bf4\u4e0d\u9519\uff0c\u4f46\u662f\u624b\u5199\u7684\u8bdd\u683c\u5f0f\u4e0d\u662f\u90a3\u4e48\u53cb\u597d\uff0cXML\u5c31\u66f4\u522b\u63d0\u4e86\u3002\u52a0\u4e0a\u4e4b\u524d\u88ab\u5b89\u5229\u8fc7\u4e00\u6ce2YAML\uff0c\u5c31\u51b3\u5b9a\u7528\u5b83\u4e86\u3002<\/p>\n
YAML\uff0c\u8bf4\u6765\u4e5f\u7b80\u5355\uff0c\u76f4\u63a5\u5b89\u88c5yaml-cpp-devel\u5c31\u53ef\u4ee5\u4e86\uff0c\u5c01\u88c5\u7684\u5f88\u597d\uff0c\u5f88\u65b9\u4fbf\u3002\u6ca1\u7528\u4ec0\u4e48\u9ad8\u7ea7\u7684\u914d\u7f6e\uff0c\u770b\u7740\u4ee3\u7801\u81ea\u5df1\u609f\u5427\uff08\u6ed1\u7a3d<\/p>\n
\u55ef\u2026\u2026\u8bdd\u8bf4\u6628\u5929\u4e0d\u5c0f\u5fc3\u66b4\u9732\u4e86\u6211\u7684\u6570\u636e\u5e93\u5bc6\u7801\uff0c\u5e94\u8be5\u6ca1\u5173\u7cfb\u5427\uff1f<\/p>\n
<\/p>\n
Database Info:\n Host: ali.himmel.tech\n Username: jxsong\n Password: nicopoiduang\n<\/pre>\n<\/p>\n
#include <yaml-cpp\/yaml.h>\n#include <mysql_connection.h>\n#include <mysql_driver.h>\n#include <cppconn\/statement.h>\nusing namespace sql;\nusing namespace std;\n\nint main(int argc, char **argv)\n{\n YAML::Node config = YAML::LoadFile(\"config.yaml\");\n config = config[\"Server Info\"];\n string host = config[\"Host\"].as<std::string>();\n string username = config[\"Username\"].as<std::string>();\n string password = config[\"Password\"].as<string>();\n mysql::MySQL_Driver *driver;\n Connection *con;\n Statement *state;\n ResultSet *result;\n \/\/ \u521d\u59cb\u5316\u9a71\u52a8\n driver = sql::mysql::get_mysql_driver_instance();\n \/\/ \u5efa\u7acb\u94fe\u63a5\n con = driver->connect(host, username, password);\n state = con->createStatement();\n state->execute(\"use test\");\n state -> execute(\"INSERT INTO Books (Name, ISBN, Price, Count) VALUES ('\u81ea\u52a8\u6253Call\u539f\u7406' , 80211, 199.8, 2999)\");\n \/\/ \u67e5\u8be2\n result = state->executeQuery(\"select * from Books\");\n \/\/ \u8f93\u51fa\u67e5\u8be2\n while(result->next())\n {\n cout << result -> getString(\"Name\") << \" : $\" << result -> getDouble(\"Price\") << endl;\n }\n state -> execute(\"DELETE FROM Books WHERE Name = '\u81ea\u52a8\u6253Call\u539f\u7406'\");\n delete state;\n delete con;\n\n return 0;\n}<\/pre>\n<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4eca\u5929\u5904\u7406\u4e86\u4e00\u4e0b\u914d\u7f6e\u6587\u4ef6\u7684\u95ee\u9898\uff0c\u6bd5\u7adf\u4e0d\u80fd\u5565\u90fd\u5f80\u7a0b\u5e8f\u91cc\u5199\u5bf9\u5427\u2026\u2026\u5176\u5b9e\u6211\u4ee5\u524d\u4e00\u76f4\u662f\u8bb0\u597d\u4e86\u7b2c\u51e0\u884c\u662f\u5565\uff0c\u7136\u540e\u76f4\u63a5\u8bfb\u8fdb\u6765\u3002 … <\/p>\n