java调用存储过程

java调用存储过程

代码

@Override
	public String updataIndcat(IndexQuery indexQuery) {
		//活动Id
		String pEvalId = indexQuery.getEVAL_ID();
		String pYearMonth = getYearMonth();
		
		String storedProc = "{ ? = call get_eval_pro.update_epm_eval_indcat(?,?) }";
		String execute = jt.execute(storedProc, new CallableStatementCallback<String>() {
			@Override
			public String doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException {
				int index = 1;
				cs.registerOutParameter(index++, Types.VARCHAR);
				cs.setString(index++, pEvalId);
				cs.setString(index++, pYearMonth);
				cs.execute();
				String ret = cs.getString(1);
				return ret;
			}
		});
		return execute;
	}