import java.sql.*; public class DecadesPrep { public static void main(String args[]){ try{ Class.forName("postgresql.Driver"); Connection c = DriverManager.getConnection ("jdbc:postgresql://kilpinen.mcs.gac.edu/max_movies", "nobody", "(password disclosed in class)"); PreparedStatement stmt = c.prepareStatement ("select title, year_made from movie_info " + "where year_made >= ?" + " and year_made < ?"); for(int decadeStart = 1920; decadeStart < 2000; decadeStart += 10){ System.out.println("==== Movies of the " + decadeStart + "s ===="); stmt.setInt(1, decadeStart); stmt.setInt(2, decadeStart + 10); ResultSet rs = stmt.executeQuery(); while(rs.next()){ System.out.println(rs.getString(1) + " (" + rs.getInt(2) + ")"); } } } catch(Exception e){ System.err.println(e); } } }