Java program to get column names of a table

In this example of getting the columns names we need to have connection with the database and then after we will get metadata of this table and find the columns name within the metadata.

Java program to get column names of a table

In this example of getting the columns names we need to have connection with the database and then after we will get metadata of this table and find the columns name within the metadata.

Java program to get column names of a table

Java program to get column names of a table

     

In this example of getting the columns names we need to have connection with the database and then after we will get metadata of this table and find the columns name within the metadata.

In our example program we have created a database connection with the data table within the MySQL database. The data table view is as follows:

 


 


To have metadata related manipulation we need to have an object of ResultSetMetaData and thereafter we can do the manipulation on the table related information.

ResultSetMetaData rsmd = rs.getMetaData();
int NumOfCol = rsmd.getColumnCount();

Above lines of code creates an object of ResultSetMetaData and we can get the number of columns with the use of getColumnCount() methods. Now we can get the column names with the index value by the method getColumnName().Here is the example code of GetColumnName.java as follows:

GetColumnName.java

import java.sql.*;
public class GetColumnName {
  public static void main(String[] argsthrows Exception {
  String driver = "com.mysql.jdbc.Driver";
  String url = "jdbc:mysql://localhost:3306/";
  String username = "root";
  String password = "root";
  String dbName= "any";
  Class.forName(driver);
  Connection conn = DriverManager.getConnection(url+dbName, username, password);
  System.out.println("Connected");
  Statement st = conn.createStatement();
  ResultSet rs = st.executeQuery("SELECT * FROM webpages");
  ResultSetMetaData rsmd = rs.getMetaData();
  int NumOfCol = rsmd.getColumnCount();
  for(int i=1;i<=NumOfCol;i++)
  {
  System.out.println("Name of ["+i+"] Column="+rsmd.getColumnName(i));
  }
  st.close();
  conn.close();
  }


Output:

C:\javaexamples>javac GetColumnName.java

C:\javaexamples>java GetColumnName
Connected
Name of [1] Column=id
Name of [2] Column=title
Name of [3] Column=url
Name of [4] Column=pageContent

 

Download Source Code