| import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Statement; public class MetaData { static Connection con; public static void main(String args[]) throws Exception { try { Class.forName(“oracle.jdbc.driver.OracleDriver”); System.out.println(“Driver is ready”); con = DriverManager.getConnection( “jdbc:oracle:thin:@localhost:1521:xe”, “system”, “admin”); System.out.println(“Connection is ready”); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(“select *from account”); ResultSetMetaData rsmd = rs.getMetaData(); int count = rsmd.getColumnCount(); System.out.println(“Number of Columns : ” + count); for(int i=1 ; i<=count ; i++) { System.out.println(“Column Name : ” + rsmd.getColumnName(i) + “\tType : ” + rsmd.getColumnTypeName(i)); } } finally { if(con != null) { con.close(); System.out.println(“Connection closed”); } } } } |