/** * 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 phones extends HttpServlet { public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { Connection con = null; String empid = null; res.setContentType("text/html"); PrintWriter out = res.getWriter(); empid = req.getParameter("empid"); Integer id = new Integer(empid); out.println("
"); out.println("Start Over "); 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 description, phonenumber, FROM phones " + // " WHERE Id = '" + id + "' "); ResultSet rs = stmt.executeQuery("SELECT description, phonenumber, id FROM phones " + " WHERE id = " + id ); out.println("Phonebook"); out.println(""); out.println(""); out.println(" "); out.println(""); out.println("

Employee Directory

"); while(rs.next()) { out.println(""); out.println(""); } out.println("
DescriptionNumber
" + rs.getString("description")); out.println("" + rs.getString("phonenumber")); 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) { } } } }