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