All Packages  Class Hierarchy  This Package  Previous  Next  Index

Interface java.sql.ResultSetMetaData

public interface ResultSetMetaData

extends Object

columnNoNulls

Does not allow NULL values.

columnNullable

Allows NULL values.

columnNullableUnknown

Nullability unknown.

getCatalogName(int)

What's a column's table's catalog name?

getColumnCount()

What's the number of columns in the ResultSet?

getColumnDisplaySize(int)

What's the column's normal max width in chars?

getColumnLabel(int)

What's the suggested column title for use in printouts and displays?

getColumnName(int)

What's a column's name?

getColumnType(int)

What's a column's SQL type?

getColumnTypeName(int)

What's a column's data source specific type name?

getPrecision(int)

What's a column's number of decimal digits?

getScale(int)

What's a column's number of digits to right of the decimal point?

getSchemaName(int)

What's a column's table's schema?

getTableName(int)

What's a column's table name?

isAutoIncrement(int)

Is the column automatically numbered, thus read-only?

isCaseSensitive(int)

Does a column's case matter?

isCurrency(int)

Is the column a cash value?

isDefinitelyWritable(int)

Will a write on the column definitely succeed?

isNullable(int)

Can you put a NULL in this column?

isReadOnly(int)

Is a column definitely not writable?

isSearchable(int)

Can the column be used in a where clause?

isSigned(int)

Is the column a signed number?

isWritable(int)

Is it possible for a write on the column to succeed?

  public final static int columnNoNulls

Does not allow NULL values.

  public final static int columnNullable

Allows NULL values.

  public final static int columnNullableUnknown

Nullability unknown.

  public abstract int getColumnCount() throws SQLException

What's the number of columns in the ResultSet?

Returns:

the number

  public abstract boolean isAutoIncrement(int column) throws SQLException

Is the column automatically numbered, thus read-only?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

  public abstract boolean isCaseSensitive(int column) throws SQLException

Does a column's case matter?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

  public abstract boolean isSearchable(int column) throws SQLException

Can the column be used in a where clause?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

  public abstract boolean isCurrency(int column) throws SQLException

Is the column a cash value?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

  public abstract int isNullable(int column) throws SQLException

Can you put a NULL in this column?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

columnNoNulls, columnNullable or columnNullableUnknown

  public abstract boolean isSigned(int column) throws SQLException

Is the column a signed number?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

  public abstract int getColumnDisplaySize(int column) throws SQLException

What's the column's normal max width in chars?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

max width

  public abstract String getColumnLabel(int column) throws SQLException

What's the suggested column title for use in printouts and displays?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

  public abstract String getColumnName(int column) throws SQLException

What's a column's name?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

column name

  public abstract String getSchemaName(int column) throws SQLException

What's a column's table's schema?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

schema name or "" if not applicable

  public abstract int getPrecision(int column) throws SQLException

What's a column's number of decimal digits?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

precision

  public abstract int getScale(int column) throws SQLException

What's a column's number of digits to right of the decimal point?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

scale

  public abstract String getTableName(int column) throws SQLException

What's a column's table name?

Returns:

table name or "" if not applicable

  public abstract String getCatalogName(int column) throws SQLException

What's a column's table's catalog name?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

column name or "" if not applicable.

  public abstract int getColumnType(int column) throws SQLException

What's a column's SQL type?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

SQL type

See Also:

Types

  public abstract String getColumnTypeName(int column) throws SQLException

What's a column's data source specific type name?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

type name

  public abstract boolean isReadOnly(int column) throws SQLException

Is a column definitely not writable?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

  public abstract boolean isWritable(int column) throws SQLException

Is it possible for a write on the column to succeed?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

  public abstract boolean isDefinitelyWritable(int column) throws SQLException

Will a write on the column definitely succeed?

Parameters:

column - the first column is 1, the second is 2, ...

Returns:

true if so

All Packages  Class Hierarchy  This Package  Previous  Next  Index