private void insertUserRoles(String email, Role role, Connection conn) throws SQLException {
        PreparedStatement st = null;
        String q;
        try {
            switch (role) {
                case administrator: {
                    q = "INSERT INTO user_roles SET email = ?, roles = ?";
                    st = conn.prepareStatement(q);
                    st.setString(1, email);
                    st.setString(2, Role.administrator.toString());
                    st.executeUpdate();
                }
                case scout: {
                    q = "INSERT INTO user_roles SET email = ?, roles = ?";
                    st = conn.prepareStatement(q);
                    st.setString(1, email);
                    st.setString(2, Role.scout.toString());
                    st.executeUpdate();
                }
                case team_member: {
                    q = "INSERT INTO user_roles SET email = ?, roles = ?";
                    st = conn.prepareStatement(q);
                    st.setString(1, email);
                    st.setString(2, Role.team_member.toString());
                    st.executeUpdate();
                }
            }
        } catch (SQLException e) {
            throw e;
        } finally {
            try {
                st.close();
            } catch (SQLException e) {
                System.out.println("Unable to close statement");
            }
        }
    }