mysql c++ 存储过程_MySQL Connector C++ 调用存储过程 | 学步园

表 mydb.mytable

--------------------------------------------------------

|  sid(BIGINT)   |   Name(VARCHAR(50))  |

--------------------------------------------------------

【存储过程1】通过参数返回一条数据

CREATE DEFINER=`root`@`%` PROCEDURE `Query`(IN `skey` VARCHAR(50), OUT `oid` BIGINT, OUT `oname` VARCHAR(50))

LANGUAGE SQL

NOT DETERMINISTIC

CONTAINS SQL

SQL SECURITY DEFINER

COMMENT ''

BEGIN

select sid, Name into oid, oname from mydb.mytable where Name=skey limit 0,1;

END

Connector c++调用

Driver *pDriver = mysql::get_mysql_driver_instance();

try

{

auto_ptr pConnection(pDriver->connect("tcp://127.0.0.1:3306", "root", "123456"));

auto_ptrprepQuery(pConnection->prepareStatement(