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);}
}
}
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
Post a Comment