| gvSIG desktop 1

package es.idr.test;

import java.io.BufferedWriter;

import java.io.FileWriter;

import java.io.IOException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import javax.units.ConversionException;

import org.geotools.referencing.factory.epsg.HSQLDataSource;

import org.geotools.referencing.wkt.UnformattableObjectException;

import org.gvsig.crs.Crs;

import org.gvsig.crs.CrsException;

import org.gvsig.crs.Proj4;

import org.opengis.referencing.NoSuchAuthorityCodeException;

public class TestWKTandProj4Epsg {

        public static void main(String[] args) {

                HSQLDataSource ds = new HSQLDataSource();

                Connection conn;

                try {

                        conn = ds.getConnection();

                        int indice = 0;

                        int fallo = 0;

                        final PreparedStatement stmt;

                stmt = conn.prepareStatement("SELECT COORD_REF_SYS_CODE, COORD_REF_SYS_NAME"

                                              + " FROM epsg_coordinatereferencesystem");

                ResultSet result;

                        result = stmt.executeQuery();

                ArrayList wkt = new ArrayList();

                ArrayList proj4 = new ArrayList();

                ArrayList name = new ArrayList();

                ArrayList codigo = new ArrayList();

                ArrayList fallos = new ArrayList();

                while (result.next()) {

                        wkt.add(indice,"");

                                proj4.add(indice,"");                                

                                fallos.add(indice,"");

                        int cod = result.getInt("COORD_REF_SYS_CODE");

                        codigo.add(indice,String.valueOf(cod));

                        name.add(indice,result.getString("COORD_REF_SYS_NAME"));

                        try {

                                        Crs crs = new Crs(cod,1);

                                        wkt.add(indice,crs.getWKT());

                                        Proj4 proj= new Proj4();                                        

                                        proj4.add(indice,proj.exportToProj4(crs));

                                        fallos.add(indice,"No falla");

                                } catch (CrsException e) {

                                        // TODO Auto-generated catch block

                                        //e.printStackTrace();

                                        fallos.add(indice,""+cod+": "+e);

                                        proj4.add(indice, "No cadena proj4");

                                        fallo++;

                                } catch (NumberFormatException e) {

                                        // TODO Auto-generated catch block

                                        //e.printStackTrace();

                                        fallos.add(indice,""+cod+": "+e);

                                        proj4.add(indice, "No cadena proj4");

                                        fallo++;

                                } catch (ConversionException e) {

                                        // TODO Auto-generated catch block

                                        //e.printStackTrace();

                                        fallos.add(indice,""+cod+": "+e);

                                        proj4.add(indice, "No cadena proj4");

                                        fallo++;

                                }catch (UnformattableObjectException e) {

                                        // TODO Auto-generated catch block

                                        //e.printStackTrace();

                                        fallos.add(indice,""+cod+": "+e);

                                        proj4.add(indice, "No cadena proj4");

                                        fallo++;

                                } 

                                indice++;

                }

                String filename = "salida.txt";

                try

                { // opens try

                  BufferedWriter bw =  new BufferedWriter(new FileWriter(filename));

                      for (int i = 0; i< codigo.size(); i++) {

                        bw.write("C?digo: "+codigo.get(i)+"\tNombre: "+name.get(i)+"\n");

                        bw.write("Cadena WKT: "+wkt.get(i)+"\n");

                        bw.write("Cadena Proj4: "+proj4.get(i)+"\n");

                        bw.write("Fallo:"+fallos.get(i)+"\n");

                        bw.write("\n\n");

                }        

                /*for (int i = 0; i< fallos.size(); i++) {                        

                }*/        

                      bw.write("Numero CRSs: " + codigo.size()+"\n");        

                      bw.write("Numero fallos: " + fallo+"\n");

                bw.flush();

                bw.close();

                } // closes try

                       catch (IOException ioe) { // open catch

                       }// close catch

                } catch (SQLException e1) {

                        // TODO Auto-generated catch block

                        e1.printStackTrace();

                }        

        }

}