Revision 47606 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.sqlite/org.gvsig.sqlite.provider/src/main/java/org/gvsig/sqlite/dal/geopackage/index/AbstractGeopackageIndex.java

View differences:

AbstractGeopackageIndex.java
39 39 
        Statement st = null;
40 40 
        ResultSet rs = null;
41 41 
        try {
42 
            st = conn.createStatement();
42 
            st = conn.createStatement(sql);
43 43 
            rs = JDBCUtils.executeQuery(st, sql);
44 44 
            if( !rs.next() ) {
45 45 
                return false;
......
76 76 

  		




  77
  77
  
    
    @Override


  		




  78
  78
  
    
    public String getBBoxIntersectsFilter(String tablename, String fieldnameid, String fieldnamegeom, String minX, String minY, String maxX, String maxY) {


  		




  79
  
  
    
        String sql = TemplateUtils.getSqlTemplate(getGroup(), "bboxintersects", tablename, fieldnameid, minX, minY, maxX, maxY);


  		




  
  79
  
    
        String sql = TemplateUtils.getSqlTemplate(getGroup(), "bboxintersects", tablename, fieldnameid, fieldnamegeom, minX, minY, maxX, maxY);


  		




  80
  80
  
    
        return sql;


  		




  81
  81
  
    
    }


  		




  82
  82
  
    

  		




  ......




  115
  115
  
    
        Statement st = null;


  		




  116
  116
  
    
        ResultSet rs = null;


  		




  117
  117
  
    
        try {


  		




  118
  
  
    
            st = conn.createStatement();


  		




  
  118
  
    
            st = conn.createStatement(sql);


  		




  119
  119
  
    
            rs = JDBCUtils.executeQuery(st, sql);


  		




  120
  120
  
    
            if( !rs.next() ) {


  		




  121
  121
  
    
                return null;


  		




  122
  122
  
    
            }


  		




  123
  
  
    
            int minx = rs.getInt("minx");


  		




  124
  
  
    
            int miny = rs.getInt("miny");


  		




  125
  
  
    
            int maxx = rs.getInt("maxx");


  		




  126
  
  
    
            int maxy = rs.getInt("maxy");


  		




  
  123
  
    
            if(rs.getInt("rows")==0) {


  		




  
  124
  
    
                return null;


  		




  
  125
  
    
            }


  		




  
  126
  
    
            double minx = rs.getDouble("minx");


  		




  
  127
  
    
            double miny = rs.getDouble("miny");


  		




  
  128
  
    
            double maxx = rs.getDouble("maxx");


  		




  
  129
  
    
            double maxy = rs.getDouble("maxy");


  		




  127
  130
  
    
            GeometryManager geommanager = GeometryLocator.getGeometryManager();


  		




  128
  131
  
    
            Envelope env = geommanager.createEnvelope(minx, miny, maxx, maxy, Geometry.SUBTYPES.GEOM2D);


  		




  129
  132
  
    
            return env;


  		












Also available in:  Unified diff