久久精品国产99国产精偷,欧美日韩中文字幕久久伊人,久久免费视频网站

MySQL Connector/C++ 調用存儲過程

MySQL Connector/C++ 調用存儲過程

（金慶的專欄）

摘自:
http://dev.mysql.com/doc/refman/5.6/en/connector-cpp-tutorials-stored-routines-statements.html

CREATE PROCEDURE test (IN country_code CHAR(3), OUT country_pop INT(11))
BEGIN
    INSERT INTO Country(Code) VALUES (country_code);

    SELECT Population INTO country_pop FROM Country WHERE Name = 'country_name';

    SELECT Code, Name, Population, Continent FROM Country WHERE Continent = "Oceania" AND Population < 10000;
    SELECT Code, Name, Population, Continent FROM Country WHERE Continent = "Europe" AND Population < 10000;
    SELECT Code, Name, Population, Continent FROM Country WHERE Continent = "North America" AND Population < 10000;
END

sql::Driver* driver = get_driver_instance();
std::auto_ptr<sql::Connection> con(driver->connect(url, user, pass));
con->setSchema(database);
std::auto_ptr<sql::Statement> stmt(con->createStatement());

stmt->execute("CALL test(\"ATL\", @pop)");

std::auto_ptr< sql::ResultSet > res;
do {
   res.reset(stmt->getResultSet());
   while (res->next()) {
      cout << "Result: " << res->getString(1) << endl;
   }
} while (stmt->getMoreResults());

std::auto_ptr<sql::ResultSet> res(stmt->executeQuery("SELECT @pop AS _reply"));
while (res->next())
   cout << "Population of Uganda: " << res->getString("_reply") << endl;

posted on 2012-04-13 10:25 金慶閱讀(1602) 評論(0) 編輯收藏引用所屬分類: 1. C/C++

只有注冊用戶登錄后才能發表評論。
【推薦】100%開源！大型工業跨平臺軟件C++源碼提供，建模，組態！

相關文章: How are dtLinks created in NavMesh C++ parameter passing rules Naming Conventions for Accessors Visual Studio 2019 Compiler Hangs Fbx File Format Identifier 查找內存錯誤 std::thread 中的異常會丟失調用棧用賦值代替 protobuf CopyFrom() vs2017 linux 編譯輸出改成 vs 格式為 LiteIDE 添加選中標記

網站導航: 博客園 IT新聞 BlogJava 博問 Chat2DB 管理

金慶的專欄

公告

留言簿(12)

隨筆分類(502)

隨筆檔案(423)

相冊

搜索

積分與排名

最新評論

閱讀排行榜

評論排行榜