Java program that prints meta data of table

import java.sql.*;

public class MetaData {

public static void main(String[] args) {
try{ 
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/jdbc","root","root"); 
 
PreparedStatement ps=con.prepareStatement("select * from login"); 
ResultSet rs=ps.executeQuery(); 
ResultSetMetaData rsmd=rs.getMetaData(); 
 
System.out.println("Total columns: "+rsmd.getColumnCount()); 
for(int i=1;i<=rsmd.getColumnCount();i++){
System.out.println("Column Name : "+rsmd.getColumnName(i)); 
System.out.println("Column Type Name : "+rsmd.getColumnTypeName(i)); 
}
con.close(); 
}catch(Exception e){ System.out.println(e);} 


}

Comments