public int getIdFromRehearsalRequest(Band band, RehearsalRequest rehearsalRequest) {
int id = -1;
try {
PreparedStatement stmt =
conn.prepareStatement(
"select id from rehearsal_requests where band_id = ? and start_time = ? and end_time = ?",
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_READ_ONLY);
stmt.setInt(1, band.getId());
stmt.setTimestamp(2, new java.sql.Timestamp(rehearsalRequest.getStartTime().getTime()));
stmt.setTimestamp(3, new java.sql.Timestamp(rehearsalRequest.getEndTime().getTime()));
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
id = rs.getInt(1);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return id;
}
public void addRehearsalRequest(Band band, RehearsalRequest rehearsalRequest) {
try {
PreparedStatement stmt =
conn.prepareStatement(
"insert into rehearsal_requests values (0, ?, ?, ?, ?)",
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_READ_ONLY);
stmt.setInt(1, band.getId());
stmt.setTimestamp(2, new java.sql.Timestamp(rehearsalRequest.getStartTime().getTime()));
stmt.setTimestamp(3, new java.sql.Timestamp(rehearsalRequest.getEndTime().getTime()));
stmt.setDouble(4, rehearsalRequest.getDuration());
stmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
