1.MYBATIS方法:
<select id="getFlowNum" statementType="CALLABLE">
<![CDATA[
{call PRO_CFC_GETFLOWNUM(
#{V_IN_RANDOM,mode=IN,jdbcType=VARCHAR},
#{V_IN_BUSCODE,mode=IN,jdbcType=VARCHAR},
#{V_IN_REFRESHVAR,mode=IN,jdbcType=VARCHAR},
#{V_O_FLOWNUM,mode=OUT,jdbcType=INTEGER}
)}
]]>
</select>
2.MAPPER方法:
public interface TbcommonflownumMapper {
Integer getFlowNum(Map<String, Object> map);
}
3.SERVICE方法:
public Integer getFlowNum(String busCode, String refreshvar) {
synchronized (this) {
if(curnum!=null)curnum=null;
Map<String,Object> map = new HashMap<String, Object>();
map.put("V_IN_RANDOM", UUID.randomUUID().toString());//入参1 map的k值要和mybatis的变量名一致.
map.put("V_IN_BUSCODE", busCode); //入参2
map.put("V_IN_REFRESHVAR", refreshvar); //入参3
TbcommonflownumMapper.getFlowNum(map);
Object _curnum=map.get("V_O_FLOWNUM"); //过程出参值写在map里面.
if(_curnum==null)return null;
curnum=Integer.parseInt(_curnum.toString());
return curnum;
}
}