root / org.gvsig.projection.jcrs / trunk / org.gvsig.projection.jcrs / org.gvsig.projection.jcrs.lib / src / main / java / org / gvsig / crs / repository / NoAuthRepository.java @ 229
History | View | Annotate | Download (3.35 KB)
1 | 147 | jjdelcerro | /* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana
|
---|---|---|---|
2 | *
|
||
3 | * Copyright (C) 2006 Instituto de Desarrollo Regional 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 | * Instituto de Desarrollo Regional (Universidad de Castilla La-Mancha
|
||
34 | * Campus Universitario s/n
|
||
35 | * 02071 Alabacete
|
||
36 | * Spain
|
||
37 | *
|
||
38 | * +34 967 599 200
|
||
39 | */
|
||
40 | package org.gvsig.crs.repository; |
||
41 | |||
42 | import java.sql.ResultSet; |
||
43 | import java.sql.SQLException; |
||
44 | |||
45 | import org.gvsig.crs.Crs; |
||
46 | import org.gvsig.crs.CrsException; |
||
47 | import org.gvsig.crs.ICrs; |
||
48 | import org.slf4j.Logger; |
||
49 | import org.slf4j.LoggerFactory; |
||
50 | |||
51 | import es.idr.teledeteccion.connection.EpsgConnection; |
||
52 | import es.idr.teledeteccion.connection.Query; |
||
53 | 229 | jjdelcerro | import org.gvsig.tools.dispose.Disposable; |
54 | 147 | jjdelcerro | |
55 | /**
|
||
56 | * Repository for CRS without Auth, for example CRS:84
|
||
57 | * @author jldominguez
|
||
58 | *
|
||
59 | */
|
||
60 | 229 | jjdelcerro | public class NoAuthRepository implements ICrsRepository, Disposable { |
61 | 147 | jjdelcerro | private static final Logger logger = |
62 | LoggerFactory.getLogger(NoAuthRepository.class); |
||
63 | |||
64 | EpsgConnection connection = null;
|
||
65 | |||
66 | public NoAuthRepository() {
|
||
67 | connection = new EpsgConnection();
|
||
68 | connection.setConnectionNoAuth(); |
||
69 | } |
||
70 | |||
71 | public ICrs getCrs(String code) { |
||
72 | String cadWKT = ""; |
||
73 | Crs crs = null;
|
||
74 | |||
75 | String sentence = "SELECT crs_code, crs_wkt, crs_proj, crs_geog, crs_datum " + |
||
76 | "FROM NOAUTHCRS " +
|
||
77 | "WHERE crs_code = " + code;
|
||
78 | |||
79 | ResultSet result = Query.select(sentence,connection.getConnection()); |
||
80 | /*try {
|
||
81 | connection.shutdown();
|
||
82 | } catch (SQLException e) {
|
||
83 | // TODO Auto-generated catch block
|
||
84 | logger....
|
||
85 | }*/
|
||
86 | try {
|
||
87 | if (!result.next())
|
||
88 | return null; |
||
89 | cadWKT = result.getString("crs_wkt");
|
||
90 | } catch (SQLException e1) { |
||
91 | logger.info("Error executing the SQL", e1);
|
||
92 | return null; |
||
93 | } |
||
94 | cadWKT = cadWKT.substring(0, cadWKT.length()-1) |
||
95 | + ", AUTHORITY[\"CRS\","+ Integer.parseInt(code)+"]]"; |
||
96 | |||
97 | try {
|
||
98 | crs = new Crs(Integer.parseInt(code),cadWKT); |
||
99 | } catch (CrsException e) {
|
||
100 | logger.info("Impossible to parse the CRS", e);
|
||
101 | } |
||
102 | |||
103 | return crs;
|
||
104 | |||
105 | } |
||
106 | |||
107 | 229 | jjdelcerro | |
108 | public void dispose() { |
||
109 | try {
|
||
110 | this.connection.shutdown();
|
||
111 | this.connection = null; |
||
112 | } catch (SQLException ex) { |
||
113 | logger.warn("Con't shutdown the connection.",ex);
|
||
114 | } |
||
115 | } |
||
116 | 147 | jjdelcerro | } |