MyBatis calling the MySQL stored procedure

To establish a stored procedure:

DELIMITER $ $USE ' test ' $ $DROP PROCEDURE IF EXISTS ' user_user_selectuserbyproandcity_sp ' $ $CREATE definer= ' demao ' @ '% ' PROCEDURE ' user_user_selectuserbyproandcity_sp ' (in Provinceid int,in cityid int,in pageIndex int,in pageSize INT) begin< C0/>declare proid INT DEFAULT 0;    DECLARE ciid INT DEFAULT 0;        SELECT *, (select  COUNT (*) from user_user_t whereprovince_id like CONCAT ('% ', Provinceid, '% ') and  city_id like CONCAT ('% ', Cityid, '% ')) as Usercountfrom user_user_twhere province_id like CONCAT ('% ', Provinceid, '% ') and city_id like CONCAT ('% ', Cityid, '% ') LIMIT pageindex,pagesize;    end$$

Mapper Inside Call:

<select id= "selectuserbyprovinceandcity" resultmap= "Baseresultmap" statementtype= "CALLABLE" >{CALL user_user_ SELECTUSERBYPROANDCITY_SP (#{provinceid,mode=in,jdbctype=integer},#{cityid,mode=in,jdbctype=integer},#{ Pageindex,mode=in,jdbctype=integer},#{pagesize,mode=in,jdbctype=integer})}</select>

in, incoming parameters, out, outgoing parameters.

MyBatis calling the MySQL stored procedure