java 调用存储过程

package com.wondersgroup.qyws.sjzk.util;

import java.sql.Types;
import java.util.Map;

import javax.sql.DataSource;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.SqlOutParameter;
import org.springframework.jdbc.core.SqlParameter;
import org.springframework.jdbc.object.StoredProcedure;

public class StoredProcedureUtil extends StoredProcedure {
	
	private final String Result = "Resulst"; //返回参数名

	/**
	 * 调用存储过程
	 * @param procName    存储过程名
	 * @param inParamName 输入参数名数组
	 * @param inParameter 输入参数值map
	 * @return String     执行状态值
	 * @throws Exception
	 */
	public String invokeProcedure(String procName, String[] inParamName,
			Map inParameter) {
		
		ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext-common.xml");  
		DataSource ds = (DataSource)ctx.getBean("dataSource");  
		
		setDataSource(ds);
		setSql(procName);
                //false:调过程；true:调函数
		setFunction(false);
		
		this.declareParameter(new SqlOutParameter(Result, Types.INTEGER));
		for (int i = 0; i < inParamName.length; i++) {
			declareParameter(new SqlParameter(inParamName[i], Types.INTEGER));
		}

		compile();
		
		Map out = execute(inParameter);
		
		Object result = null;
		if (out != null && out.containsKey(Result)) {
			result = out.get(Result);
		}

		return ((Integer) result) + "";
	}

}