Application: gvSIG desktop

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import org.gvsig.fmap.dal.exception.DataException;

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

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

import org.gvsig.fmap.dal.store.jdbc2.JDBCUtils;

import org.gvsig.fmap.dal.store.jdbc2.OperationsFactory.TableReference;

import org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase;

import org.gvsig.fmap.geom.DataTypes;

        String[] primaryKeys = reference.getKeyNames();

        JDBCSQLBuilderBase sqlbuilder = this.createSQLBuilder();

        for (FeatureAttributeDescriptor attr : featureType) {

            if( attr.getType()==DataTypes.GEOMETRY ) {

                sqlbuilder.select().column().name(attr.getName()).as_geometry();

            Object value = reference.getKeyValue(name);

            if( value == null ) {

                sqlbuilder.select().where().and(

                );                

            } else {

                sqlbuilder.select().where().and(

                    )

                );              

            }

        }

        sqlbuilder.select().limit(1);

        String sql = sqlbuilder.select().toString();

        PreparedStatement st = null;