| gvSIG desktop 1

	        ArrayList validos = new ArrayList();

						validos.add(String.valueOf(cod));

	        System.out.println("Numero CRSs validos: " + validos.size());

package es.idr.test.connection;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

public class UsrConnection {

	Connection connect;

	public UsrConnection() {

		try {

			Class.forName("org.hsqldb.jdbcDriver");

		} catch (ClassNotFoundException e) {

			e.printStackTrace();

		}

		try {			

			connect =  DriverManager.getConnection("jdbc:hsqldb:file:/home/jlgomez/gvSIGF2/crsTest/usr", "sa", "");			

		} catch (SQLException e1) {

			e1.printStackTrace();

		}

	}

	public Connection getConnection(){

		return connect;

	}

	public void shutdown() throws SQLException {

        Statement st = connect.createStatement();

        // db writes out to files and performs clean shuts down

        // otherwise there will be an unclean shutdown

        // when program ends

        st.execute("SHUTDOWN");

        connect.close();    // if there are no other open connection

    }

	public synchronized void update(String expression) throws SQLException {

        Statement st = null;

        st = connect.createStatement();    // statements

        int i = st.executeUpdate(expression);    // run the query

        if (i == -1) {

            System.out.println("db error : " + expression);

        }

        st.close();

    }    

}

	        ArrayList validos = new ArrayList();

						validos.add(String.valueOf(cod));

	        System.out.println("Numero CRSs validos: " + validos.size());

package es.idr.test;

import java.sql.ResultSet;

import java.sql.SQLException;

import org.gvsig.crs.Query;

import es.idr.test.connection.UsrConnection;

public class InsertUserDataCrs {

	/**

	 * @param args

	 */

	public static void main(String[] args) {

		// TODO Auto-generated method stub

		UsrConnection conn = new UsrConnection();

		String sentence = "INSERT INTO USR VALUES(2000,'PROJCS[\"Anguilla_1957_British_West_Indies_Grid\",GEOGCS[\"GCS_Anguilla_1957\",DATUM[\"D_Anguilla_1957\",SPHEROID[\"Clarke_1880_RGS\",6378249.145,293.465]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Transverse_Mercator\"],PARAMETER[\"False_Easting\",400000.0],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",-62.0],PARAMETER[\"Scale_Factor\",0.9995],PARAMETER[\"Latitude_Of_Origin\",0.0],UNIT[\"Meter\",1.0]]','Anguilla_1957_British_West_Indies_Grid','GCS_Anguilla_1957','D_Anguilla_1957')";

		try {

			conn.update(sentence);			

			conn.shutdown();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

}

package es.idr.test;

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 javax.units.Unit;

import org.geotools.referencing.CRS;

import org.geotools.referencing.crs.DefaultGeographicCRS;

import org.geotools.referencing.crs.DefaultProjectedCRS;

import org.geotools.referencing.datum.DefaultGeodeticDatum;

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.FactoryException;

import org.opengis.referencing.NoSuchAuthorityCodeException;

import org.opengis.referencing.crs.CoordinateReferenceSystem;

public class TestWKTandProj4Epsg {

	public static void main(String[] args) {

		HSQLDataSource ds = new HSQLDataSource();

		Connection conn;

		try {

			conn = ds.getConnection();

			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()) {

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

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

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

    			try {

					Crs crs = new Crs(cod,1);

					wkt.add(crs.getWKT());

					Proj4 proj= new Proj4();

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

				} catch (CrsException e) {

					// TODO Auto-generated catch block

					e.printStackTrace();

				} catch (NumberFormatException e) {

					// TODO Auto-generated catch block

					//e.printStackTrace();

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

				} catch (ConversionException e) {

					// TODO Auto-generated catch block

					//e.printStackTrace();

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

				}catch (UnformattableObjectException e) {

					// TODO Auto-generated catch block

					//e.printStackTrace();

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

				}			

	        }

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

	        	System.out.println("C?digo: "+codigo.get(i)+"\tNombre: "+name.get(i));

	        	System.out.println("Cadena WKT: "+wkt.get(i));

	        	System.out.println("Cadena Proj4: "+name.get(i));

	        }	

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

	        	System.out.println(fallos.get(i));

	        }	

	        System.out.println("Numero CRSs: " + codigo.size());	

	        System.out.println("Numero fallos: " + fallos.size());

		} catch (SQLException e1) {

			// TODO Auto-generated catch block

			e1.printStackTrace();

		}	

	}

}