表
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->prepareStatemen