All Packages  Class Hierarchy  This Package  Previous  Next  Index

Interface java.sql.ResultSetMetaData

public interface ResultSetMetaData

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 static final int columnNoNulls

Does not allow NULL values.

 public static final int columnNullable

Allows NULL values.

 public static final int columnNullableUnknown

Nullability unknown.

 public abstract int getColumnCount() throws SQLException

What's the number of columns in the ResultSet?

Returns:

the number

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

 public abstract String getTableName(int column) throws SQLException

What's a column's table name?

Returns:

table name or "" if not applicable

Throws: SQLException

if a database-access error occurs.

 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.

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

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

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

 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

Throws: SQLException

if a database-access error occurs.

All Packages  Class Hierarchy  This Package  Previous  Next  Index