ResultSetMetaData interface in JDBC

Join Our Newsletter - Tips, Contests and Other Updates

Thank you for Signing Up

Please correct the marked field(s) below.

Email

Name

1,true,6,Contact Email,2 1,false,1,First Name,2 1,false,1,Last Name,2

In this article we will learn about ResultSetMetaData interface and its use in JDBC programs.

This article is a part of our core java tutorial for beginners.
Some of the methods available in ResultSetMetaData interface are given below:

To get the required meta data of a result set we will use the getMetaData() method as shown in the below example JDBC program:

import java.sql.*;
public class GetData {
   static final String DB_URL = "jdbc:mysql://localhost/sampledb";
   static final String USER = "root";
   static final String PASS = "123456";
   static final String QUERY = "SELECT id, name, mobile FROM students";

   public static void main(String[] args) {
      // Open a connection
      try
	  {
		Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);
		Statement stmt = conn.createStatement();
		ResultSet rs = stmt.executeQuery(QUERY);
		ResultSetMetaData rsmd=rs.getMetaData();
		System.out.println("Total columns: " + rsmd.getColumnCount());  
		System.out.println("Column Name of 1st column: " + rsmd.getColumnName(1));  
System.out.println("Column Type Name of 1st column: " + rsmd.getColumnTypeName(1)); 
      } 
	  catch (SQLException e) {
         e.printStackTrace();
      } 
   }
}

Output for the above program is given below:

Total columns: 3
Column Name of 1st column: id
Column Type Name of 1st column: INT

Note: The above compiles successfully only when we add the JAR file to the CLASSPATH environment variable as shown below:

For more information on JDBC, refer the following links:

• https://www.tutorialspoint.com/jdbc/index.htm

Suryateja Pericherla

Suryateja Pericherla, at present is a Research Scholar (full-time Ph.D.) in the Dept. of Computer Science & Systems Engineering at Andhra University, Visakhapatnam. Previously worked as an Associate Professor in the Dept. of CSE at Vishnu Institute of Technology, India.

He has 11+ years of teaching experience and is an individual researcher whose research interests are Cloud Computing, Internet of Things, Computer Security, Network Security and Blockchain.

He is a member of professional societies like IEEE, ACM, CSI and ISCA. He published several research papers which are indexed by SCIE, WoS, Scopus, Springer and others.