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;
}
}
