@Bean
public SimpleJdbcCall saveServiceRecord(JdbcTemplate jdbcTemplate) {
SimpleJdbcCall jdbcCall = new SimpleJdbcCall(jdbcTemplate).withSchemaName("CRMII")
.withFunctionName("FUNC_700212").withReturnValue(); 这样子声明,就会把函数返回值放到mapLli
jdbcCall.addDeclaredParameter(new SqlOutParameter("P_CURSOR", OracleTypes.CURSOR));
jdbcCall.addDeclaredParameter(new SqlParameter("P_YWLB", Types.BIGINT));
jdbcCall.addDeclaredParameter(new SqlParameter("P_FWLB", Types.BIGINT));
jdbcCall.addDeclaredParameter(new SqlParameter("P_FWLBXF", Types.BIGINT));
jdbcCall.addDeclaredParameter(new SqlParameter("P_ZT", Types.VARCHAR));
jdbcCall.addDeclaredParameter(new SqlParameter("P_XXNR", Types.VARCHAR));
jdbcCall.addDeclaredParameter(new SqlParameter("P_FWRY", Types.VARCHAR));
jdbcCall.addDeclaredParameter(new SqlParameter("P_KHH", Types.VARCHAR));
jdbcCall.addDeclaredParameter(new SqlParameter("P_CZLX", Types.BIGINT));
jdbcCall.addDeclaredParameter(new SqlParameter("P_WJDANR", Types.VARCHAR));
return jdbcCall;
}
@Override
public ResponseEntity queryQuestionOrAnswer(Long ywlb, Long fwlb, Long fwlbxf, Long queryType, Long wjtmid) {
// TODO Auto-generated method stub
int returnValue = -1;
Map<String, Object> returnMap = queryQuestion.execute(ywlb, fwlb, fwlbxf, queryType, wjtmid);
if (returnMap != null) {
returnValue = (int) returnMap.get("return"); 获取函数返回值
if (returnValue == 1) {
return success(returnMap.get("P_CURSOR"));
} else {
return fail("获取问题失败");
}
}
return null;
}
}