public void addReport(Transaction transaction, CallReportDto report) throws IOException { // TODO: STUB CODE, MUST MODIFY, DELETE THIS LINE WHEN DONE PreparedStatement prepareStatement = null; ResultSet resultSet = null; try { Connection connection = transaction.getResource(Connection.class); prepareStatement = connection.prepareStatement(ADD_REPORT); prepareStatement.setInt(1, getSeq(transaction)); prepareStatement.setInt(2, report.getContact().getSeq()); prepareStatement.setTimestamp(3, new java.sql.Timestamp(report.getCallTime().getTime())); prepareStatement.setString(4, report.getDetail()); prepareStatement.setString(5, report.getRating()); prepareStatement.setString(6, report.getSalesperson().getId()); prepareStatement.setInt(7, report.getCallBack()); prepareStatement.setInt(8, report.getActId()); resultSet = prepareStatement.executeQuery(); } catch (SQLException e) { throw new IOException(e); } finally { if (resultSet != null) { try { resultSet.close(); } catch (SQLException e) { logger.warn(e.getMessage(), e); } } if (prepareStatement != null) { try { prepareStatement.close(); } catch (SQLException e) { logger.warn(e.getMessage(), e); } } } }