Application: gvSIG desktop

package org.gvsig.crs;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

public class EpsgConnection {

        Connection connect;

        public EpsgConnection() {        

                try {

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

                } catch (ClassNotFoundException e) {

                        e.printStackTrace();

                }

        }

        public void setConnectionEPSG() {

                try {                        

                        connect =  DriverManager.getConnection("jdbc:hsqldb:file:gvSIG/extensiones/org.gvsig.crs/db_epsg", "sa", "");

                } catch (SQLException e1) {

                        e1.printStackTrace();

                }

        }

        public void setConnectionIAU2000() {

                try {                        

                        connect =  DriverManager.getConnection("jdbc:hsqldb:file:gvSIG/extensiones/org.gvsig.crs/db_iau2000", "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

    }

}