mybatis调用存储过程及返回值获取

mybatis调用存储过程及返回值获取

存储过程的返回结果直接放在 传入参数的map中（paramCusKey）

调用前{INPARA=CUSTOMER_KEY=545}

调用后

{OUTPARA=CUS_USER_ID=E00000049_02, INPARA=CUSTOMER_KEY=545}

 //类似用mybatis内置的插入方法自动返回主键一样,(之前有set主键的话就不返回插入后的值了，直接是set值，)返回存储过程输出参数

 <select id="getCusKey" parameterType="map" statementType="CALLABLE" resultType="string">

  

  <![CDATA[  

    {call PD_OPT_ID(#{INPARA,mode=IN,jdbcType=VARCHAR},#{OUTPARA,mode=OUT,jdbcType=VARCHAR})}  //这里是存储过程接收返回结果的写入map中的字段

  ]]>  

  

  </select>

 

 

public String getCusKey(Map<String,Object> param);

 

 

  

 

 

  Map<String,Object> paramCusKey = new HashMap<String,Object>();

paramCusKey.put("INPARA", "CUSTOMER_KEY="+tbCusUserBeanVo.getCustomerKey());

tbCusUserDao.getCusKey(paramCusKey);

String out=paramCusKey.get("OUTPARA").toString().substring(paramCusKey.get("OUTPARA").toString().indexOf("=")+1, paramCusKey.get("OUTPARA").toString().length());//获取结果,注意只是当前调用存储过程的dao层可以获取，到了serveice不可--map没传递出去

System.out.println(out);

System.out.println(paramCusKey.get("OUTPARA").toString());

 

 

 

===================================

//mybatis调用存储过程的另一xml写法

<parameterMap type="java.util.Map" id="recommendMap">

         <parameter property="inpara" mode="IN" jdbcType="VARCHAR"/>

         <parameter property="outpara" mode="OUT" jdbcType="VARCHAR"/>

     </parameterMap>

     

<select id="recommend" parameterMap="recommendMap" statementType="CALLABLE">

 

<![CDATA[

           call PD_CON_OBJ_RECOMMEND(?,?)    

       ]]>

 

</select>

 

 

@Override

public String recommend(String conobjKey) {

  StringBuffer inparasb = new StringBuffer("");

      inparasb.append("CONOBJ_KEY=");

      inparasb.append(conobjKey);

      inparasb.append('\r');

      inparasb.append('\n');

      inparasb.append("RECOMMEND_NAME=");

      inparasb.append("");

      String inpara = inparasb.toString();

      Map<String,String> map = new HashMap<String,String>();

      map.put("inpara", inpara);

      tbConObjMapper.recommend(map);

      return map.get("outpara");

}

 

public String recommend(Map<String,String> map);