public ArrayList<Team> getAllTeams(Connection con) {

        ArrayList<Team> arrayTeams = new ArrayList();

        String SQLString = "SELECT * "
                + "FROM Teams ";

        PreparedStatement statment = null;
        try {
            statment = con.prepareStatement(SQLString);

            ResultSet rs = statment.executeQuery();

            while (rs.next()) {
                arrayTeams.add(new Team(rs.getInt(1), rs.getInt(2), rs.getInt(3)));
            }

        } catch (SQLException e) {
            System.out.println("Error in TeamMapper - getAllTeams " + e);
        } finally {

            try {
                statment.close();
            } catch (SQLException e) {
                System.out.println("Error in TeamMapper - getAllOrders.finally " + e);
            }

        }
        return arrayTeams;
    }