<%@ page language="java" import="java.sql.*"%> Films Example: JSP, Postgres version <% 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("" ); } out.println( "
"+title+""+director+""+origin+""+ made+""+length+"
" ); conn.close(); } catch (Exception e) { out.println( "

exception: "+e+e.getMessage()+"

" ); } %>