001    /**
002     * Copyright 2005-2013 The Kuali Foundation
003     *
004     * Licensed under the Educational Community License, Version 2.0 (the "License");
005     * you may not use this file except in compliance with the License.
006     * You may obtain a copy of the License at
007     *
008     * http://www.opensource.org/licenses/ecl2.php
009     *
010     * Unless required by applicable law or agreed to in writing, software
011     * distributed under the License is distributed on an "AS IS" BASIS,
012     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
013     * See the License for the specific language governing permissions and
014     * limitations under the License.
015     */
016    package org.kuali.rice.kcb.service.impl;
017    
018    import java.util.Collection;
019    
020    import javax.sql.DataSource;
021    
022    import org.kuali.rice.kcb.service.KENIntegrationService;
023    import org.springframework.beans.factory.annotation.Required;
024    import org.springframework.jdbc.core.JdbcTemplate;
025    
026    /**
027     * Implements KEN integration by querying the database tables directly.  This avoids
028     * a runtime dependence on KEN. 
029     * 
030     * @author Kuali Rice Team (rice.collab@kuali.org)
031     */
032    public class KENIntegrationServiceDirectImpl implements KENIntegrationService {
033        private DataSource datasource;
034    
035        /**
036         * Sets the DataSource to query against
037         * @param ds the DataSource to query against
038         */
039        @Required
040        public void setDataSource(DataSource ds) {
041            this.datasource = ds;
042        }
043    
044        /**
045         * @see org.kuali.rice.kcb.service.KENIntegrationService#getAllChannelNames()
046         */
047        public Collection<String> getAllChannelNames() {
048            return new JdbcTemplate(datasource).queryForList("select distinct NM from KREN_CHNL_T", String.class);
049        }
050    }