/** * Title: Phone List

* Description: Phone List Servlet

* Copyright: Copyright (c) Michael Markovich

* Company:

* @author Michael Markovich * @version 1.0 */ import java.io.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; public class display extends HttpServlet { public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { Connection con = null; res.setContentType("text/html"); PrintWriter out = res.getWriter(); String formName = req.getParameter("formName"); out.println("New Search "); try { Class.forName("org.gjt.mm.mysql.Driver"); String url = "jdbc:mysql://localhost/employees"; con = DriverManager.getConnection(url); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("SELECT LastName, FirstName, Department, Id FROM EMPLOYEES WHERE LastName >= '" + formName + "' " + "ORDER BY LastName, FirstName"); out.println("Phonebook"); out.println(""); out.println(""); out.println(" "); out.println(""); out.println("

Employee Directory

"); while(rs.next()) { out.println(""); out.println("\n"); } out.println("
NameDepartment
" + rs.getString("LastName") + ", " + rs.getString("FirstName") + ""); out.println("" + rs.getString("Department")); out.println("" + rs.getString("Id")); out.println("
"); out.println(""); } catch (ClassNotFoundException e) { out.println("Couldn't load database driver: " + e.getMessage()); } catch (SQLException e) { out.println("SQLException: " + e.getMessage()); } finally { try { if (con != null) con.close(); } catch (SQLException ignored) { } } } }