import java.sql.*;
public class GetColumnCount {
  public static void main(String[] args) throws Exception {
    String driver = "com.mysql.jdbc.Driver";
    String url = "jdbc:mysql://localhost:3306/";
    String username = "vineej";
    String password = "vineej";
    String dbName= "no";
    Class.forName(driver);
    Connection conn = DriverManager.getConnection(url+dbName, username, password);
    System.out.println("Connected");
    Statement st = conn.createStatement();
    ResultSet rs = st.executeQuery("SELECT * FROM Student");
	ResultSetMetaData rsmd = rs.getMetaData();
	int NumOfCol=rsmd.getColumnCount();
	System.out.println("Number of Columns="+NumOfCol);
    st.close();
    conn.close();
  }
}
