import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;

public class ServletGettingColumnsNames extends HttpServlet{
	public void doGet(HttpServletRequest request, HttpServletResponse response) throws  ServletException, IOException{
		response.setContentType("text/html");
		PrintWriter pw = response.getWriter();
		String connectionURL = "jdbc:mysql://localhost/zulfiqar";
		Connection connection=null;
		try{
			Class.forName("org.gjt.mm.mysql.Driver");
			connection = DriverManager.getConnection(connectionURL, "root", "admin");
			PreparedStatement pst = connection.prepareStatement("select * from emp_details");
			ResultSet rs = pst.executeQuery();
			ResultSetMetaData rsmd = rs.getMetaData();
			int noOfColumns = rsmd.getColumnCount();
			//It shows the number of columns
			pw.println("The number of columns are " + noOfColumns + "<br>");
			//It shows the name of the columns
			pw.println("The name of the columns are: <br>");
			for(int i =1; i<=noOfColumns;i++){
				String names = rsmd.getColumnName(i);
				pw.println(names);
			}
		}
		catch(Exception e){
			pw.println("The exception is " + e);
		}
	}
}