com.opencsv.ResultSetHelper Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of opencsv Show documentation
A simple library for reading and writing CSV in Java
There is a newer version: 5.9
package com.opencsv;
/**
 Copyright 2005 Bytecode Pty Ltd.

 Licensed under the Apache License, Version 2.0 (the "License");
 you may not use this file except in compliance with the License.
 You may obtain a copy of the License at

 http://www.apache.org/licenses/LICENSE-2.0

 Unless required by applicable law or agreed to in writing, software
 distributed under the License is distributed on an "AS IS" BASIS,
 WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 See the License for the specific language governing permissions and
 limitations under the License.
 */

import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * Interface for the ResultSetHelperService.  Allows the user to define their own ResultSetHelper for use
 * in the CSVWriter.
 */
public interface ResultSetHelper {
    /**
     * Returns the column Names from the ResultSet.
     *
     * @param rs - ResultSet
     * @return - string array containing the column names.
     * @throws SQLException - thrown by the ResultSet.
     */
    String[] getColumnNames(ResultSet rs) throws SQLException;

    /**
     * Returns the column values from the result set.
     * @param rs - the ResultSet containing the values.
     * @return String Array containing the values.
     * @throws SQLException - thrown by the ResultSet.
     * @throws IOException - thrown by the ResultSet.
     */
    String[] getColumnValues(ResultSet rs) throws SQLException, IOException;

    /**
     * Returns the column values from the result set with the values trimmed if desired.
     * @param rs - the ResultSet containing the values.
     * @param trim - values should have white spaces trimmed.
     * @return String Array containing the values.
     * @throws SQLException - thrown by the ResultSet.
     * @throws IOException - thrown by the ResultSet.
     */
    String[] getColumnValues(ResultSet rs, boolean trim) throws SQLException, IOException;

    /**
     * Returns the column values from the result set with the values trimmed if desired.
     * Also format the date and time columns based on the format strings passed in.
     * @param rs - the ResultSet containing the values.
     * @param trim - values should have white spaces trimmed.
     * @param dateFormatString - format String for dates.
     * @param timeFormatString - format String for timestamps.
     * @return String Array containing the values.
     * @throws SQLException - thrown by the ResultSet.
     * @throws IOException - thrown by the ResultSet.
     */
    String[] getColumnValues(ResultSet rs, boolean trim, String dateFormatString, String timeFormatString)
         throws SQLException, IOException;
}