Problem connecting by JDBC with a SERVLET

Поиск
Список
Период
Сортировка
От Andres Davila
Тема Problem connecting by JDBC with a SERVLET
Дата
Msg-id 20020228234627.99730.qmail@web12305.mail.yahoo.com
обсуждение исходный текст
Ответы Re: Problem connecting by JDBC with a SERVLET
Re: Problem connecting by JDBC with a SERVLET
Список pgsql-jdbc
Дерево обсуждения 
I try to access a database on a Linux server, with
Apache, Tomcat & Postgres.

The servlet should connect to the database, make a
select and display the results in a webpage

My code is the following:

 Connection con = null;
         Statement stmt = null;
         ResultSet rs = null;

res.setContentType("text/html");
PrintWriter out = res.getWriter();

try {
String database = "intvuelos";
    String username = "nobody";
    String password = "";
    Class.forName("org.postgresql.Driver");

 con =
DriverManager.getConnection("jdbc:postgresql://10.65.28.12/invuelos",
username, password);
stmt = con.createStatement();
 rs = stmt.executeQuery("SELECT numeroempleado,
origen, destino FROM viajes");

        out.println("<html><head><title>Consulta de
Datos</title></head>");
        out.println("<body>");

        out.println("<ul>");

            while(rs.next()){

        out.println("<li>"+
rs.getString("numeroempleado") + " " +
rs.getString("nombre") + " " +
rs.getString("apellidos"));

           }
        out.println("</ul>");
        out.println("</body></html>");
        }


        catch(ClassNotFoundException e){
 out.println("Couldn't load database driver: " +
e.getMessage());
                }
                catch(SQLException e){
 out.println("SQLException caught: " +
e.getMessage());
                      }
    finally{
               try{
        if(con !=null) con.close();
              }
        catch (SQLException ignored){ }
        }
    }
   }

****


Please help me if you can




__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com

В списке pgsql-jdbc по дате отправления: