org.inbio.ait.dao.conn.impl.PlicDataAccessDAOImpl.java Source code

Introduction

Here is the source code for org.inbio.ait.dao.conn.impl.PlicDataAccessDAOImpl.java

Source

/* AIT - Analysis of taxonomic indicators
 *
 * Copyright (C) 2010  INBio (Instituto Nacional de Biodiversidad)
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */

package org.inbio.ait.dao.conn.impl;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import org.inbio.ait.dao.conn.PlicDataAccessDAO;
import org.inbio.ait.model.PlicPropertyHolder;
import org.inbio.ait.util.AitDataSource;
import org.springframework.jdbc.core.JdbcTemplate;

/**
 *
 * @author esmata
 */
public class PlicDataAccessDAOImpl implements PlicDataAccessDAO {

    private JdbcTemplate jdbcTemplate;

    /**
     * Method to get a list of all fields from the mapped plic table
     * through jdbc conection
     */
    @Override
    public List<String> getPlicTableFields(PlicPropertyHolder ph) {
        List<String> result = new ArrayList<String>();
        result.add("unmapped"); //Default value
        try {
            //Stting up the jdbcTemplate
            this.accessToDB(ph);
            //getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
            ResultSet cols = this.jdbcTemplate.getDataSource().getConnection().getMetaData().getColumns(null, null,
                    ph.getTablename(), null);
            while (cols.next()) {
                result.add(cols.getString("COLUMN_NAME"));
            }
            return result;
        } catch (Exception e) {
            System.out.println(e);
            return null;
        }
    }

    /**
     * Method to get a total count of plic registers
     */
    @Override
    public int countAll(PlicPropertyHolder ph) {
        int result = -1;
        try {
            //Stting up the jdbcTemplate
            this.accessToDB(ph);
            return this.jdbcTemplate.queryForInt("Select count(*) from " + ph.getTablename());
        } catch (Exception e) {
            System.out.println(e);
            return result;
        }
    }

    //Getting the access to the data base
    private void accessToDB(PlicPropertyHolder ph) {
        //Getting the data source connection
        AitDataSource ds = new AitDataSource(ph.getDriverClassName(), ph.getUrl(), ph.getUsername(),
                ph.getPassword());
        this.jdbcTemplate = new JdbcTemplate(ds);
    }

}