001/**
002 * Copyright 2005-2014 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 */
016package org.kuali.rice.kcb.service.impl;
017
018import java.util.Collection;
019
020import javax.sql.DataSource;
021
022import org.kuali.rice.kcb.service.KENIntegrationService;
023import org.springframework.beans.factory.annotation.Required;
024import 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 */
032public 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}