| gvSIG desktop 1

package org.gvsig.data.datastores.vectorial.db.jdbc;

import junit.framework.TestCase;

import org.gvsig.data.DataManager;

import org.gvsig.data.IDataStoreParameters;

import org.gvsig.data.exception.CloseException;

import org.gvsig.data.exception.InitializeException;

import org.gvsig.data.exception.OpenException;

import org.gvsig.data.exception.ReadException;

import org.gvsig.data.exception.WriteException;

import org.gvsig.data.vectorial.IFeature;

import org.gvsig.data.vectorial.IFeatureCollection;

import org.gvsig.data.vectorial.IFeatureStore;

import org.gvsig.data.vectorial.IFeatureType;

import org.gvsig.data.vectorial.visitor.PrintlnFeaturesVisitor;

import org.gvsig.exceptions.BaseException;

public abstract class JDBCTest extends TestCase {

        public JDBCTest() {

                super();

        }

        protected void storeTest(IDataStoreParameters dp, String filter, String order, boolean testEdit) {

                        DataManager dsm=DataManager.getManager();

                        IFeatureStore fs=null;

                        try {

                                fs = (IFeatureStore)dsm.createDataStore(dp);

                        } catch (InitializeException e) {

                                e.printStackTrace();

                                fail("Exception:" + e);

                        }

                        try {

                                fs.open();

                        } catch (OpenException e2) {

                                e2.printStackTrace();

                                fail();

                        }

                        if (fs.isEditable() && testEdit) {

                                try {

                                        fs.startEditing();

                                } catch (ReadException e) {

                                        e.printStackTrace();

                                        fail();

                                }

                                IFeature feature1 = fs.createDefaultFeature(false);

                                feature1.set("ID",1);

                                IFeature feature2 = fs.createDefaultFeature(false);

                                feature2.set("ID",2);

                                IFeature feature3 = fs.createDefaultFeature(false);

                                feature3.set("ID",3);

                                fs.insert(feature1);

                                fs.insert(feature2);

                                fs.update(feature3,feature1);

                                fs.delete(feature3);

                                fs.delete(feature2);

                        }

                        //Mostrar por consola todos los registros.

                        IFeatureType ft= fs.getDefaultFeatureType();

                        IFeatureCollection featureCollection=null;

        //                featureCollection = (IFeatureCollection)fs.getDataCollection();

        //                featureCollection = (IFeatureCollection)fs.getDataCollection(ft,"NOMBRE = 'CALPE'",null);

        //                featureCollection = (IFeatureCollection)fs.getDataCollection(ft,"AREA > 3.2213163729E7 and AREA < 3.2213163749E7",null);

                        try {

                                featureCollection = (IFeatureCollection)fs.getDataCollection(ft,filter,order);

                        } catch (ReadException e2) {

                                // TODO Auto-generated catch block

                                e2.printStackTrace();

                        }

                        PrintlnFeaturesVisitor visitor=new PrintlnFeaturesVisitor(ft);

                        try {

                                featureCollection.accept(visitor);

                        } catch (BaseException e1) {

                                e1.printStackTrace();

                                fail("Exception: "+e1);

                        }

                        featureCollection.dispose();

                        if (fs.isEditable() && testEdit){

                                try {

                                        fs.finishEditing();

        //                                fs.cancelEditing();

                                } catch (WriteException e) {

                                        e.printStackTrace();

                                        fail("Exception: "+e);

                                } catch (ReadException e) {

                                        e.printStackTrace();

                                        fail("Exception: "+e);

                                }

                        }

                        try {

                                fs.close();

                        } catch (CloseException e) {

                                e.printStackTrace();

                                fail("Exception: "+e);

                        }

                        try {

                                fs.dispose();

                        } catch (CloseException e) {

                                // TODO Auto-generated catch block

                                e.printStackTrace();

                        }

                }

}