| gvSIG desktop 1

package org.gvsig.fmap.data.feature.db.jdbc.h2;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.Statement;

import java.util.ConcurrentModificationException;

import java.util.Iterator;

import org.gvsig.fmap.data.DataStore;

import org.gvsig.fmap.data.ReadException;

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

import org.gvsig.fmap.data.feature.FeatureManager;

import org.gvsig.fmap.data.feature.FeatureType;

import org.gvsig.fmap.data.feature.db.DBDataFeatureCollection;

import org.gvsig.fmap.data.feature.db.DBFeatureType;

import org.gvsig.fmap.data.feature.db.jdbc.SQLException;

import org.gvsig.tools.exception.BaseException;

public class H2FeatureCollectionEditing extends DBDataFeatureCollection {

        protected DBFeatureType featureType;

        protected String totalFilter;

        protected H2Store store;

        private int numReg=-1;

        private String sql;

        private String sqlCount;

        private String totalOrder;

        private FeatureManager featureManager;

        private int fetchSize = 5000;

        H2FeatureCollectionEditing(FeatureManager fm,H2Store store,FeatureType type) {

                this.featureManager=fm;

                this.store=store;

                this.featureType=(DBFeatureType)type;

                this.totalFilter =store.getBaseWhereClause();

                this.totalOrder = store.getBaseOrder();

                this.sql = this.store.getSqlSelectPart();

                this.sqlCount = "Select count(*) From "+ ((H2StoreParameters)this.store.getParameters()).tableID();

                if (!isStringEmpty(this.totalFilter)){

                        this.sql= this.sql + " Where " + this.totalFilter;

                        this.sqlCount= this.sqlCount + " Where " + this.totalFilter;

                }

                if (!isStringEmpty(this.totalOrder)){

                        this.sql= this.sql + " Order by " + this.totalOrder;

                }

//                if (this.filter!=null)

//                        parser = new FeatureFilterParser(filter,this.featureType);

        }

        private ResultSet getNewResulset(String aSql) throws ReadException{

                this.store.open();

                Connection conn = this.store.getConnection();

                try {

                        Statement st = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY);

                        return st.executeQuery(aSql);

                } catch (java.sql.SQLException e) {

                        throw new SQLException(aSql,this.store.getName(),e);

                }

        }

        public int size() {

                checkModified();

                try {

                        if (this.numReg < 0){

                                ResultSet r=null;

                                r = this.getNewResulset(this.sqlCount);

                                try {

                                        r.next();

                                        numReg = r.getInt(1);

                                } catch (java.sql.SQLException e) {

                                        throw new ReadException(this.store.getName(),e);

                                } finally{

                                        try {

                                                r.close();

                                        } catch (java.sql.SQLException e) {

                                                throw new ReadException(this.store.getName(),e);

                                        }

                                }

                                numReg = numReg+featureManager.getNum();

                        }

                        return numReg;

                } catch (BaseException e){

                        throw new RuntimeException(e);

                }

        }

        protected Iterator internalIterator(int index) {

        checkModified();

        try {

            H2Iterator dbfIter = new H2Iterator(this.store, this.featureType,

                    this.sql, this.fetchSize, this.featureManager, index + 1);

            return dbfIter;

        } catch (BaseException e) {

            throw new RuntimeException(e);

        }

        }

        protected class H2Iterator extends AbstractH2DBIterator {

                public H2Iterator(H2Store store, DBFeatureType featureType, String sql,

                int fetchSize, FeatureManager featureManager,

                int initialPosition) throws ReadException {

            super(store, featureType, sql, fetchSize, featureManager, null,

                    initialPosition);

        }

                protected Feature createFeatureFromTheResulset() throws ReadException {

                        return ((H2Store) this.store).createFeatureFromResulset(this.rs,

                                        this.featureType);

                }

                protected void checkModified() {

                        if (modified) {

                                throw new ConcurrentModificationException(

                                                "FeatureCollection modified");

                        }

                }

        }

        public void dispose() {

                this.store.deleteObserver(this);

                this.store = null;

                this.featureManager = null;

                this.featureType = null;

        }

        public boolean isFromStore(DataStore store) {

                return this.store.equals(store);

        }

        public FeatureType getFeatureType() {

                return this.featureType;

        }

}