1:编写简单函数:
create or replace function fun_test(p1 varchar2,p2 varchar2) return varchar2 is
Result varchar2(200);
begin
Result := p1||p2;
return(Result);
end fun_test;
2:xml
<resultMap type="java.util.HashMap" id="resultMapFun">
<result column="res" property="res" javaType="java.lang.String" jdbcType="VARCHAR"/>
</resultMap>
<!-- 定义函数 -->
<select id="callFunction" parameterType="map" statementType="CALLABLE" resultMap="resultMapFun">
{#{res,mode=OUT,jdbcType=VARCHAR}=call fun_test(#{p1,mode=IN,jdbcType=VARCHAR},#{p2,mode=IN,jdbcType=VARCHAR})}
</select>
3:dao
public String callFunction(Map<String, String> paramMap);
4:service实现类
@Override
public String callFunction(Map<String, String> paramMap) {
checkDataDao.callFunction(paramMap);
return paramMap.get("res");
}
5:controller
Map<String, String> paramMap = new HashMap<String, String>();
paramMap.put("p1", "公瑾");
paramMap.put("p2", "你好");
String result = checkDataService.callFunction(paramMap);
System.out.println("函数返回结果:"+result);
6:输出
函数返回结果:公瑾你好