public void update(Recording recording) throws SQLException { Statement st = conn.createStatement(); StringBuffer sb = new StringBuffer(); sb.append("UPDATE recordings SET "); if (!(recording.getDownloadURL() == null)) { sb.append(" downloadurl = '"); sb.append(recording.getDownloadURL()); sb.append("' "); } if (!(recording.getTitle() == null)) { sb.append(", title = '"); sb.append(recording.getTitle()); sb.append("' "); } if (!(recording.getDescription() == null)) { sb.append(", description = '"); sb.append(recording.getDescription()); sb.append("' "); } if (!(recording.getFilename() == null)) { sb.append(", filename = '"); sb.append(recording.getFilename()); sb.append("' "); } if (!(recording.getFirstTried() == null)) { sb.append(", firsttry = '"); sb.append(new java.sql.Timestamp(recording.getFirstTried().getTime())); sb.append("' "); } if (!recording.isComplete()) sb.append(", complete = FALSE "); else sb.append(", complete = TRUE "); sb.append("WHERE id = '"); sb.append(recording.getId()); sb.append("' AND filetype = '"); sb.append(recording.getType()); sb.append("'"); LOG.debug(sb.toString()); st.execute(sb.toString()); st.close(); st = null; conn.commit(); }
public void insert(Recording recording) throws SQLException { Statement st = conn.createStatement(); StringBuffer sb = new StringBuffer(); sb.append("INSERT INTO recordings VALUES('"); sb.append(recording.getId()); sb.append("', '"); if (recording.getDownloadURL() == null) sb.append(""); else sb.append(recording.getDownloadURL()); sb.append("', '"); if (recording.getTitle() == null) sb.append(""); else sb.append(recording.getTitle()); sb.append("', '"); if (recording.getDescription() == null) sb.append(""); else sb.append(recording.getDescription()); sb.append("', '"); if (recording.getFilename() == null) sb.append(""); else sb.append(recording.getFilename()); sb.append("', '"); if (recording.getType() == 0) sb.append(""); else sb.append(recording.getType()); sb.append("', '"); if (recording.getFirstTried() == null) sb.append(""); else sb.append(new Timestamp(recording.getFirstTried().getTime())); sb.append("', "); if (!recording.isComplete()) sb.append("FALSE "); else sb.append("TRUE "); sb.append(")"); LOG.debug(sb.toString()); // execute the insert statement st.executeUpdate(sb.toString()); st.close(); st = null; conn.commit(); }