?StoredProcedure是一個(gè)抽象類，必須寫一個(gè)子類來(lái)繼承它，這個(gè)類是用來(lái)簡(jiǎn)化JDBCTemplate運(yùn)行存儲(chǔ)過程操作的。

首先我們寫一個(gè)實(shí)現(xiàn)類：

      package com.huaye.framework.dao;



import java.sql.Types;

import java.util.HashMap;

import java.util.Map;



import org.springframework.jdbc.core.RowMapper;

import org.springframework.jdbc.core.SqlOutParameter;

import org.springframework.jdbc.core.SqlParameter;

import org.springframework.jdbc.core.SqlReturnResultSet;

import org.springframework.jdbc.object.StoredProcedure;



/**

 * Name:StoredProcedureTemplate User: HP Date: 2007-7-21 Time: 7:40:01

 * Description:

 */

public class StoredProcedureTemplate extends StoredProcedure {



	private HashMap<String, Object> map = new HashMap<String, Object>();



	public StoredProcedureTemplate() {

		super();



	}



	

	public HashMap getMap()

	{

		return this.map;

	}

	

	public void setValue(String key, Object obj) {

		map.put(key, obj);

	}



	public Map execute() {

		if (this.getSql() == null || this.getSql().equals(""))

			return null;

		this.compile();

		return execute(map);

	}



	public void setVarcharParam(String param) {

		this.declareParameter(new SqlParameter(param, Types.VARCHAR));

	}



	public void setDoubleParam(String param) {

		this.declareParameter(new SqlParameter(param, Types.DOUBLE));

	}



	public void setIntegerParam(String param) {

		this.declareParameter(new SqlParameter(param, Types.INTEGER));

	}



	public void setVarcharOutParam(String param) {

		this.declareParameter(new SqlOutParameter(param, Types.VARCHAR));

	}



	public void setDoubleOutParam(String param) {

		this.declareParameter(new SqlOutParameter(param, Types.DOUBLE));

	}



	public void setIntegerOutParam(String param) {

		this.declareParameter(new SqlOutParameter(param, Types.INTEGER));

	}





	public void setInParam(String param,int valueType)

	{

		this.declareParameter(new SqlParameter(param, valueType));

		

	}

	

	public void setOutParam(String param,int valueType)

	{

		this.declareParameter(new SqlOutParameter(param, valueType));

		

	}

	

	public void setReturnParam(String param, RowMapper rowMapper) {

		this.declareParameter(new SqlReturnResultSet(param,rowMapper));

	}



}


    

寫一個(gè)測(cè)試：

      public void test2() {

		ApplicationContext context = new ClassPathXmlApplicationContext(

				"classpath:spring/applicationContext-base.xml");

		JdbcTemplate jdbc = (JdbcTemplate) context.getBean("jdbcTemplate");



		StoredProcedureTemplate template = new StoredProcedureTemplate();

		

		template.setJdbcTemplate(jdbc);

		template.setSql("testproc");

		//注意有返回結(jié)果集的時(shí)候，第一個(gè)參數(shù)必須設(shè)置為返回結(jié)果集參數(shù)，不然會(huì)報(bào)錯(cuò)。

		template.setReturnParam("rows", new FirstReportRowMapper());

		

		template.setIntegerParam("@parama");

		

		template.setValue("@parama", 9);

		

		Map map = template.execute();

		Object o = map.get("rows");

		List<FirstReportVO> list = (List<FirstReportVO>)o;

		for (FirstReportVO vo : list) {

			System.out.println(vo.getSortID()+","+vo.getSortName());

		}

	}
    

唯一要注意的地方就是測(cè)試?yán)飩渥⒌牡胤剑覝y(cè)試了好久才發(fā)現(xiàn)，郁悶的一塌糊涂，老是莫名其妙的錯(cuò)，原來(lái)將參數(shù)互換一下位置就OK了，比方你把

template.setIntegerParam("@parama");寫在前面然后再寫template.setReturnParam("rows", new FirstReportRowMapper());的話，就會(huì)報(bào)空指針錯(cuò)誤。

這個(gè)“rows”能夠隨便取名字，只是以下map.get("rows")要和你取的名字一致，由于StoredProcedureTemplate會(huì)將結(jié)果集以這個(gè)名字保存在map中返回。

還有要注意的就是設(shè)置sqlparamter的順序要和存儲(chǔ)過程中參數(shù)的順序要一致，不然也會(huì)報(bào)錯(cuò).