Application: gvSIG desktop

import java.util.ArrayList;

import java.util.HashSet;

import java.util.Iterator;

import java.util.List;

import java.util.Set;

import javax.swing.JOptionPane;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.gvsig.app.ApplicationLocator;

import org.gvsig.fmap.dal.DataStoreNotification;

import org.gvsig.fmap.dal.feature.Feature;

import org.gvsig.fmap.dal.feature.FeatureQuery;

import org.gvsig.fmap.dal.feature.FeatureQueryOrder;

import org.gvsig.fmap.dal.feature.FeatureSelection;

import org.gvsig.fmap.dal.feature.FeatureSet;

import org.gvsig.fmap.dal.feature.FeatureStore;

import org.gvsig.fmap.mapcontrol.dal.feature.swing.FeatureTable;

import org.gvsig.i18n.Messages;

import org.gvsig.tools.dispose.DisposableIterator;

 * Operations regarding order and duplicated values.

    private static Logger logger =

        LoggerFactory.getLogger(TableFieldOperations.class);

        IconThemeHelper.registerIcon("action", "selection-duplicates", this);    

                // Mark as modified:

                table.getModel().setModified(true);

            } else {

                    // Mark as modified:

                    table.getModel().setModified(true);

                } else {

                    if ("selection-duplicates".equals(actionCommand)) {

                        // Find and select duplicates in selected column

                        long[] valCases = findSelectDuplicates(table);

                        /*

                         * Show info dialog

                         */

                        String msg = "";

                        if (valCases[0] == 0) {

                            // No repetitions

                            msg = Messages.getText("_No_repetitions_found");

                        } else {

                            String[] args = new String[2];

                            args[0] = Long.toString(valCases[0]);

                            args[1] = Long.toString(valCases[1]);

                            msg = Messages.getText(

                                "_Found_N_diff_repeated_vals_in_total_N_cases", args);

                        }

                        JOptionPane.showMessageDialog(

                            ApplicationLocator.getManager().getRootComponent(),

                            msg,

                            Messages.getText("_Find_and_select_duplicates"),

                            JOptionPane.INFORMATION_MESSAGE);

                    }

            }

            logger.error("While applying field operation (" + actionCommand + ")", e);

     * Detects repeated values

     * 

     * @param tpanel

     * @return Returns two values: numbers of values repeated and number of rows

     * with values which are repeated

     * 

     * @throws DataException

     */

    private long[] findSelectDuplicates(FeatureTableDocumentPanel tpanel)

        throws DataException {

        long[] values_cases = {0, 0};

        ConfigurableFeatureTableModel cftm = tpanel.getTablePanel().getTableModel();

        FeatureTable ftable = tpanel.getTablePanel().getTable();

        // There is only one selected column

        String fieldName = ftable.getSelectedColumnsAttributeDescriptor()[0].getName();

        FeatureStore fstore = cftm.getFeatureStore();

        Set<Feature> selFeats = new HashSet<Feature>();

        FeatureQuery fquery = fstore.createFeatureQuery();

        /*

         * Create order based on selected column

         * (ascending but descending would be ok too)

         */

        FeatureQueryOrder fqo = new FeatureQueryOrder();

        fqo.add(fieldName, true);

        fquery.setOrder(fqo);

        FeatureSet fset = fstore.getFeatureSet(fquery);

        DisposableIterator iter = fset.fastIterator();

        Feature currFeat = null;

        Feature prevFeat = null;

        Object curVal = null;

        Object preVal = null;

        /*

         * Get first feature and go next if there is next

         */

        if (iter.hasNext()) {

            currFeat = (Feature) iter.next();

            currFeat = currFeat.getCopy();

            curVal = currFeat.get(fieldName);

        } else {

            iter.dispose();

            return values_cases;

        }

        boolean equals = false;

        /*

         * Iterate and get copy of features with repeated value

         */

        while (iter.hasNext()) {

            prevFeat = currFeat;

            currFeat = (Feature) iter.next();

            currFeat = currFeat.getCopy();

            preVal = curVal;

            curVal = currFeat.get(fieldName);

            if (sameValue(preVal, curVal)) {

                if (!equals) {

                    // We are entering a new set of repetitions

                    values_cases[0]++;

                }

                equals = true;

                selFeats.add(prevFeat);

            } else {

                if (equals) {

                    // We have gone out of equal group

                    selFeats.add(prevFeat);

                }

                equals = false;

            }

        }

        iter.dispose();

        FeatureSelection fsele = (FeatureSelection) fstore.getSelection();

        fsele.beginComplexNotification();

        /*

         * Set selection inside complex notification to prevent

         * lots of notifications

         */

        // ============================

        fsele.deselectAll();

        values_cases[1] = selFeats.size(); 

        if (values_cases[1] > 0) {

            Iterator<Feature> fiter = selFeats.iterator();

            while (fiter.hasNext()) {

                fsele.select(fiter.next());

            }

        }

        // ============================

        fsele.endComplexNotification();

        return values_cases;

    }

    private boolean sameValue(Object v1, Object v2) {

        if (v1 == null) {

            if (v2 == null) {

                // Both null, same value

                return true;

            } else {

                // Only one is null, not same value

                return false;

            }

        } else {

            if (v2 == null) {

                // Only one is null, not same value

                return false;

            } else {

                // Delegate in equals method

                return v1.equals(v2);

            }

        }

    }

    /**

            logger.error("While getting number of selected rows.", e);