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
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