ResultSetMetaData
- You can interrogate JDBC for detailed information about a query’s result set using a ResultSetMetaData object.
- ResultSetMetaData is a class that is used to find information about the ResultSet returned from a executeQuery call.
- It contains information about the number of columns, the types of data they contain, the names of the columns, and so on.
- Two of the most common methods in the ResultSetMetaData are getColumnName and getColumnTypeName. These retrieve the name of a column, and the name of its associated data type, respectively, each in the form of a String.
DatabaseMetaData
DatabaseMetaData is a class that can be used to fetch information about the database you are using. Use it to answer questions such as:
-
What kind of catalogs are in the database?
-
What brand of database am I working with?
-
What username am I?
ex: username = dbmd.getUserName();
Filed under: JDBC |
Think Tank 
good……………………….good
it was understandable and simple
Hi,
Wonderful ….Its very useful at the time of Interview.
thanks man………nice explaination
its good
I want the difference between ResultSet and ResultSetMetaData
every thing is fine but
ResultSetMetaData and DatabaseMetaData are the interfaces …and by using the references of these interfaces we can access the methods in it…..
ex:
ResultSet rs= statement.executeQuery(“sql query”);
ResultSetMetadata rsmd = rs.getMetaData();
rsmd.getColumnCount();
rsmd.getColumnTypeName();
by using ResultSetMetaData u can find the details of records available in the Resultset object…ex column names,datatype,size of the column
by using DataBaseMetaData u can check the details of database server for which u r connectd…ex username,url,
number of stored procedures available in database,tables of the currenct schema
add more details about DataBaseMetaData..