001 /*
002 * JBoss DNA (http://www.jboss.org/dna)
003 * See the COPYRIGHT.txt file distributed with this work for information
004 * regarding copyright ownership. Some portions may be licensed
005 * to Red Hat, Inc. under one or more contributor license agreements.
006 * See the AUTHORS.txt file in the distribution for a full listing of
007 * individual contributors.
008 *
009 * JBoss DNA is free software. Unless otherwise indicated, all code in JBoss DNA
010 * is licensed to you under the terms of the GNU Lesser General Public License as
011 * published by the Free Software Foundation; either version 2.1 of
012 * the License, or (at your option) any later version.
013 *
014 * JBoss DNA is distributed in the hope that it will be useful,
015 * but WITHOUT ANY WARRANTY; without even the implied warranty of
016 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
017 * Lesser General Public License for more details.
018 *
019 * You should have received a copy of the GNU Lesser General Public
020 * License along with this software; if not, write to the Free
021 * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
022 * 02110-1301 USA, or see the FSF site: http://www.fsf.org.
023 */
024 package org.jboss.dna.common.jdbc.model.spi;
025
026 import java.util.Set;
027 import java.util.HashSet;
028 import org.jboss.dna.common.jdbc.model.api.Parameter;
029 import org.jboss.dna.common.jdbc.model.api.StoredProcedure;
030 import org.jboss.dna.common.jdbc.model.api.StoredProcedureResultType;
031
032 /**
033 * Provides all core database SPe specific metadata.
034 *
035 * @author <a href="mailto:litsenko_sergey@yahoo.com">Sergiy Litsenko</a>
036 */
037 public class StoredProcedureBean extends SchemaObjectBean implements StoredProcedure {
038 private static final long serialVersionUID = 8530431073036932292L;
039 private Set<Parameter> columns = new HashSet<Parameter>();
040 private StoredProcedureResultType resultType;
041
042 /**
043 * Default constructor
044 */
045 public StoredProcedureBean() {
046 }
047
048 /**
049 * Gets stored procedure result type
050 *
051 * @return stored procedure result type
052 */
053 public StoredProcedureResultType getResultType() {
054 return resultType;
055 }
056
057 /**
058 * Sets stored procedure result type
059 *
060 * @param resultType the stored procedure result type
061 */
062 public void setResultType( StoredProcedureResultType resultType ) {
063 this.resultType = resultType;
064 }
065
066 /**
067 * Gets stored procedure columns
068 *
069 * @return a set of stored procedure columns.
070 */
071 public Set<Parameter> getParameters() {
072 return columns;
073 }
074
075 /**
076 * Adds Parameter
077 *
078 * @param parameter the Parameter
079 */
080 public void addParameter( Parameter parameter ) {
081 columns.add(parameter);
082 }
083
084 /**
085 * deletes Parameter
086 *
087 * @param parameter the Parameter
088 */
089 public void deleteParameter( Parameter parameter ) {
090 columns.remove(parameter);
091 }
092
093 /**
094 * Returns stored procedure parameter for specified name or null
095 *
096 * @param parameterName the name of parameter
097 * @return stored procedure parameter for specified name or null.
098 */
099 public Parameter findParameterByName( String parameterName ) {
100 for (Parameter p : columns) {
101 if (p.getName().equals(parameterName)) {
102 return p;
103 }
104 }
105 // return nothing
106 return null;
107 }
108
109 }