Examples of org.springframework.jdbc.object.StoredProcedure.execute()

org.springframework.jdbc.object.StoredProcedure.execute()

Execute the stored procedure. Subclasses should define a strongly typed execute method (with a meaningful name) that invokes this method, populating the input map and extracting typed values from the output map. Subclass execute methods will often take domain objects as arguments and return values. Alternatively, they can return void. @param inParams map of input parameters, keyed by name as in parameterdeclarations. Output parameters need not (but can be) included in this map. It is legal for map entries to be null, and this will produce the correct behavior using a NULL argument to the stored procedure. @return map of output params, keyed by name as in parameter declarations.Output parameters will appear here, with their values after the stored procedure has been called.

  
  private Map<String,Object> executeSpNative(String spName, SqlParameter[] sqlParameters, Map<String,Object> params){
      StoredProcedure sp = new InnerStoreProcedure(spName, sqlParameters);
      sp.setDataSource(dataSource);
      sp.compile();
      return sp.execute(params);
    }
    
    public Map<String,Object> executeSP(String spName) {
        return executeSpNative(spName, null, new HashMap<String, Object>());
    }

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.