mybatis调用存储过程

xml：

<parameterMap type="java.util.Map" id="seqNameParams"> <parameter property="v_seq_name" mode="IN" jdbcType="INTEGER"/> <parameter property="o_retsult" mode="OUT" jdbcType="INTEGER"/> </parameterMap> <select id="getNextIdByProcedure" parameterMap="seqNameParams" statementType="CALLABLE"> {CALL p_nextval(?, ?)} </select>

 

 

java：

 

 

 

public Long getNextIdByProcedure(String seq) { try { HashMap<String, Object> paramMap = new HashMap<String, Object>(); paramMap.put("v_seq_name", seq); paramMap.put("o_retsult", "-2"); this.getSqlMapClientTemplate().update("getNextIdByProcedure", paramMap); return ToolUtil.getNotNullLong(paramMap.get("o_retsult")); } catch (Exception e) { e.printStackTrace(); } return -1l; }

mapper：

 

 

public void getNextIdByProcedure(HashMap<String, Object> paramMap);