JAVA调用ORACLE存储过程助手类实现

package com.gemship.common.service.impl;

import java.lang.reflect.Method;
import java.math.BigDecimal;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Types;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

import oracle.jdbc.OracleTypes;

import org.apache.commons.beanutils.converters.BooleanConverter;
import org.apache.commons.lang.time.DateUtils;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.jdbc.core.RowMapper;

import com.gemship.common.DateUtil;
import com.gemship.common.service.HelperService;
import com.gemship.commondata.util.ProcedureUtil;
import com.gemship.ecm.entity.RemindDaysSet;

import com.gemship.ecm.service.RemindDaysSetService;
import com.gfa4j.exception.ValidateRuntimeException;
import com.gfa4j.hibernate.BaseObject;
import com.gfa4j.query.StoredQueryInfo;
import com.gfa4j.service.impl.BaseServiceImpl;
import com.gfa4j.util.StringUtils;

public class HelperServiceImpl extends BaseServiceImpl implements HelperService {

private RemindDaysSetService remindDaysSetService;

public Map queryProcedure(List list, String strStoredProcedureName, int[] cursorIndexes, 
Map<Integer, Integer> cursorTypes) {
StoredQueryInfo queryInfo = new StoredQueryInfo(strStoredProcedureName);
int size = list.size() + cursorIndexes.length;
int[] paramTypes = new int[size];
String[] paramNames = new String[size];
Object[] paramValues = new Object[size];
RowMapper[] dataExtracters = new RowMapper[size];
for (int i=0,j=0,k=0; i<size; i++) {
if(j < cursorIndexes.length && i == cursorIndexes[j]) {
//该参数为输出
Integer cursorType = cursorTypes.get(list.size()+j);
paramTypes[i] = cursorType == null ? OracleTypes.CURSOR : cursorType;
paramNames[i] = createCursorName(j);
paramValues[i] = null;
dataExtracters[i] = new RowMapper(){
@SuppressWarnings("unchecked")
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
Map resultData = new HashMap();