Revision 44678 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.jdbc/src/main/java/org/gvsig/fmap/dal/store/jdbc2/spi/operations/FetchFeatureProviderByReferenceOperation.java

View differences:

FetchFeatureProviderByReferenceOperation.java
42 42 

  		




  43
  43
  
    
    @Override


  		




  44
  44
  
    
    public final Object perform(Connection conn) throws DataException {


  		




  45
  
  
    
        FeatureProvider feature = fetchFeatureProviderByReference(


  		




  46
  
  
    
                conn,


  		




  47
  
  
    
                reference, 


  		




  48
  
  
    
                featureType,


  		




  49
  
  
    
                table


  		




  50
  
  
    
        );


  		




  
  45
  
    
        FeatureProvider feature = fetchFeatureProviderByReference(conn);


  		




  51
  46
  
    
        return feature;


  		




  52
  47
  
    
    }


  		




  53
  
  
    
       


  		




  54
  
  
    
    public FeatureProvider fetchFeatureProviderByReference(


  		




  55
  
  
    
            Connection conn,


  		




  56
  
  
    
            FeatureReferenceProviderServices reference,


  		




  57
  
  
    
            // FeatureType storeType,


  		




  58
  
  
    
            FeatureType featureType,


  		




  59
  
  
    
            TableReference table


  		




  60
  
  
    
        ) throws DataException {


  		




  
  48
  
    

  		




  
  49
  
    
    public String getSQL() {


  		




  61
  50
  
    
        List<FeatureAttributeDescriptor> columns = new ArrayList<>();        


  		




  
  51
  
    
        JDBCSQLBuilderBase sqlbuilder = this.createSQLBuilder();


  		




  
  52
  
    
        String sql = this.getSQL(sqlbuilder,columns);


  		




  
  53
  
    
        return sql;


  		




  
  54
  
    
    }


  		




  
  55
  
    

  		




  
  56
  
    
    public String getSQL(JDBCSQLBuilderBase sqlbuilder, List<FeatureAttributeDescriptor> columns) {


  		




  62
  57
  
    
        


  		




  63
  58
  
    
        // FeatureAttributeDescriptor[] primaryKey = storeType.getPrimaryKey();


  		




  64
  59
  
    
        String[] primaryKeys = reference.getKeyNames();


  		




  65
  60
  
    
        


  		




  66
  
  
    
        JDBCSQLBuilderBase sqlbuilder = this.createSQLBuilder();


  		




  67
  61
  
    
        ExpressionBuilder expbuilder = sqlbuilder.expression();


  		




  68
  62
  
    

  		




  69
  63
  
    
        for (FeatureAttributeDescriptor attr : featureType) {


  		




  ......




  108
  102
  
    
                PROP_TABLE, table


  		




  109
  103
  
    
        );


  		




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


  		




  
  105
  
    
        return sql;


  		




  
  106
  
    
    }


  		




  
  107
  
    
       


  		




  
  108
  
    
    public FeatureProvider fetchFeatureProviderByReference(


  		




  
  109
  
    
            Connection conn


  		




  
  110
  
    
        ) throws DataException {


  		




  111
  111
  
    

  		




  
  112
  
    
        List<FeatureAttributeDescriptor> columns = new ArrayList<>();        


  		




  
  113
  
    
        JDBCSQLBuilderBase sqlbuilder = this.createSQLBuilder();


  		




  
  114
  
    
        String sql = this.getSQL(sqlbuilder,columns);


  		




  
  115
  
    
        


  		




  112
  116
  
    
        PreparedStatement st = null;


  		




  113
  117
  
    
        ResultSet rs = null;


  		




  114
  118
  
    
        try {


  		












Also available in:  Unified diff