@Override public Account findByCreditCard(String creditCardNumber) { Account account = findAccountByCreditCard(creditCardNumber); loadAccountObjectives(account); return account; }
private void loadAccountObjectives(Account account, Connection connection) throws SQLException { String sql = "select * " + "from ACCOUNT_OBJECTIVE o " + "where o.ACCOUNT_ID = ?"; try (PreparedStatement statement = connection.prepareStatement(sql)) { statement.setLong(1, account.getId()); try (ResultSet resultSet = statement.executeQuery()) { while (resultSet.next()) { account.withObjective(readObjectvieFrom(resultSet)); } } } }
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 void loadAccountObjectives(Account account, Connection connection) throws SQLException { String sql = "select * " + "from ACCOUNT_OBJECTIVE o " + "where o.ACCOUNT_ID = ?"; try (PreparedStatement statement = connection.prepareStatement(sql)) { statement.setLong(1, account.getId()); try (ResultSet resultSet = statement.executeQuery()) { while (resultSet.next()) { account.withObjective(readObjectvieFrom(resultSet)); } } } }
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); }
@Override public Account findByCreditCard(String creditCardNumber) { try (Connection connection = dataSource.getConnection()) { Account account = findAccountByCreditCard(creditCardNumber, connection); loadAccountObjectives(account, connection); return account; } catch (SQLException e) { throw new RuntimeException("Error in findByCreditCard!", e); } }
private void loadAccountObjectives(Account account, Connection connection) throws SQLException { String sql = "select * " + "from ACCOUNT_OBJECTIVE o " + "where o.ACCOUNT_ID = ?"; try (PreparedStatement statement = connection.prepareStatement(sql)) { statement.setLong(1, account.getId()); try (ResultSet resultSet = statement.executeQuery()) { while (resultSet.next()) { account.withObjective(readObjectvieFrom(resultSet)); } } } }
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); }
@Override public Account findByCreditCard(String creditCardNumber) { try (Connection connection = dataSource.getConnection()) { Account account = findAccountByCreditCard(creditCardNumber, connection); loadAccountObjectives(account, connection); return account; } catch (SQLException e) { throw new RuntimeException("Error in findByCreditCard!", e); } }
private void loadAccountObjectives(Account account, Connection connection) throws SQLException { String sql = "select * " + "from ACCOUNT_OBJECTIVE o " + "where o.ACCOUNT_ID = ?"; try (PreparedStatement statement = connection.prepareStatement(sql)) { statement.setLong(1, account.getId()); try (ResultSet resultSet = statement.executeQuery()) { while (resultSet.next()) { account.withObjective(readObjectvieFrom(resultSet)); } } } }
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); }
@Override public Account findByCreditCard(String creditCardNumber) { try (Connection connection = dataSource.getConnection()) { Account account = findAccountByCreditCard(creditCardNumber, connection); loadAccountObjectives(account, connection); return account; } catch (SQLException e) { throw new RuntimeException("Error in findByCreditCard!", e); } }
private void loadAccountObjectives(Account account, Connection connection) throws SQLException { String sql = "select * " + "from ACCOUNT_OBJECTIVE o " + "where o.ACCOUNT_ID = ?"; try (PreparedStatement statement = connection.prepareStatement(sql)) { statement.setLong(1, account.getId()); try (ResultSet resultSet = statement.executeQuery()) { while (resultSet.next()) { account.withObjective(readObjectvieFrom(resultSet)); } } } }
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); }
@Override public Account findByCreditCard(String creditCardNumber) { try (Connection connection = dataSource.getConnection()) { Account account = findAccountByCreditCard(creditCardNumber, connection); loadAccountObjectives(account, connection); return account; } catch (SQLException e) { throw new RuntimeException("Error in findByCreditCard!", e); } }
private void loadAccountObjectives(Account account, Connection connection) throws SQLException { String sql = "select * " + "from ACCOUNT_OBJECTIVE o " + "where o.ACCOUNT_ID = ?"; try (PreparedStatement statement = connection.prepareStatement(sql)) { statement.setLong(1, account.getId()); try (ResultSet resultSet = statement.executeQuery()) { while (resultSet.next()) { account.withObjective(readObjectvieFrom(resultSet)); } } } }
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); }
@Override public Account findByCreditCard(String creditCardNumber) { try (Connection connection = dataSource.getConnection()) { Account account = findAccountByCreditCard(creditCardNumber, connection); loadAccountObjectives(account, connection); return account; } catch (SQLException e) { throw new RuntimeException("Error in findByCreditCard!", e); } }
@Override public Account findByCreditCard(String creditCardNumber) { try (Connection connection = dataSource.getConnection()) { Account account = findAccountByCreditCard(creditCardNumber, connection); loadAccountObjectives(account, connection); return account; } catch (SQLException e) { throw new RuntimeException("Error in findByCreditCard!", e); } }