private Account findAccountByCreditCard(String creditCardNumber, Connection connection) throws SQLException { String sql = "select * " + "from ACCOUNT a " + "join ACCOUNT_CREDIT_CARD c on (a.ID = c.ACCOUNT_ID) " + "where c.NUMBER = ?"; try (PreparedStatement statement = connection.prepareStatement(sql)) { statement.setString(1, creditCardNumber); try (ResultSet resultSet = statement.executeQuery()) { if (resultSet.next()) { return readAccountFrom(resultSet); } } } throw new EmptyResultDataAccessException(1); }
private Account findAccountByCreditCard(String creditCardNumber, Connection connection) throws SQLException { String sql = "select * " + "from ACCOUNT a " + "join ACCOUNT_CREDIT_CARD c on (a.ID = c.ACCOUNT_ID)" + "where c.NUMBER = ?"; try (PreparedStatement statement = connection.prepareStatement(sql)) { statement.setString(1, creditCardNumber); try (ResultSet resultSet = statement.executeQuery()) { if (resultSet.next()) { return readAccountFrom(resultSet); } } } throw new EmptyResultDataAccessException(1); }
private Account findAccountByCreditCard(String creditCardNumber, Connection connection) throws SQLException { String sql = "select * " + "from ACCOUNT a " + "join ACCOUNT_CREDIT_CARD c on (a.ID = c.ACCOUNT_ID)" + "where c.NUMBER = ?"; try (PreparedStatement statement = connection.prepareStatement(sql)) { statement.setString(1, creditCardNumber); try (ResultSet resultSet = statement.executeQuery()) { if (resultSet.next()) { return readAccountFrom(resultSet); } } } throw new EmptyResultDataAccessException(1); }
private Account findAccountByCreditCard(String creditCardNumber, Connection connection) throws SQLException { String sql = "select * " + "from ACCOUNT a " + "join ACCOUNT_CREDIT_CARD c on (a.ID = c.ACCOUNT_ID)" + "where c.NUMBER = ?"; try (PreparedStatement statement = connection.prepareStatement(sql)) { statement.setString(1, creditCardNumber); try (ResultSet resultSet = statement.executeQuery()) { if (resultSet.next()) { return readAccountFrom(resultSet); } } } throw new EmptyResultDataAccessException(1); }
private Account findAccountByCreditCard(String creditCardNumber, Connection connection) throws SQLException { String sql = "select * " + "from ACCOUNT a " + "join ACCOUNT_CREDIT_CARD c on (a.ID = c.ACCOUNT_ID)" + "where c.NUMBER = ?"; try (PreparedStatement statement = connection.prepareStatement(sql)) { statement.setString(1, creditCardNumber); try (ResultSet resultSet = statement.executeQuery()) { if (resultSet.next()) { return readAccountFrom(resultSet); } } } throw new EmptyResultDataAccessException(1); }
private Account findAccountByCreditCard(String creditCardNumber, Connection connection) throws SQLException { String sql = "select * " + "from ACCOUNT a " + "join ACCOUNT_CREDIT_CARD c on (a.ID = c.ACCOUNT_ID)" + "where c.NUMBER = ?"; try (PreparedStatement statement = connection.prepareStatement(sql)) { statement.setString(1, creditCardNumber); try (ResultSet resultSet = statement.executeQuery()) { if (resultSet.next()) { return readAccountFrom(resultSet); } } } throw new EmptyResultDataAccessException(1); }