import java.sql.*; public class Decades { 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)"); Statement stmt = c.createStatement(); for(int decadeStart = 1920; decadeStart < 2000; decadeStart += 10){ System.out.println("==== Movies of the " + decadeStart + "s ===="); ResultSet rs = stmt.executeQuery ("select title, year_made from movie_info " + "where year_made >= " + decadeStart + " and year_made < " + (decadeStart + 10)); while(rs.next()){ System.out.println(rs.getString(1) + " (" + rs.getInt(2) + ")"); } } } catch(Exception e){ System.err.println(e); } } }