com.ricebridge.csvman
Class CsvResultSetMetaData

java.lang.Object
  com.ricebridge.csvman.CsvResultSetMetaData

All Implemented Interfaces:

ResultSetMetaData

public class CsvResultSetMetaData

extends Object

implements ResultSetMetaData

Implementation of ResultSetMetaData to present CSV header data.

This ResultSetMetaData implementation provides much the same interface as a normal ResultSetMetaData. It simply provides the headers of the CSV file via getColumnName(int). Apart from methods relating to column names, all other methods return default values which assume that all data is in the form of Strings.

The Source Code of this Java class is available under a BSD-style license.

Field Summary

protected int	iColumnCount Number of columns of data.
protected HashMap	iColumnMap Map from column name to index.
protected String[]	iColumnName Column names

Fields inherited from interface java.sql.ResultSetMetaData

columnNoNulls, columnNullable, columnNullableUnknown

Constructor Summary

CsvResultSetMetaData(String[] pHeaders)
Initialised with a List of String[] containing column headers.

Method Summary

int	findColumn(String pColumnName) Find the index (starting at one, not zero) of a named column.
String	getCatalogName(int pColumn) No action — see ResultSetMetaData.getCatalogName(int).
String	getColumnClassName(int pColumn) No action — see ResultSetMetaData.getColumnClassName(int).
int	getColumnCount() Get the number of columns.
int	getColumnDisplaySize(int pColumn) No action — see ResultSetMetaData.getColumnDisplaySize(int).
String	getColumnLabel(int pColumn) Get the name of a column.
String	getColumnName(int pColumn) Get the name of a column.
int	getColumnType(int pColumn) No action — see ResultSetMetaData.getColumnType(int).
String	getColumnTypeName(int pColumn) No action — see ResultSetMetaData.getColumnTypeName(int).
int	getPrecision(int pColumn) No action — see ResultSetMetaData.getPrecision(int).
int	getScale(int pColumn) No action — see ResultSetMetaData.getScale(int).
String	getSchemaName(int pColumn) No action — see ResultSetMetaData.getSchemaName(int).
String	getTableName(int pColumn) No action — see ResultSetMetaData.getTableName(int).
boolean	isAutoIncrement(int pColumn) No action — see ResultSetMetaData.isAutoIncrement(int).
boolean	isCaseSensitive(int pColumn) No action — see ResultSetMetaData.isCaseSensitive(int).
boolean	isCurrency(int pColumn) No action — see ResultSetMetaData.isCurrency(int).
boolean	isDefinitelyWritable(int pColumn) No action — see ResultSetMetaData.isDefinitelyWritable(int).
int	isNullable(int pColumn) No action — see ResultSetMetaData.isNullable(int).
boolean	isReadOnly(int pColumn) No action — see ResultSetMetaData.isReadOnly(int).
boolean	isSearchable(int pColumn) No action — see ResultSetMetaData.isSearchable(int).
boolean	isSigned(int pColumn) No action — see ResultSetMetaData.isSigned(int).
boolean	isWritable(int pColumn) No action — see ResultSetMetaData.isWritable(int).

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

iColumnCount

protected int iColumnCount

Number of columns of data.

iColumnName

protected String[] iColumnName

Column names

iColumnMap

protected HashMap iColumnMap

Map from column name to index.

Constructor Detail

CsvResultSetMetaData

public CsvResultSetMetaData(String[] pHeaders)

Initialised with a List of String[] containing column headers.

Parameters:

pHeaders - header names

Method Detail

findColumn

public int findColumn(String pColumnName)

Find the index (starting at one, not zero) of a named column.

Parameters:

pColumnName - name of column

getColumnCount

public int getColumnCount()
                   throws SQLException

Get the number of columns.

Specified by:

getColumnCount in interface ResultSetMetaData

Throws:

SQLException

getColumnLabel

public String getColumnLabel(int pColumn)
                      throws SQLException

Get the name of a column.

Specified by:

getColumnLabel in interface ResultSetMetaData

Parameters:

pColumn - index of column (from one, not zero)

Throws:

SQLException

getColumnName

public String getColumnName(int pColumn)
                     throws SQLException

Get the name of a column.

Specified by:

getColumnName in interface ResultSetMetaData

Parameters:

pColumn - index of column (from one, not zero)

Throws:

SQLException

isAutoIncrement

public boolean isAutoIncrement(int pColumn)
                        throws SQLException

No action — see ResultSetMetaData.isAutoIncrement(int).

Specified by:

isAutoIncrement in interface ResultSetMetaData

Throws:

SQLException

isCaseSensitive

public boolean isCaseSensitive(int pColumn)
                        throws SQLException

No action — see ResultSetMetaData.isCaseSensitive(int).

Specified by:

isCaseSensitive in interface ResultSetMetaData

Throws:

SQLException

isSearchable

public boolean isSearchable(int pColumn)
                     throws SQLException

No action — see ResultSetMetaData.isSearchable(int).

Specified by:

isSearchable in interface ResultSetMetaData

Throws:

SQLException

isCurrency

public boolean isCurrency(int pColumn)
                   throws SQLException

No action — see ResultSetMetaData.isCurrency(int).

Specified by:

isCurrency in interface ResultSetMetaData

Throws:

SQLException

isNullable

public int isNullable(int pColumn)
               throws SQLException

No action — see ResultSetMetaData.isNullable(int).

Specified by:

isNullable in interface ResultSetMetaData

Throws:

SQLException

isSigned

public boolean isSigned(int pColumn)
                 throws SQLException

No action — see ResultSetMetaData.isSigned(int).

Specified by:

isSigned in interface ResultSetMetaData

Throws:

SQLException

getColumnDisplaySize

public int getColumnDisplaySize(int pColumn)
                         throws SQLException

No action — see ResultSetMetaData.getColumnDisplaySize(int).

Specified by:

getColumnDisplaySize in interface ResultSetMetaData

Throws:

SQLException

getSchemaName

public String getSchemaName(int pColumn)
                     throws SQLException

No action — see ResultSetMetaData.getSchemaName(int).

Specified by:

getSchemaName in interface ResultSetMetaData

Throws:

SQLException

getPrecision

public int getPrecision(int pColumn)
                 throws SQLException

No action — see ResultSetMetaData.getPrecision(int).

Specified by:

getPrecision in interface ResultSetMetaData

Throws:

SQLException

getScale

public int getScale(int pColumn)
             throws SQLException

No action — see ResultSetMetaData.getScale(int).

Specified by:

getScale in interface ResultSetMetaData

Throws:

SQLException

getTableName

public String getTableName(int pColumn)
                    throws SQLException

No action — see ResultSetMetaData.getTableName(int).

Specified by:

getTableName in interface ResultSetMetaData

Throws:

SQLException

getCatalogName

public String getCatalogName(int pColumn)
                      throws SQLException

No action — see ResultSetMetaData.getCatalogName(int).

Specified by:

getCatalogName in interface ResultSetMetaData

Throws:

SQLException

getColumnType

public int getColumnType(int pColumn)
                  throws SQLException

No action — see ResultSetMetaData.getColumnType(int).

Specified by:

getColumnType in interface ResultSetMetaData

Throws:

SQLException

getColumnTypeName

public String getColumnTypeName(int pColumn)
                         throws SQLException

No action — see ResultSetMetaData.getColumnTypeName(int).

Specified by:

getColumnTypeName in interface ResultSetMetaData

Throws:

SQLException

isReadOnly

public boolean isReadOnly(int pColumn)
                   throws SQLException

No action — see ResultSetMetaData.isReadOnly(int).

Specified by:

isReadOnly in interface ResultSetMetaData

Throws:

SQLException

isWritable

public boolean isWritable(int pColumn)
                   throws SQLException

No action — see ResultSetMetaData.isWritable(int).

Specified by:

isWritable in interface ResultSetMetaData

Throws:

SQLException

isDefinitelyWritable

public boolean isDefinitelyWritable(int pColumn)
                             throws SQLException

No action — see ResultSetMetaData.isDefinitelyWritable(int).

Specified by:

isDefinitelyWritable in interface ResultSetMetaData

Throws:

SQLException

getColumnClassName

public String getColumnClassName(int pColumn)
                          throws SQLException

No action — see ResultSetMetaData.getColumnClassName(int).

Specified by:

getColumnClassName in interface ResultSetMetaData

Throws:

SQLException