// Servlet_Postgres.java - example connection to Postgres
import java.io.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class Servlet_Postgres extends HttpServlet {
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException
{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("");
out.println("");
out.println(" Films Example: Servlet, Postgres version");
out.println("");
out.println("");
try {
Class.forName("org.postgresql.Driver");
} catch (ClassNotFoundException e) {
out.println("Driver not found: " + e + e.getMessage() + "
" );
}
try {
Connection conn = DriverManager.getConnection (
"jdbc:postgresql://db.doc.ic.ac.uk/films",
"lab", "lab" );
Statement stmt = conn.createStatement();
ResultSet rs;
rs = stmt.executeQuery("SELECT * FROM films");
out.println( "" );
while ( rs.next() ) {
String title = rs.getString("title");
String director = rs.getString("director");
String origin = rs.getString("origin");
String made = rs.getString("made");
String length = rs.getString("length");
out.println("| "+title+" | "+director+" | "+origin+" | "+
made+" | "+length+" |
" );
}
out.println( "
" );
conn.close();
} catch (Exception e) {
out.println( "exception: "+e+e.getMessage()+"
" );
}
out.println("");
out.println("");
}
}