Application: gvSIG desktop » gvSIG projections

package org.gvsig.crs.repository;

import java.sql.ResultSet;

import java.sql.SQLException;

import es.idr.teledeteccion.connection.EpsgConnection;

import es.idr.teledeteccion.connection.Query;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.gvsig.crs.Crs;

import org.gvsig.crs.CrsException;

import org.gvsig.crs.ICrs;

public class UsrRepository implements ICrsRepository {

    private static final Logger LOG =

        LoggerFactory.getLogger(UsrRepository.class);

        EpsgConnection connection;

        public UsrRepository() {

                super();

                connection = new EpsgConnection();                

        }

        public ICrs getCrs(String code) {

                // TODO Auto-generated method stub

                String cadWKT = "";

                Crs crs = null;

                String sentence = "SELECT usr_code, usr_wkt, usr_proj, usr_geog, usr_datum " +                                                         

                                                  "FROM USR " +                                      

                          "WHERE usr_code = " + code;

                connection.setConnectionUsr();

                ResultSet result = Query.select(sentence,connection.getConnection());        

                try {

                        connection.shutdown();

                } catch (SQLException e) {

                    LOG.error("Error executing the SQL", e);

                }

                try {

                        if (!result.next())

                                return null;                

                        cadWKT = result.getString("usr_wkt");                        

                } catch (SQLException e1) {

                        e1.printStackTrace();

                }                

                cadWKT = cadWKT.substring(0, cadWKT.length()-1) + ", AUTHORITY[\"USR\","+ Integer.parseInt(code)+"]]";

                try {

                        crs = new Crs(Integer.parseInt(code),cadWKT);

                } catch (CrsException e) {

                    LOG.error("Impossible to parse the CRS", e);

                }

                return crs;                

        }

}