result set metadata code example

Example 1: result set meta data

It is used for to get column information not the actual data of column

Common methods are getColumnCount and getColumnLabel


//ResultSetMetaData itself does not contains any row data
        ResultSetMetaData rsmd = rs.getMetaData();
        
        
        // Metadata -- data about the data
        // ResultSetMetaData -- data about the ResultSet object that 
        contain our resulting rows and columns
        // for example column names, column counts .. and more

Example 2: result set metadata

• Metadata: data about data. 3 types:
- Database Metadata
DatabaseMetaData dbMetaData = connection.getMetaData();
- Resultset Metadata
ResultSetMetaData rsMetaData = resultSet.getMetaData();