Diretórios, pastas, path's

/*
 * FabricaDAOHSQLDB.java
 *
 * Created on 26 de Novembro de 2006, 17:16
 *
 */

package pousada.persistencia;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import pousada.negocio.Hospede;

/**
 *
 * @author Frederico
 */
public class FabricaDAOHSQLDB extends FabricaDAO {
    
    public static Connection conexao;
    private static final String DRIVER = "org.hsqldb.jdbcDriver";
    private static final String URL = "jdbc:hsqldb:file:" +
            System.getProperty("user.dir").replace('\\','/').concat("/banco/pousada") +
            ";shutdown=true";
    private static final String USUARIO = "sa";
    private static final String SENHA = "";
    
    public static Connection obtemConexao() throws SQLException, ClassNotFoundException {        
        if(conexao == null) {
            Class.forName(DRIVER);
            conexao = DriverManager.getConnection(URL, USUARIO, SENHA);
        }
        return conexao;
    }
    
    public static void encerraConexao() throws SQLException {
        if(conexao != null) {
            Statement st = conexao.createStatement();
            st.execute("SHUTDOWN");
            conexao.close();
            conexao = null;
        }
    }    
}