public Recording find(String id, int type) { try { Recording recording = new Recording(); Statement st = conn.createStatement(); String query = "SELECT * FROM recordings WHERE id = '" + id + "' AND filetype = '" + type + "'"; ResultSet res = st.executeQuery(query); if (res.next()) { // return the found record as a whole recording.setTitle(res.getString("title")); recording.setDownloadURL(res.getString("downloadurl")); if (res.getBoolean("complete")) recording.setComplete(); recording.setDescription(res.getString("description")); recording.setFilename(res.getString("filename")); recording.setFirstTried(new Date(res.getDate("firsttry").getTime())); } else { recording = new Recording(); } res.close(); st.close(); res = null; st = null; return recording; } catch (SQLException sqlex) { LOG.error( "Java exception " + sqlex.getMessage() + " was thrown with with SQL message " + sqlex.getSQLState()); return null; } }