IBATIS调用存储过程

最新推荐文章于 2021-02-23 17:29:46 发布

luweifeng1983

最新推荐文章于 2021-02-23 17:29:46 发布

阅读量73

点赞数

分类专栏： Ibatis 文章标签： java

本文链接：https://blog.csdn.net/luweifeng1983/article/details/84115715

版权

Ibatis 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

http://www.iteye.com/topic/84224

<parameterMap class="map" id="swapParameters">   
    <parameter property="namestr"  javaType="java.lang.String" jdbcType="varchar" mode="IN"/>   
    <parameter property="returnid"  javaType="java.lang.Integer" jdbcType="int" mode="OUT"/>   
</parameterMap>   
<procedure id="insertNameByProcedure" parameterMap="swapParameters">   
    {call UP_GETINSERTEDIDENTITY_TT(?,?)}    
</procedure>

CREATE PROCEDURE `UP_GETINSERTEDIDENTITY_TT`(inname VARCHAR(20), OUT returnid INTEGER(11))    
    NOT DETERMINISTIC    
    SQL SECURITY INVOKER    
    COMMENT ''   
BEGIN   
     insert into `tt`(NAME) values(inname);    
     select LAST_INSERT_ID() into returnid ;    
END;

Integer returnid = null;    
HashMap<String,Object> paramMap = new HashMap<String,Object>();    
paramMap.put("namestr", insertname);    
paramMap.put("returnid", returnid);    
this.getSqlMapClientTemplate().queryForObject("insertNameByProcedure", paramMap);    
return (Integer)paramMap.get("returnid");