springboot调用存储过程

1.创建Mapper接口类

public interface TCustomerOrgTempMapper {

/**

* 存储过程更新

*

* @param map

* @return

*/

Map<String,String> callProceUpdate(Map<String, String> map);

}

 

2.mybatis sql文件

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >

<mapper namespace="cn.caitc.ecif.custinfo.dao.TCustomerOrgTempMapper" >

<select id="callProceUpdate" parameterType="java.util.HashMap"

statementType="CALLABLE" resultType="java.util.HashMap">

<![CDATA[

{call P_E_UPDATE_CUST_INFO_U(

#{custNo,mode=IN,jdbcType=VARCHAR},

#{id,mode=IN,jdbcType=VARCHAR},

#{status,mode=OUT,jdbcType=VARCHAR}

)}

]]>

</select>

</mapper>

3.调存储过程，存储过程返回的值在传入