simpleJdbcCall调用函数语法

@Bean

publicSimpleJdbcCallsaveServiceRecord(JdbcTemplatejdbcTemplate){

SimpleJdbcCalljdbcCall=newSimpleJdbcCall(jdbcTemplate).withSchemaName("CRMII")

.withFunctionName("FUNC_700212").withReturnValue(); 这样子声明，就会把函数返回值放到mapLli

jdbcCall.addDeclaredParameter(newSqlOutParameter("P_CURSOR",OracleTypes.CURSOR));

jdbcCall.addDeclaredParameter(newSqlParameter("P_YWLB",Types.BIGINT));

jdbcCall.addDeclaredParameter(newSqlParameter("P_FWLB",Types.BIGINT));

jdbcCall.addDeclaredParameter(newSqlParameter("P_FWLBXF",Types.BIGINT));

jdbcCall.addDeclaredParameter(newSqlParameter("P_ZT",Types.VARCHAR));

jdbcCall.addDeclaredParameter(newSqlParameter("P_XXNR",Types.VARCHAR));

jdbcCall.addDeclaredParameter(newSqlParameter("P_FWRY",Types.VARCHAR));

jdbcCall.addDeclaredParameter(newSqlParameter("P_KHH",Types.VARCHAR));

jdbcCall.addDeclaredParameter(newSqlParameter("P_CZLX",Types.BIGINT));

jdbcCall.addDeclaredParameter(newSqlParameter("P_WJDANR",Types.VARCHAR));

returnjdbcCall;

}

@Override

publicResponseEntityqueryQuestionOrAnswer(Longywlb,Longfwlb,Longfwlbxf,LongqueryType,Longwjtmid){

//TODOAuto-generatedmethodstub

intreturnValue=-1;

Map<String,Object>returnMap=queryQuestion.execute(ywlb,fwlb,fwlbxf,queryType,wjtmid);

if(returnMap!=null){

returnValue=(int)returnMap.get("return"); 获取函数返回值

if(returnValue==1){

returnsuccess(returnMap.get("P_CURSOR"));

}else{

returnfail("获取问题失败");

}

}

returnnull;

}

}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!