Test Spring's stored procedure Spring encapsulates the storage process. Its implementation details are tested below JDBC 1): Write storage procedure Execute class: package jdbc; import java.sql.types; import java.util.hashmap; import java .util.Map; import javax.sql.DataSource; import org.springframework.jdbc.core.SqlParameter; import org.springframework.jdbc.object.StoredProcedure; import org.springframework.jdbc.core.SqlOutParameter; import org.springframework. jdbc.core.SqlParameter; public class StoreTemplate extends StoredProcedure {HashMap map = new HashMap (); public StoreTemplate () {super ();} public void setValue (String key, Object obj) {map.put (key, obj); } Public storeMplate (Datasource DS) {setDataSource (DS);} 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);}} 2): Configure data sources with Spring: XML Version = "1.0" Encoding = "UTF-8"?>