Application: gvSIG desktop

package org.gvsig.fmap.dal.store.jdbc2.spi.operations;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

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.JDBCHelper;

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

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

public class FetchFeatureProviderByReferenceOperation extends AbstractConnectionOperation {

        JDBCSQLBuilderBase sqlbuilder = this.createSQLBuilder();

        for (FeatureAttributeDescriptor attr : featureType) {

        }

        sqlbuilder.select().from().table().database(database).schema(schema).name(table);

        for (String name : primaryKeys )  {

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

                    sqlbuilder.eq(

                        sqlbuilder.column(name), 

                    )

                );              

            }

        }

        sqlbuilder.select().limit(1);

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

        ResultSet rs = null;

        try {

            rs = JDBCUtils.executeQuery(st, sql);

            if (!rs.next()) {

                return null;