转自:https://blog.csdn.net/ardo_pass/article/details/79027645
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;
- <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>
- public String callFunction(Map<String, String> paramMap);
- @Override
- public String callFunction(Map<String, String> paramMap) {
- checkDataDao.callFunction(paramMap);
- return paramMap.get("res");
- }
- Map<String, String> paramMap = new HashMap<String, String>();
- paramMap.put("p1", "公瑾");
- paramMap.put("p2", "你好");
- String result = checkDataService.callFunction(paramMap);
- System.out.println("函数返回结果:"+result);
6:输出
函数返回结果:公瑾你好