Getting the Column Names in a Result Set - Java JDBC

Java examples for JDBC:ResultSet

  1. HOME
  2. Java
  3. JDBC
  4. ResultSet

Description

Getting the Column Names in a Result Set

Demo Code

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

public class Main {

  public static void main(String[] argv) {
    try {//w  w  w . j  ava 2 s .  c  om
      Connection connection = null;
      // Create a result set
      Statement stmt = connection.createStatement();
      ResultSet rs = stmt.executeQuery("SELECT * FROM my_table");

      // Get result set meta data
      ResultSetMetaData rsmd = rs.getMetaData();
      int numColumns = rsmd.getColumnCount();

      // Get the column names; column indices start from 1
      for (int i = 1; i < numColumns + 1; i++) {
        String columnName = rsmd.getColumnName(i);

        // Get the name of the column's table name
        String tableName = rsmd.getTableName(i);
      }
    } catch (SQLException e) {
    }
  }
}

Related Tutorials