svn-gvsig-desktop / trunk / libraries / libFMap / src / com / iver / cit / gvsig / fmap / layers / VectorialDBAdapter.java @ 12043
History | View | Annotate | Download (7.3 KB)
1 | 1100 | fjp | /* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana
|
---|---|---|---|
2 | *
|
||
3 | * Copyright (C) 2004 IVER T.I. and Generalitat Valenciana.
|
||
4 | *
|
||
5 | * This program is free software; you can redistribute it and/or
|
||
6 | * modify it under the terms of the GNU General Public License
|
||
7 | * as published by the Free Software Foundation; either version 2
|
||
8 | * of the License, or (at your option) any later version.
|
||
9 | *
|
||
10 | * This program is distributed in the hope that it will be useful,
|
||
11 | * but WITHOUT ANY WARRANTY; without even the implied warranty of
|
||
12 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
||
13 | * GNU General Public License for more details.
|
||
14 | *
|
||
15 | * You should have received a copy of the GNU General Public License
|
||
16 | * along with this program; if not, write to the Free Software
|
||
17 | * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307,USA.
|
||
18 | *
|
||
19 | * For more information, contact:
|
||
20 | *
|
||
21 | * Generalitat Valenciana
|
||
22 | * Conselleria d'Infraestructures i Transport
|
||
23 | * Av. Blasco Ib??ez, 50
|
||
24 | * 46010 VALENCIA
|
||
25 | * SPAIN
|
||
26 | *
|
||
27 | * +34 963862235
|
||
28 | * gvsig@gva.es
|
||
29 | * www.gvsig.gva.es
|
||
30 | *
|
||
31 | * or
|
||
32 | *
|
||
33 | * IVER T.I. S.A
|
||
34 | * Salamanca 50
|
||
35 | * 46005 Valencia
|
||
36 | * Spain
|
||
37 | *
|
||
38 | * +34 963163400
|
||
39 | * dac@iver.es
|
||
40 | */
|
||
41 | 214 | fernando | package com.iver.cit.gvsig.fmap.layers; |
42 | |||
43 | 1691 | fjp | import java.awt.geom.Rectangle2D; |
44 | |||
45 | 11287 | azabala | import org.cresques.cts.IProjection; |
46 | |||
47 | 1691 | fjp | import com.hardcode.driverManager.DriverLoadException; |
48 | 10627 | caballero | import com.hardcode.gdbms.driver.exceptions.ReadDriverException; |
49 | 1034 | vcaballero | import com.hardcode.gdbms.engine.data.DataSource; |
50 | 1691 | fjp | import com.hardcode.gdbms.engine.data.DataSourceFactory; |
51 | import com.hardcode.gdbms.engine.data.NoSuchTableException; |
||
52 | 1828 | fernando | import com.hardcode.gdbms.engine.data.driver.ObjectDriver; |
53 | 3248 | fjp | import com.hardcode.gdbms.engine.values.Value; |
54 | import com.iver.cit.gvsig.fmap.core.DefaultFeature; |
||
55 | import com.iver.cit.gvsig.fmap.core.IFeature; |
||
56 | 305 | fjp | import com.iver.cit.gvsig.fmap.core.IGeometry; |
57 | 3268 | fjp | import com.iver.cit.gvsig.fmap.drivers.DBLayerDefinition; |
58 | 2183 | fernando | import com.iver.cit.gvsig.fmap.drivers.IFeatureIterator; |
59 | 11971 | caballero | import com.iver.cit.gvsig.fmap.drivers.IVectorialDatabaseDriver; |
60 | 214 | fernando | |
61 | 1034 | vcaballero | |
62 | |||
63 | 214 | fernando | /**
|
64 | 1034 | vcaballero | * Adapta un driver de base de datos vectorial a la interfaz vectorial,
|
65 | * manteniendo adem?s el estado necesario por una capa vectorial de base de
|
||
66 | * datos (par?metros de la conexi?n)
|
||
67 | 214 | fernando | */
|
68 | 4171 | fjp | public class VectorialDBAdapter extends VectorialAdapter implements ISpatialDB { |
69 | 1691 | fjp | private int numReg=-1; |
70 | 3959 | caballero | private SelectableDataSource ds = null; |
71 | 1034 | vcaballero | /**
|
72 | * incrementa el contador de las veces que se ha abierto el fichero.
|
||
73 | * Solamente cuando el contador est? a cero pide al driver que conecte con
|
||
74 | * la base de datos
|
||
75 | */
|
||
76 | 10627 | caballero | public void start() throws ReadDriverException { |
77 | 11971 | caballero | ((IVectorialDatabaseDriver)driver).open(); |
78 | 10627 | caballero | } |
79 | 214 | fernando | |
80 | 1034 | vcaballero | /**
|
81 | * decrementa el contador de n?mero de aperturas y cuando llega a cero pide
|
||
82 | * al driver que cierre la conexion con el servidor de base de datos
|
||
83 | */
|
||
84 | 10627 | caballero | public void stop() throws ReadDriverException { |
85 | 11971 | caballero | ((IVectorialDatabaseDriver)driver).close(); |
86 | 1034 | vcaballero | } |
87 | 214 | fernando | |
88 | 4171 | fjp | /* (non-Javadoc)
|
89 | * @see com.iver.cit.gvsig.fmap.layers.ISpatialDB#getFeatureIterator(java.awt.geom.Rectangle2D, java.lang.String)
|
||
90 | 1034 | vcaballero | */
|
91 | 2183 | fernando | /* public Connection getConnection()
|
92 | 1691 | fjp | {
|
93 | return ((VectorialDatabaseDriver)driver).getConnection();
|
||
94 | 2183 | fernando | }*/
|
95 | /* public IFeatureIterator getFeatureIterator(String sql) throws DriverException
|
||
96 | 1693 | fjp | {
|
97 | 2183 | fernando | return ((VectorialDatabaseDriver)driver).getFeatureIterator(sql);
|
98 | }*/
|
||
99 | 10627 | caballero | public IFeatureIterator getFeatureIterator(Rectangle2D r, String strEPSG) throws ReadDriverException |
100 | 2183 | fernando | { |
101 | 11971 | caballero | return ((IVectorialDatabaseDriver)driver).getFeatureIterator(r, strEPSG);
|
102 | 1693 | fjp | } |
103 | 3959 | caballero | |
104 | 4171 | fjp | /* (non-Javadoc)
|
105 | * @see com.iver.cit.gvsig.fmap.layers.ISpatialDB#getFeatureIterator(java.awt.geom.Rectangle2D, java.lang.String, java.lang.String[])
|
||
106 | */
|
||
107 | 10627 | caballero | public IFeatureIterator getFeatureIterator(Rectangle2D r, String strEPSG, String[] alphaNumericFieldsNeeded) throws ReadDriverException |
108 | 3268 | fjp | { |
109 | 11971 | caballero | return ((IVectorialDatabaseDriver)driver).getFeatureIterator(r, strEPSG, alphaNumericFieldsNeeded);
|
110 | 3268 | fjp | } |
111 | 3959 | caballero | |
112 | 11287 | azabala | |
113 | /**
|
||
114 | * Overwrites the policy of VectorialAdapter because databases dont have external
|
||
115 | * spatial indices (spatial index is internal to the database)
|
||
116 | * */
|
||
117 | 11971 | caballero | public IFeatureIterator getFeatureIterator(Rectangle2D rect, |
118 | String[] fields, |
||
119 | 11881 | azabala | IProjection newProjection, |
120 | boolean fastIterator) throws ReadDriverException{ |
||
121 | //TODO ver como incluir el concepto de fastIteration en bbdd
|
||
122 | //TODO Est? delegando la reproyecci?n en la bbdd, mientras que los drivers
|
||
123 | //de extJdbc no reproyecta ninguno
|
||
124 | 11287 | azabala | return getFeatureIterator(rect, newProjection.getAbrev(), fields);
|
125 | } |
||
126 | 11971 | caballero | |
127 | 4171 | fjp | /* (non-Javadoc)
|
128 | * @see com.iver.cit.gvsig.fmap.layers.ISpatialDB#getFields()
|
||
129 | */
|
||
130 | 2183 | fernando | public String[] getFields() |
131 | 1691 | fjp | { |
132 | 11971 | caballero | return ((IVectorialDatabaseDriver)driver).getFields();
|
133 | 1691 | fjp | } |
134 | 4171 | fjp | /* (non-Javadoc)
|
135 | * @see com.iver.cit.gvsig.fmap.layers.ISpatialDB#getWhereClause()
|
||
136 | */
|
||
137 | 1691 | fjp | public String getWhereClause() |
138 | { |
||
139 | 11971 | caballero | return ((IVectorialDatabaseDriver)driver).getWhereClause();
|
140 | 1691 | fjp | } |
141 | 4171 | fjp | /* (non-Javadoc)
|
142 | * @see com.iver.cit.gvsig.fmap.layers.ISpatialDB#getTableName()
|
||
143 | */
|
||
144 | 1691 | fjp | public String getTableName() |
145 | { |
||
146 | 11971 | caballero | return ((IVectorialDatabaseDriver)driver).getTableName();
|
147 | 1691 | fjp | } |
148 | 3959 | caballero | |
149 | |||
150 | 214 | fernando | /**
|
151 | * @see com.iver.cit.gvsig.fmap.layers.ReadableVectorial#getShape(int)
|
||
152 | */
|
||
153 | 10627 | caballero | public IGeometry getShape(int index) throws ReadDriverException { |
154 | 1691 | fjp | IGeometry geom = null;
|
155 | 11971 | caballero | geom = ((IVectorialDatabaseDriver)driver).getShape(index); |
156 | 10627 | caballero | return geom;
|
157 | 214 | fernando | } |
158 | |||
159 | /**
|
||
160 | 369 | fernando | * @see com.iver.cit.gvsig.fmap.layers.ReadableVectorial#getShapeType()
|
161 | */
|
||
162 | 10627 | caballero | public int getShapeType() throws ReadDriverException { |
163 | 11971 | caballero | return ((IVectorialDatabaseDriver)driver).getShapeType();
|
164 | 369 | fernando | } |
165 | 408 | fernando | |
166 | /**
|
||
167 | 10627 | caballero | * @throws ReadDriverException
|
168 | 408 | fernando | * @see com.iver.cit.gvsig.fmap.layers.VectorialAdapter#getRecordset()
|
169 | */
|
||
170 | 10665 | caballero | public SelectableDataSource getRecordset() throws ReadDriverException { |
171 | 1828 | fernando | if (driver instanceof ObjectDriver) |
172 | 1691 | fjp | { |
173 | 3207 | fjp | if (ds == null) |
174 | { |
||
175 | String name = LayerFactory.getDataSourceFactory().addDataSource((ObjectDriver)driver);
|
||
176 | try {
|
||
177 | 3959 | caballero | ds = new SelectableDataSource(LayerFactory.getDataSourceFactory().createRandomDataSource(name, DataSourceFactory.AUTOMATIC_OPENING));
|
178 | 3207 | fjp | } catch (NoSuchTableException e) {
|
179 | throw new RuntimeException(e); |
||
180 | 10665 | caballero | } catch (DriverLoadException e) {
|
181 | throw new ReadDriverException(name,e); |
||
182 | } |
||
183 | 3959 | caballero | } |
184 | 1691 | fjp | } |
185 | return ds;
|
||
186 | 408 | fernando | } |
187 | 546 | fernando | |
188 | 3268 | fjp | /* (non-Javadoc)
|
189 | * @see com.iver.cit.gvsig.fmap.layers.VectorialAdapter#getFeature(int)
|
||
190 | */
|
||
191 | 10627 | caballero | public IFeature getFeature(int numReg) throws ReadDriverException { |
192 | 3268 | fjp | IGeometry geom; |
193 | IFeature feat = null;
|
||
194 | 10665 | caballero | geom = getShape(numReg); |
195 | DataSource rs = getRecordset();
|
||
196 | int idFieldID = getLyrDef().getIdFieldID();
|
||
197 | Value[] regAtt = new Value[rs.getFieldCount()]; |
||
198 | String theID = null; |
||
199 | for (int fieldId=0; fieldId < rs.getFieldCount(); fieldId++ ) |
||
200 | { |
||
201 | regAtt[fieldId] = rs.getFieldValue(numReg, fieldId); |
||
202 | if (fieldId == idFieldID)
|
||
203 | theID = regAtt[fieldId].toString(); |
||
204 | 3268 | fjp | } |
205 | 10665 | caballero | feat = new DefaultFeature(geom, regAtt, theID);
|
206 | 3268 | fjp | return feat;
|
207 | } |
||
208 | |||
209 | 4171 | fjp | /* (non-Javadoc)
|
210 | * @see com.iver.cit.gvsig.fmap.layers.ISpatialDB#getLyrDef()
|
||
211 | */
|
||
212 | 3268 | fjp | public DBLayerDefinition getLyrDef()
|
213 | { |
||
214 | 11971 | caballero | return ((IVectorialDatabaseDriver)driver).getLyrDef();
|
215 | 3268 | fjp | } |
216 | 4181 | fjp | |
217 | public int getRowIndexByFID(IFeature feat) { |
||
218 | 11971 | caballero | return ((IVectorialDatabaseDriver) driver).getRowIndexByFID(feat);
|
219 | 4181 | fjp | } |
220 | 214 | fernando | } |