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 + "
");
//It shows the name of the columns
pw.println("The name of the columns are:
");
for(int i =1; i<=noOfColumns;i++){
String names = rsmd.getColumnName(i);
pw.println(names);
}
}
catch(Exception e){
pw.println("The exception is " + e);
}
}
}