/** * Helper class to write an person attribute if needed * * @param name name of the attribute * @param element element that the attribute will be added to * @param rs ResultSet than includes the values of the attribute * @throws SQLException * @throws Exception */ private static void writeMovieAtt(String name, XMLElement element, ResultSet rs) throws SQLException, Exception { if (rs.next()) { element.addAttribute(name, "M" + rs.getString(1)); while (rs.next()) { element.appendAttribute(name, "M" + rs.getString(1)); } } }
/** * Helper class to write an Oscar attribute if needed * * @param name Name of the attribute * @param element the element that the attribute will be added to * @param rs the result set that includes the values of the attributes * @throws SQLException * @throws Exception */ private static void writeOscarAtt(String name, XMLElement element, ResultSet rs) throws SQLException, Exception { String oscAtt = ""; if (rs.next()) { if (rs.getString(2) == null) { oscAtt = "O" + rs.getString(1) + "0000000"; } else { oscAtt = "O" + rs.getString(1) + rs.getString(2); } element.addAttribute(name, oscAtt); while (rs.next()) { if (rs.getString(2) == null) { oscAtt = "O" + rs.getString(1) + "0000000"; } else { oscAtt = "O" + rs.getString(1) + rs.getString(2); } element.appendAttribute(name, oscAtt); } } }