springMVC 调用存储过程

public void getProcedureForExternalCallToComplete() {
		final String procedure = "{CALL ExternalCallToComplete()}";
		getJdbcTemplate().execute(new Dispose(procedure));
	}

	public class Dispose implements ConnectionCallback {
		// 要执行的存储过程
		private String call;

		// 构造函数 接收要执行的存储过程
		public Dispose(String call) {
			this.call = call;
		}

		@SuppressWarnings("unchecked")
		public Object doInConnection(Connection conn) throws SQLException,
				DataAccessException {
			// 生成执行存储过程类
			CallableStatement cs = conn.prepareCall(call);
			// 执行存储过程
			
			/* 如何要使查询存储过程中的值存入一个集合,执行下面  */
//			ResultSet rs = cs.executeQuery();
//			// 定义容器存数据
//			List list = new ArrayList();
//			// 遍历所有数据
//			while (rs.next()) {
//				// 定义MAP 存储名称与值的集合
//				Map map = new HashMap();
//				// 把所有列名与值的集合存入MAP中
//				for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
//					map.put(rs.getMetaData().getColumnName(i), rs.getObject(i));
//				}
//				list.add(map);
//			}
//			return list;
			return null;
		}
	}

查询时在查询方法中调用getProcedureForExternalCallToComplete()方法.如下

@SuppressWarnings("unchecked")
	public List<ExternalCallToComplete> getExternalCallToComplete(int toPage,
			int pageSize, String surveyName) {
		//调用存储过程的方法
		getProcedureForExternalCallToComplete();
		String sql1 = "SELECT a,b,c,d,e,f,g,h  FROM temp2 where 1 = 1 ";
		String sql2 = " UNION ALL SELECT '合计',SUM(b),SUM(c),'',SUM(d),'',SUM(g),''  FROM  temp2  where 1 = 1 ";
		Object[] params = new Object[2];
		int index = 0;
		if (!"".equals(surveyName)) {
			sql1 += " and a = ? ";
			params[index] = surveyName;
			index++;
		}
		if (!"".equals(surveyName)) {
			sql2 += " and a = ? ";
			params[index] = surveyName;
			index++;
		}

		Object[] paramsEnd = new Object[index];
		System.arraycopy(params, 0, paramsEnd, 0, index);
		int start = MysqlPaginationUtils.getStart(toPage, pageSize);
		String sql = sql1 + sql2;
		sql = MysqlPaginationUtils.paginationSQLForMySQL(sql, start, pageSize);

		return getJdbcTemplate().query(sql, paramsEnd,
				new ExternalCallToCompleteMapper());
	}

	static class ExternalCallToCompleteMapper implements RowMapper {

		public Object mapRow(ResultSet rs, int arg1) throws SQLException {
			String surveyName = WebUtils.nullToEmpty(rs.getString(1));
			String totalSurvey = WebUtils.nullToEmpty(rs.getString(2));
			String totalSurveySuccess = WebUtils.nullToEmpty(rs.getString(3));
			String successRate = WebUtils.nullToEmpty(rs.getString(4));
			String endSurvey = WebUtils.nullToEmpty(rs.getString(5));
			String endSurveyRate = WebUtils.nullToEmpty(rs.getString(6));
			String cancelSurvey = WebUtils.nullToEmpty(rs.getString(7));
			String cancelSurveyRate = WebUtils.nullToEmpty(rs.getString(8));
			return new ExternalCallToComplete(surveyName, totalSurvey,
					totalSurveySuccess, successRate, endSurvey, endSurveyRate,
					cancelSurvey, cancelSurveyRate);
		}

	}