001    package org.apache.ojb.broker.accesslayer.sql;
002    
003    /* Copyright 2002-2005 The Apache Software Foundation
004     *
005     * Licensed under the Apache License, Version 2.0 (the "License");
006     * you may not use this file except in compliance with the License.
007     * You may obtain a copy of the License at
008     *
009     *     http://www.apache.org/licenses/LICENSE-2.0
010     *
011     * Unless required by applicable law or agreed to in writing, software
012     * distributed under the License is distributed on an "AS IS" BASIS,
013     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
014     * See the License for the specific language governing permissions and
015     * limitations under the License.
016     */
017    
018    import org.apache.ojb.broker.util.logging.Logger;
019    
020    /**
021     * Model a SELECT Statement for M:N indirection table
022     *
023     * @author <a href="mailto:jbraeuchi@hotmail.com">Jakob Braeuchi</a>
024     * @version $Id: SqlSelectMNStatement.java,v 1.1 2007-08-24 22:17:39 ewestfal Exp $
025     */
026    public class SqlSelectMNStatement extends SqlMNStatement
027    {
028        private String[] m_selectColumns;
029    
030        /**
031         * Constructor for SqlSelectMNStatement.
032         * @param table
033         * @param columns
034         */
035        public SqlSelectMNStatement(String table, String[] selectColumns, String[] columns, Logger logger)
036        {
037            super(table, columns, logger);
038            m_selectColumns = selectColumns;
039        }
040    
041        /**
042         * @see org.apache.ojb.broker.accesslayer.sql.SqlStatement#getStatement()
043         */
044        public String getStatement()
045        {
046            StringBuffer stmt = new StringBuffer(1024);
047    
048            stmt.append("SELECT ");
049            appendListOfColumns(m_selectColumns,stmt);
050            stmt.append(" FROM ");
051            appendTable(getTable(), stmt);
052            appendWhereClause(stmt, getColumns());
053    
054            return stmt.toString();
055        }
056    }