java.sql

Interface ResultSetMetaData

Known Subinterfaces:
RowSetMetaData

public interface ResultSetMetaData

This interface provides a mechanism for obtaining information about the columns that are present in a ResultSet.

Note that in this class column indexes start at 1, not 0.

Field Summary

static int
columnNoNulls
The column does not allow NULL's.
static int
columnNullable
The column allows NULL's.
static int
columnNullableUnknown
It is unknown whether or not the column allows NULL's.

Method Summary

String
getCatalogName(int column)
This method returns the name of the catalog containing the specified column.
String
getColumnClassName(int column)
This method returns the name of the Java class which will be used to create objects representing the data in this column.
int
getColumnCount()
This method returns the number of columns in the result set.
int
getColumnDisplaySize(int column)
This method returns the maximum number of characters that can be used to display a value in this column.
String
getColumnLabel(int column)
This method returns a string that should be used as a caption for this column for user display purposes.
String
getColumnName(int column)
This method returns the name of the specified column.
int
getColumnType(int column)
This method returns the SQL type of the specified column.
String
getColumnTypeName(int column)
This method returns the name of the SQL type for this column.
int
getPrecision(int column)
This method returns the precision of the specified column, which is the number of decimal digits it contains.
int
getScale(int column)
This method returns the scale of the specified column, which is the number of digits to the right of the decimal point.
String
getSchemaName(int column)
This method returns the name of the schema that contains the specified column.
String
getTableName(int column)
This method returns the name of the table containing the specified column.
boolean
isAutoIncrement(int column)
This method test whether or not the column is an auto-increment column.
boolean
isCaseSensitive(int column)
This method tests whether or not a column is case sensitive in its values.
boolean
isCurrency(int column)
This method tests whether or not the column stores a monetary value.
boolean
isDefinitelyWritable(int column)
This method tests whether or not the column is writable.
int
isNullable(int column)
This method returns a value indicating whether or not the specified column may contain a NULL value.
boolean
isReadOnly(int column)
This method tests whether or not the specified column is read only.
boolean
isSearchable(int column)
This method tests whether not the specified column can be used in a WHERE clause.
boolean
isSigned(int column)
This method tests whether or not the value of the specified column is signed or unsigned.
boolean
isWritable(int column)
This method tests whether or not the column may be writable.

Field Details

columnNoNulls

public static final int columnNoNulls
The column does not allow NULL's.
Field Value:
0

columnNullable

public static final int columnNullable
The column allows NULL's.
Field Value:
1

columnNullableUnknown

public static final int columnNullableUnknown
It is unknown whether or not the column allows NULL's.
Field Value:
2

Method Details

getCatalogName

public String getCatalogName(int column)
            throws SQLException
This method returns the name of the catalog containing the specified column.
Parameters:
Returns:
The name of the catalog containing the column.
Throws:
SQLException - If an error occurs.

getColumnClassName

public String getColumnClassName(int column)
            throws SQLException
This method returns the name of the Java class which will be used to create objects representing the data in this column.
Parameters:
Returns:
The name of the Java class that will be used for values in this column.
Throws:
SQLException - If an error occurs.

getColumnCount

public int getColumnCount()
            throws SQLException
This method returns the number of columns in the result set.
Returns:
The number of columns in the result set.
Throws:
SQLException - If an error occurs.

getColumnDisplaySize

public int getColumnDisplaySize(int column)
            throws SQLException
This method returns the maximum number of characters that can be used to display a value in this column.
Parameters:
Returns:
The maximum number of characters that can be used to display a value for this column.
Throws:
SQLException - If an error occurs.

getColumnLabel

public String getColumnLabel(int column)
            throws SQLException
This method returns a string that should be used as a caption for this column for user display purposes.
Parameters:
Returns:
A display string for the column.
Throws:
SQLException - If an error occurs.

getColumnName

public String getColumnName(int column)
            throws SQLException
This method returns the name of the specified column.
Parameters:
Returns:
The name of the column.
Throws:
SQLException - If an error occurs.

getColumnType

public int getColumnType(int column)
            throws SQLException
This method returns the SQL type of the specified column. This will be one of the constants from Types.
Parameters:
Returns:
The SQL type for this column.
Throws:
SQLException - If an error occurs.
See Also:
Types

getColumnTypeName

public String getColumnTypeName(int column)
            throws SQLException
This method returns the name of the SQL type for this column.
Parameters:
Returns:
The name of the SQL type for this column.
Throws:
SQLException - If an error occurs.

getPrecision

public int getPrecision(int column)
            throws SQLException
This method returns the precision of the specified column, which is the number of decimal digits it contains.
Parameters:
Returns:
The precision of the specified column.
Throws:
SQLException - If an error occurs.

getScale

public int getScale(int column)
            throws SQLException
This method returns the scale of the specified column, which is the number of digits to the right of the decimal point.
Parameters:
Returns:
The scale of the column.
Throws:
SQLException - If an error occurs.

getSchemaName

public String getSchemaName(int column)
            throws SQLException
This method returns the name of the schema that contains the specified column.
Parameters:
Returns:
The name of the schema that contains the column.
Throws:
SQLException - If an error occurs.

getTableName

public String getTableName(int column)
            throws SQLException
This method returns the name of the table containing the specified column.
Parameters:
Returns:
The name of the table containing the column.
Throws:
SQLException - If an error occurs.

isAutoIncrement

public boolean isAutoIncrement(int column)
            throws SQLException
This method test whether or not the column is an auto-increment column. Auto-increment columns are read-only.
Parameters:
Returns:
true if the column is auto-increment, false otherwise.
Throws:
SQLException - If an error occurs.

isCaseSensitive

public boolean isCaseSensitive(int column)
            throws SQLException
This method tests whether or not a column is case sensitive in its values.
Parameters:
Returns:
true if the column value is case sensitive, false otherwise.
Throws:
SQLException - If an error occurs.

isCurrency

public boolean isCurrency(int column)
            throws SQLException
This method tests whether or not the column stores a monetary value.
Parameters:
Returns:
true if the column contains a monetary value, false otherwise.
Throws:
SQLException - If an error occurs.

isDefinitelyWritable

public boolean isDefinitelyWritable(int column)
            throws SQLException
This method tests whether or not the column is writable. This does guarantee that a write will be successful.
Parameters:
Returns:
true if the column is writable, false otherwise.
Throws:
SQLException - If an error occurs.

isNullable

public int isNullable(int column)
            throws SQLException
This method returns a value indicating whether or not the specified column may contain a NULL value.
Parameters:
Returns:
A constant indicating whether or not the column can contain NULL, which will be one of columnNoNulls, columnNullable, or columnNullableUnknown.
Throws:
SQLException - If an error occurs.

isReadOnly

public boolean isReadOnly(int column)
            throws SQLException
This method tests whether or not the specified column is read only.
Parameters:
Returns:
true if the column is read only, false otherwise.
Throws:
SQLException - If an error occurs.

isSearchable

public boolean isSearchable(int column)
            throws SQLException
This method tests whether not the specified column can be used in a WHERE clause.
Parameters:
Returns:
true if the column may be used in a WHERE clause, false otherwise.
Throws:
SQLException - If an error occurs.

isSigned

public boolean isSigned(int column)
            throws SQLException
This method tests whether or not the value of the specified column is signed or unsigned.
Parameters:
Returns:
true if the column value is signed, false otherwise.
Throws:
SQLException - If an error occurs.

isWritable

public boolean isWritable(int column)
            throws SQLException
This method tests whether or not the column may be writable. This does not guarantee that a write will be successful.
Parameters:
Returns:
true if the column may be writable, false otherwise.
Throws:
SQLException - If an error occurs.

ResultSetMetaData.java -- Returns information about the ResultSet Copyright (C) 1999, 2000, 2002 Free Software Foundation, Inc. This file is part of GNU Classpath. GNU Classpath 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 2, or (at your option) any later version. GNU Classpath 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 GNU Classpath; see the file COPYING. If not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. Linking this library statically or dynamically with other modules is making a combined work based on this library. Thus, the terms and conditions of the GNU General Public License cover the whole combination. As a special exception, the copyright holders of this library give you permission to link this library with independent modules to produce an executable, regardless of the license terms of these independent modules, and to copy and distribute the resulting executable under terms of your choice, provided that you also meet, for each linked independent module, the terms and conditions of the license of that module. An independent module is a module which is not derived from or based on this library. If you modify this library, you may extend this exception to your version of the library, but you are not obligated to do so. If you do not wish to do so, delete this exception statement from your version.