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" + "
");
pw.println(rs.getString(1) + " " + rs.getString(2) + "
");
}
}
catch (Exception e){
pw.println(e);
}
}
}