parameter meta data

Expert:upendra kumar tiwari
i wnts to know about the finition of parameter in jdbc as well as the diffrent methods used in parameter meta data

Answers

Hi friend,

public interface ResultSetMetaData

An object that can be used to get information about the types and properties of the columns in a ResultSet object.

For example :

ResultSet rs = stmt.executeQuery("SELECT * FROM table");
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();

Method Summary
String getCatalogName(int column)
Gets the designated column's table's catalog name.
String getColumnClassName(int column)
Returns the fully-qualified name of the Java class whose instances are manufactured
if the method ResultSet.getObject is called to retrieve a value from the column.
int getColumnCount()
Returns the number of columns in this ResultSet object.
int getColumnDisplaySize(int column)
Indicates the designated column's normal maximum width in characters.
String getColumnLabel(int column)
Gets the designated column's suggested title for use in printouts and displays.
String getColumnName(int column)
Get the designated column's name.
int getColumnType(int column)
Retrieves the designated column's SQL type.
String getColumnTypeName(int column)
Retrieves the designated column's database-specific type name.
int getPrecision(int column)
Get the designated column's number of decimal digits.
int getScale(int column)
Gets the designated column's number of digits to right of the decimal point.
String getSchemaName(int column)
Get the designated column's table's schema.
String getTableName(int column)
Gets the designated column's table name.
boolean isAutoIncrement(int column)
Indicates whether the designated column is automatically numbered, thus read-only.
boolean isCaseSensitive(int column)
Indicates whether a column's case matters.
boolean isCurrency(int column)
Indicates whether the designated column is a cash value.
boolean isDefinitelyWritable(int column)
Indicates whether a write on the designated column will definitely succeed.
int isNullable(int column)
Indicates the nullability of values in the designated column.
boolean isReadOnly(int column)
Indicates whether the designated column is definitely not writable.
boolean isSearchable(int column)
Indicates whether the designated column can be used in a where clause.
boolean isSigned(int column)
Indicates whether values in the designated column are signed numbers.
boolean isWritable(int column)
Indicates whether it is possible for a write on the designated column to succeed.

For more information on JDBC visit to :

http://www.roseindia.net/jdbc/

Thanks

More Questions

Post Answers

Ask Question Facing Programming Problem?