Display All Columns Name and Datatype

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

/**
* Connect to one table and display all its columns name and datatype.
*
*
*/
public class JDBCTest6 {

// used for db connection
private static Connection conn;

// at loading of class, connects to DB
static {
// make connection with Employee Database
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

// connectivity 1 : Require DSN named : dsn
//conn = DriverManager.getConnection("jdbc:odbc:dsn" ,"","");

// connectivity 2 : No requirement of DSN, direct connectivity to
// input file name
String sDBQ = "D:\\emp.mdb";
String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + sDBQ + ";DriverID=22;READONLY=true";
conn = DriverManager.getConnection(database, "", "");
} catch (ClassNotFoundException cnfe) {
System.out.println("Class Not Found Exception");
cnfe.printStackTrace();
} catch (SQLException sqle) {
System.out.println("SQL Exception");
sqle.printStackTrace();
}
}

/**
* execution begins from here
*
* @param args
* command line arguments
*/
public static void main(String[] args) {
getEmpTableMetaData();
}

/**
* gets employees table data and display in good format
*
*/
public static void getEmpTableMetaData() {
try {

// statement to execute query
Statement stmtObj = conn.createStatement();

// result set
ResultSet rsObj = stmtObj.executeQuery("select * from employees where 1>2");

//get metadata
ResultSetMetaData rsmdObj=rsObj.getMetaData();

System.out.println("Structure of employee Table is :: ");
System.out.println("---------------------------------");

// display header
for (int i = 1; i <= rsmdObj.getColumnCount(); i++) {
System.out.printf("%1$-15s ",rsmdObj.getColumnName(i));
System.out.printf("%1$-15s\n",rsmdObj.getColumnTypeName(i) + "(" +rsmdObj.getColumnDisplaySize(i) + ")");
}
} catch (SQLException sqle) {
sqle.printStackTrace();
} finally {
conn = null;
}

}
}