public void changeTeamTemplate(String username, int newTemplateNumber) {
        PreparedStatement newData = null;
        PreparedStatement studentFinder = null;
        int studentID = -1;

        try {

            studentFinder = connect.prepareStatement(
                    " select userID from User " +
                            " where username = ?; ");
            studentFinder.setString(1, username);
            ResultSet id = studentFinder.executeQuery();
            if (id.next()) {
                studentID = id.getInt(1);
            }

            newData = connect.prepareStatement(
                    " update Student set teamTemplate = ? " +
                            " where studentID = ? ; ");
            newData.setInt(1, newTemplateNumber);
            newData.setInt(2, studentID);
            newData.executeUpdate();
            connect.commit();

        } catch (SQLException sqex) {
            try { connect.rollback(); System.err.println(sqex.toString()); }
            catch (SQLException sqex2) { System.err.println("Dammit\n" + sqex2.toString()); }
        } finally {
            if (newData != null) {
                try { newData.close(); }  catch (SQLException sqex) { System.err.println(sqex.toString()); }
            }
            if (studentFinder != null) {
                try { studentFinder.close(); }  catch (SQLException sqex) { System.err.println(sqex.toString()); }
            }
        }
    }