Revision 17343
| trunk/extensions/extJDBC/src/com/iver/cit/gvsig/fmap/drivers/jdbc/mysql/MySql.java | ||
|---|---|---|
| 64 | 64 |
import com.iver.cit.gvsig.fmap.core.IFeature; |
| 65 | 65 |
import com.iver.cit.gvsig.fmap.core.IRow; |
| 66 | 66 |
import com.iver.cit.gvsig.fmap.drivers.DBLayerDefinition; |
| 67 |
import com.iver.cit.gvsig.fmap.drivers.DefaultJDBCDriver; |
|
| 67 | 68 |
import com.iver.cit.gvsig.fmap.drivers.FieldDescription; |
| 68 | 69 |
import com.iver.cit.gvsig.fmap.drivers.XTypes; |
| 69 | 70 |
import com.vividsolutions.jts.io.WKTWriter; |
| ... | ... | |
| 233 | 234 |
}//for |
| 234 | 235 |
sqlBuf.append(" GeometryFromText( '"
|
| 235 | 236 |
+ geometryWriter.write(feat.getGeometry().toJTSGeometry()) + "', " |
| 236 |
+ dbLayerDef.getSRID_EPSG() + ")");
|
|
| 237 |
+ DefaultJDBCDriver.removePrefix(dbLayerDef.getSRID_EPSG()) + ")");
|
|
| 237 | 238 |
sqlBuf.append(" ) ");
|
| 238 | 239 |
sql = sqlBuf.toString(); |
| 239 | 240 |
return sql; |
| ... | ... | |
| 278 | 279 |
sqlBuf.append(" = ");
|
| 279 | 280 |
sqlBuf.append(" GeometryFromText( '"
|
| 280 | 281 |
+ geometryWriter.write(feat.getGeometry().toJTSGeometry()) + "', " |
| 281 |
+ dbLayerDef.getSRID_EPSG() + ")");
|
|
| 282 |
+ DefaultJDBCDriver.removePrefix(dbLayerDef.getSRID_EPSG()) + ")");
|
|
| 282 | 283 |
} |
| 283 | 284 |
sqlBuf.append(" WHERE ");
|
| 284 | 285 |
|
| trunk/extensions/extJDBC/src/com/iver/cit/gvsig/fmap/drivers/jdbc/postgis/PostGIS.java | ||
|---|---|---|
| 55 | 55 |
import com.iver.cit.gvsig.fmap.core.IFeature; |
| 56 | 56 |
import com.iver.cit.gvsig.fmap.core.IRow; |
| 57 | 57 |
import com.iver.cit.gvsig.fmap.drivers.DBLayerDefinition; |
| 58 |
import com.iver.cit.gvsig.fmap.drivers.DefaultJDBCDriver; |
|
| 58 | 59 |
import com.iver.cit.gvsig.fmap.drivers.FieldDescription; |
| 59 | 60 |
import com.iver.cit.gvsig.fmap.drivers.XTypes; |
| 60 | 61 |
|
| ... | ... | |
| 160 | 161 |
+ schema + ", '" |
| 161 | 162 |
+ dbLayerDef.getTableName() + "', '" |
| 162 | 163 |
+ dbLayerDef.getFieldGeometry() + "', " |
| 163 |
+ dbLayerDef.getSRID_EPSG() + ", '" + strGeometryFieldType + "', "
|
|
| 164 |
+ DefaultJDBCDriver.removePrefix(dbLayerDef.getSRID_EPSG()) + ", '" + strGeometryFieldType + "', "
|
|
| 164 | 165 |
+ dbLayerDef.getDimension() + ");"; |
| 165 | 166 |
|
| 166 | 167 |
return result; |
| ... | ... | |
| 254 | 255 |
|
| 255 | 256 |
sqlBuf.append(" GeometryFromText( '"
|
| 256 | 257 |
+ feat.getGeometry().toJTSGeometry().toText() + "', " |
| 257 |
+ dbLayerDef.getSRID_EPSG() + ")");
|
|
| 258 |
+ DefaultJDBCDriver.removePrefix(dbLayerDef.getSRID_EPSG()) + ")");
|
|
| 258 | 259 |
|
| 259 | 260 |
// sqlBuf.deleteCharAt(sqlBuf.lastIndexOf(","));
|
| 260 | 261 |
sqlBuf.append(" ) ");
|
| ... | ... | |
| 306 | 307 |
sqlBuf.append(" = ");
|
| 307 | 308 |
sqlBuf.append(" GeometryFromText( '"
|
| 308 | 309 |
+ feat.getGeometry().toJTSGeometry().toText() + "', " |
| 309 |
+ dbLayerDef.getSRID_EPSG() + ")");
|
|
| 310 |
+ DefaultJDBCDriver.removePrefix(dbLayerDef.getSRID_EPSG()) + ")");
|
|
| 310 | 311 |
} |
| 311 | 312 |
sqlBuf.append(" WHERE ");
|
| 312 | 313 |
sqlBuf.append(dbLayerDef.getFieldID() + " = " + feat.getID()); |
Also available in: Unified diff