DB3 2009-1d

public class 2009-1d {
    public static void main(String [] args) {
        private Connection conn;
        private static final String connString
            = "jdbc:oracle:thin:PAT/[email protected]:1521:bands";

        Class.forName("oracle.jdbc.driver.OracleDriver");
        conn = DriverManager.getConnection(connectionString);

        String query = "SELECT Song.title " +
                "FROM Song, Release, Member, MemberOf " +
                "WHERE Song.rid = Release.rid AND " +
                    "Release.bid = MemberOf.bid AND " +
                    "Member.mid = MemberOf.mid AND " +
                    "Member.name LIKE 'Johnny Lee Middleton' AND " +
                    "year >= 1980 AND year <= 1989";

        PreparedStatement pstmt = conn.prepareStatement(query);
        ResultSet rs = pstmt.executeQuery();

        while (rs.next()) {
            System.out.println(rs.getString("title"));
        }

        conn.close();
    }
}