JDBC Java


            import java.sql.*;
public class GetColNames
 {
 public static void main(String args[])
 {
 try
 {
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 Connection connection = DriverManager.getConnection("jdbc:odbc:dd","","");
 // Create a result set
 Statement stmt = connection.createStatement();
 ResultSet rs = stmt.executeQuery("SELECT * FROM test");
 // 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 {
 String columnName = rsmd.getColumnName(i);
 // Get the name of the column's table name
 String tableName = rsmd.getTableName(i);
 System.out.println("columnName "+columnName);
 }
 }
 catch (Exception e)
 {
 System.out.println(e);
 }
 }
}