protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    		throws ServletException, IOException {
	    PrintWriter out= response.getWriter();
	    out.println("<h1>Dane z bazy danych PostgreSQL - ElephantSQL</h1>") ;
	 
		try
		{
			 // Class.forName("org.apache.derby.jdbc.ClientDriver");
             // url = "jdbc:postgresql://host:port/database" 
             Class.forName("org.postgresql.Driver");
			 String url = "jdbc:postgresql://<<hostname>>:5432/<<dbname>>";
			 String username = "<<user>>" ;
			 String password = "<<password>>" ;
			 Connection conn = DriverManager.getConnection(url, username, password);
			 Statement stmt = conn.createStatement();
		     String sql = "SELECT * FROM public.person";
		     ResultSet rs = stmt.executeQuery( sql );
		     out.println("<table>") ;
		     out.println("<tr><th>Lp.</th><th>Imię</th><th>Nazwisko</th><th>Miasto</th></tr>") ;
     		 while(rs.next())  {
		        out.print("<tr><td>" + rs.getInt("ID") + "</td><td>" + rs.getString("FNAME") + "</td>" ) ;
		        out.println ( "<td>" + rs.getString("LNAME") + "</td><td>" + rs.getString("CITY") + "</td></tr>" ) ;
     		 }   
     		out.println("</table>") ;
     		rs.close();
     		stmt.close();
     		conn.close();
        }
		catch(Exception e)
		{  out.println (e) ; } 
		
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		// response.getWriter().append("Served at: ").append(request.getContextPath());
		processRequest(request, response);
		
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		processRequest(request, response);
	}