Bridge in the Wild: JDBC Drivers

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class BrJdbc {
    static int countOrders(Connection connection, String customer) throws SQLException {
        String sql = "SELECT COUNT(*) FROM orders WHERE customer = ?";
        try (PreparedStatement statement = connection.prepareStatement(sql)) {
            statement.setString(1, customer);
            try (ResultSet rows = statement.executeQuery()) {
                rows.next();
                return rows.getInt(1);
            }
        }
    }

    public static void main(String[] args) {
        System.out.println("drivers registered: " + DriverManager.drivers().count());
        String url = "jdbc:postgresql://localhost/shop";
        try (Connection connection = DriverManager.getConnection(url)) {
            System.out.println("orders: " + countOrders(connection, "ana"));
        } catch (SQLException error) {
            System.out.println("SQLException: " + error.getMessage());
        }
    }
}