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

public class ServletFetchingDataFromDatabase1 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");
			Statement st = connection.createStatement();
			ResultSet rs = st.executeQuery("Select * from emp_sal");
			while(rs.next()){
				pw.println("EmpName" + "   " + "EmpSalary" + "<br>");
				pw.println(rs.getString(1) + "   " + rs.getString(2) + "<br>");
			}
		}
		catch (Exception e){
			pw.println(e);
    }
  }
}