


      import javax.servlet.*;

      import javax.servlet.http.*;

      import java.io.*;

      import java.text.*;

      import java.util.*;

      import java.sql.*;



      public class EmpList extends HttpServlet {



          public void doGet(HttpServletRequest request,

                            HttpServletResponse response)

              throws IOException, ServletException

          {



           Employee MyEmp = new Employee(); // Create new instance of Employee.



           try

               {

                ResultSet EmpSet = MyEmp.GetData();



              response.setContentType("text/html");

              PrintWriter out = response.getWriter();



              out.println("<html>");

              out.println("<body bgcolor=\"white\">");

              out.println("<head>");

              out.println("<title>" + "Ansatte oversikt" + "</title>");

              out.println("</head>");

              out.println("<body>");

              out.println("<h1>" + "Ansatte oversikt " + "</h1>");

              out.println("<table border=\"1\" cellpadding=\"0\"cellspacing=\"0\" width=\"561\" bordercolor=\"#000000\">");

              out.println("  <tr>");

              out.println("    <td bgcolor=\"#008080\"width=\"61\"><strong>Ansatt</strong></td>");

              out.println("    <td bgcolor=\"#008080\"width=\"88\"><strong>Jobb </strong></td>");

              out.println("    <td bgcolor=\"#008080\"width=\"95\"><strong>Manager </strong></td>");

              out.println("  </tr>");



                 //Walk ResultSet for each row...!



              while (EmpSet.next())

              {

                out.println(" <tr>");

                out.println(" <td bgcolor=\"#C0C0C0\" width=\"61\"> "

              + EmpSet.getString(1) + "</td>");

                out.println(" <td bgcolor=\"#C0C0C0\" width=\"88\"> "

              + EmpSet.getString(2) + "</td>");

                out.println(" <td bgcolor=\"#C0C0C0\" width=\"95\"> "

              + EmpSet.getString(3) + "</td>");



                out.println("  </tr>");



              }



              out.println("</table>");

              out.println("</body>");

              out.println("</html>");

              }



              catch(SQLException e)

              {

                System.out.println(e);

              }



          }

         }