%@ 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(""+title+" | "+director+" | "+origin+" | "+
made+" | "+length+" |
" );
}
out.println( "
" );
conn.close();
} catch (Exception e) {
out.println( "exception: "+e+e.getMessage()+"
" );
}
%>