Mybatis調用mysql預存程序,mybatismysql

來源:互聯網
上載者:User

Mybatis調用mysql預存程序,mybatismysql
建立預存程序:

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    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裡面調用:
<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,傳入參數,out,傳出參數。

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.