Revision 45131 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/CalculateEnvelopeOfColumnOperation.java

View differences:

CalculateEnvelopeOfColumnOperation.java
27 27 
import java.sql.ResultSet;
28 28 
import java.sql.SQLException;
29 29 
import java.sql.Statement;
30 
import java.util.logging.Level;
31 
import java.util.logging.Logger;
30 32 
import org.apache.commons.lang3.StringUtils;
31 33 
import org.cresques.cts.IProjection;
32 34 
import org.gvsig.expressionevaluator.ExpressionBuilder.Variable;
33 35 
import org.gvsig.expressionevaluator.GeometryExpressionBuilder;
34 36 
import org.gvsig.fmap.dal.exception.DataException;
37 
import org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor;
35 38 
import org.gvsig.fmap.dal.feature.FeatureType;
36 39 
import org.gvsig.fmap.dal.store.jdbc.exception.JDBCSQLException;
37 40 
import org.gvsig.fmap.dal.store.jdbc2.JDBCHelper;
......
40 43 
import org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase;
41 44 
import static org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase.PROP_TABLE;
42 45 
import org.gvsig.fmap.geom.Geometry;
46 
import org.gvsig.fmap.geom.GeometryLocator;
43 47 
import org.gvsig.fmap.geom.GeometryUtils;
48 
import org.gvsig.fmap.geom.exception.CreateEnvelopeException;
44 49 
import org.gvsig.fmap.geom.primitive.Envelope;
50 
import org.gvsig.fmap.geom.type.GeometryType;
45 51 

  		




  46
  52
  
    
public class CalculateEnvelopeOfColumnOperation extends AbstractConnectionOperation {


  		




  47
  53
  
    

  		




  48
  
  
    
    private final TableReference table;


  		




  49
  
  
    
    private final String columnName;


  		




  50
  
  
    
    private final String baseFilter;


  		




  51
  
  
    
    private final Envelope limit;


  		




  52
  
  
    
    private final IProjection crs;


  		




  53
  
  
    
    private final FeatureType featureType;


  		




  
  54
  
    
    protected final TableReference table;


  		




  
  55
  
    
    protected final String columnName;


  		




  
  56
  
    
    protected final String baseFilter;


  		




  
  57
  
    
    protected final Envelope limit;


  		




  
  58
  
    
    protected final IProjection crs;


  		




  
  59
  
    
    protected final FeatureType featureType;


  		




  54
  60
  
    

  		




  55
  61
  
    
    public CalculateEnvelopeOfColumnOperation(


  		




  56
  62
  
    
            JDBCHelper helper,


  		




  ......




  183
  189
  
    
        }


  		




  184
  190
  
    
    }


  		




  185
  191
  
    

  		




  186
  
  
    
    private Envelope calculateEnvelopeOfColumnWithAggregate(Connection conn) throws DataException {


  		




  
  192
  
    
    protected Envelope calculateEnvelopeOfColumnWithAggregate(Connection conn) throws DataException {


  		




  187
  193
  
    
        String sql = this.getSQL();


  		




  188
  194
  
    

  		




  189
  195
  
    
        Statement st = null;


  		




  ......




  225
  231
  
    
        }


  		




  226
  232
  
    
    }


  		




  227
  233
  
    

  		




  228
  
  
    
    private Envelope calculateEnvelopeOfColumnWithoutAggregate(Connection conn) throws DataException {


  		




  
  234
  
    
    protected Envelope calculateEnvelopeOfColumnWithoutAggregate(Connection conn) throws DataException {


  		




  229
  235
  
    
//        crear una sql que devuelva un resultarSet


  		




  230
  236
  
    
//bucle


  		




  231
  237
  
    
//        iif instacia de string: cast string


  		












Also available in:  Unified diff