root / trunk / libraries / libFMap / src / com / iver / cit / gvsig / fmap / drivers / DefaultDBDriver.java @ 1773
History | View | Annotate | Download (8.34 KB)
1 | 1691 | 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 | package com.iver.cit.gvsig.fmap.drivers; |
||
42 | |||
43 | import java.awt.geom.Rectangle2D; |
||
44 | import java.io.IOException; |
||
45 | import java.sql.Connection; |
||
46 | import java.sql.ResultSet; |
||
47 | import java.sql.ResultSetMetaData; |
||
48 | import java.sql.SQLException; |
||
49 | import java.sql.Statement; |
||
50 | import java.sql.Types; |
||
51 | import java.util.Date; |
||
52 | |||
53 | import org.postgis.Geometry; |
||
54 | import org.postgis.PGbox3d; |
||
55 | import org.postgis.Point; |
||
56 | |||
57 | import com.hardcode.gdbms.engine.data.DataSource; |
||
58 | import com.hardcode.gdbms.engine.data.ReadDriver; |
||
59 | import com.hardcode.gdbms.engine.values.Value; |
||
60 | import com.hardcode.gdbms.engine.values.ValueFactory; |
||
61 | import com.iver.cit.gvsig.fmap.DriverException; |
||
62 | import com.iver.cit.gvsig.fmap.core.FShape; |
||
63 | import com.iver.cit.gvsig.fmap.core.IGeometry; |
||
64 | 1693 | fjp | import com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.WKTParser; |
65 | 1691 | fjp | import com.vividsolutions.jts.io.ParseException; |
66 | |||
67 | |||
68 | |||
69 | /**
|
||
70 | * Clase abstracta qu
|
||
71 | */
|
||
72 | public abstract class DefaultDBDriver implements VectorialDatabaseDriver, ReadDriver { |
||
73 | /**
|
||
74 | *
|
||
75 | */
|
||
76 | protected Connection conn; |
||
77 | protected String tableName; |
||
78 | protected String whereClause; |
||
79 | protected String fields; |
||
80 | protected String sqlOrig; |
||
81 | protected ResultSet rs; |
||
82 | protected int numReg=-1; |
||
83 | |||
84 | protected ResultSetMetaData metaData = null; |
||
85 | |||
86 | /**
|
||
87 | * @return devuelve la Conexi?n a la base de datos, para que
|
||
88 | * el usuario pueda hacer la consulta que quiera, si lo desea.
|
||
89 | * Por ejemplo, esto puede ser ?til para abrir un cuadro de dialogo
|
||
90 | * avanazado y lanzar peticiones del tipo "Devuelveme un buffer
|
||
91 | * a las autopistas", y con el resultset que te venga, escribir
|
||
92 | * un shape, o cosas as?.
|
||
93 | */
|
||
94 | public Connection getConnection() |
||
95 | { |
||
96 | return conn;
|
||
97 | } |
||
98 | public String getFields() |
||
99 | { |
||
100 | return fields;
|
||
101 | } |
||
102 | public String getWhereClause() |
||
103 | { |
||
104 | return whereClause;
|
||
105 | } |
||
106 | public String getTableName() |
||
107 | { |
||
108 | return tableName;
|
||
109 | } |
||
110 | |||
111 | |||
112 | /**
|
||
113 | * @throws DriverIOException
|
||
114 | * @throws DriverException
|
||
115 | * @see com.iver.cit.gvsig.fmap.layers.ReadableVectorial#getShapeCount()
|
||
116 | */
|
||
117 | public int getShapeCount() throws IOException { |
||
118 | if (numReg == -1) |
||
119 | { |
||
120 | try
|
||
121 | { |
||
122 | Statement s = conn.createStatement();
|
||
123 | ResultSet r = s.executeQuery("SELECT COUNT(*) AS NUMREG FROM " + tableName + " " + whereClause); |
||
124 | r.next(); |
||
125 | numReg = r.getInt(1);
|
||
126 | System.err.println("numReg = " + numReg); |
||
127 | } |
||
128 | catch (SQLException e) |
||
129 | { |
||
130 | throw new IOException(e.getMessage()); |
||
131 | } |
||
132 | } |
||
133 | |||
134 | return numReg;
|
||
135 | } |
||
136 | |||
137 | |||
138 | |||
139 | /**
|
||
140 | * @see com.iver.cit.gvsig.fmap.layers.ReadableVectorial#getShapeType()
|
||
141 | */
|
||
142 | public int getShapeType() { |
||
143 | return FShape.MULTI;
|
||
144 | } |
||
145 | |||
146 | 1773 | fernando | public int getFieldType(int idField) throws com.hardcode.gdbms.engine.data.DriverException |
147 | 1691 | fjp | { |
148 | String str = ""; |
||
149 | try {
|
||
150 | int i = idField + 2; // idField viene basado en 1, y |
||
151 | // adem?s nos saltamos el campo de geometry
|
||
152 | str = metaData.getColumnClassName(i); |
||
153 | if (metaData.getColumnType(i) == Types.VARCHAR) |
||
154 | 1773 | fernando | return Types.VARCHAR; |
155 | 1691 | fjp | if (metaData.getColumnType(i) == Types.FLOAT) |
156 | 1773 | fernando | return Types.FLOAT; |
157 | 1691 | fjp | if (metaData.getColumnType(i) == Types.DOUBLE) |
158 | 1773 | fernando | return Types.DOUBLE; |
159 | 1691 | fjp | if (metaData.getColumnType(i) == Types.INTEGER) |
160 | 1773 | fernando | return Types.INTEGER; |
161 | 1691 | fjp | if (metaData.getColumnType(i) == Types.BIGINT) |
162 | 1773 | fernando | return Types.BIGINT; |
163 | 1691 | fjp | if (metaData.getColumnType(i) == Types.BIT) |
164 | 1773 | fernando | return Types.BIT; |
165 | 1691 | fjp | if (metaData.getColumnType(i) == Types.DATE) |
166 | 1773 | fernando | return Types.DATE; |
167 | 1691 | fjp | } catch (SQLException e) { |
168 | 1773 | fernando | throw new com.hardcode.gdbms.engine.data.DriverException(e); |
169 | 1691 | fjp | } |
170 | 1773 | fernando | throw new com.hardcode.gdbms.engine.data.DriverException("Tipo no soportado: " + str); |
171 | 1691 | fjp | } |
172 | /**
|
||
173 | * Obtiene el valor que se encuentra en la fila y columna indicada
|
||
174 | * Esta es la implementaci?n por defecto. Si lo del absolute
|
||
175 | * no va bien, como es el caso del PostGis, el driver lo
|
||
176 | * tiene que reimplementar
|
||
177 | *
|
||
178 | * @param rowIndex fila
|
||
179 | * @param fieldId columna
|
||
180 | *
|
||
181 | * @return subclase de Value con el valor del origen de datos
|
||
182 | *
|
||
183 | * @throws DriverException Si se produce un error accediendo al DataSource
|
||
184 | */
|
||
185 | public Value getFieldValue(long rowIndex, int idField) |
||
186 | throws com.hardcode.gdbms.engine.data.DriverException
|
||
187 | { |
||
188 | int i = (int) (rowIndex + 1); |
||
189 | int fieldId = idField+2; |
||
190 | try {
|
||
191 | rs.absolute(i); |
||
192 | if (metaData.getColumnType(fieldId) == Types.VARCHAR) |
||
193 | return ValueFactory.createValue(rs.getString(fieldId));
|
||
194 | if (metaData.getColumnType(fieldId) == Types.FLOAT) |
||
195 | return ValueFactory.createValue(rs.getFloat(fieldId));
|
||
196 | if (metaData.getColumnType(fieldId) == Types.DOUBLE) |
||
197 | return ValueFactory.createValue(rs.getDouble(fieldId));
|
||
198 | if (metaData.getColumnType(fieldId) == Types.INTEGER) |
||
199 | return ValueFactory.createValue(rs.getInt(fieldId));
|
||
200 | if (metaData.getColumnType(fieldId) == Types.BIGINT) |
||
201 | return ValueFactory.createValue(rs.getLong(fieldId));
|
||
202 | if (metaData.getColumnType(fieldId) == Types.BIT) |
||
203 | return ValueFactory.createValue(rs.getBoolean(fieldId));
|
||
204 | if (metaData.getColumnType(fieldId) == Types.DATE) |
||
205 | return ValueFactory.createValue(rs.getDate(fieldId));
|
||
206 | } catch (SQLException e) { |
||
207 | throw new com.hardcode.gdbms.engine.data.DriverException("Tipo no soportado: columna " + fieldId ); |
||
208 | } |
||
209 | return null; |
||
210 | |||
211 | |||
212 | } |
||
213 | |||
214 | /**
|
||
215 | * Obtiene el n?mero de campos del DataSource
|
||
216 | *
|
||
217 | * @return
|
||
218 | *
|
||
219 | * @throws DriverException Si se produce alg?n error accediendo al
|
||
220 | * DataSource
|
||
221 | */
|
||
222 | public int getFieldCount() throws com.hardcode.gdbms.engine.data.DriverException |
||
223 | { |
||
224 | try {
|
||
225 | // Suponemos que el primer campo es el de las geometries, y no lo
|
||
226 | // contamos
|
||
227 | return rs.getMetaData().getColumnCount()-1; |
||
228 | } catch (SQLException e) { |
||
229 | throw new com.hardcode.gdbms.engine.data.DriverException(e); |
||
230 | } |
||
231 | |||
232 | } |
||
233 | |||
234 | /**
|
||
235 | * Devuelve el nombre del campo fieldId-?simo
|
||
236 | *
|
||
237 | * @param fieldId ?ndice del campo cuyo nombre se quiere obtener
|
||
238 | *
|
||
239 | * @return
|
||
240 | * @throws com.hardcode.gdbms.engine.data.DriverException
|
||
241 | *
|
||
242 | * @throws DriverException Si se produce alg?n error accediendo al
|
||
243 | * DataSource
|
||
244 | */
|
||
245 | public String getFieldName(int fieldId) throws com.hardcode.gdbms.engine.data.DriverException |
||
246 | { |
||
247 | try {
|
||
248 | return rs.getMetaData().getColumnName(fieldId+2); |
||
249 | } catch (SQLException e) { |
||
250 | throw new com.hardcode.gdbms.engine.data.DriverException(e); |
||
251 | } |
||
252 | } |
||
253 | |||
254 | /**
|
||
255 | * Obtiene el n?mero de registros del DataSource
|
||
256 | *
|
||
257 | * @return
|
||
258 | *
|
||
259 | * @throws DriverException Si se produce alg?n error accediendo al
|
||
260 | * DataSource
|
||
261 | */
|
||
262 | public long getRowCount() |
||
263 | { |
||
264 | try {
|
||
265 | return getShapeCount();
|
||
266 | } catch (IOException e) { |
||
267 | // TODO Auto-generated catch block
|
||
268 | e.printStackTrace(); |
||
269 | } |
||
270 | return -1; |
||
271 | } |
||
272 | |||
273 | |||
274 | } |