Fórum Web Service (Firebird) #477168

package br.com.restful.factory;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class ConnectionFactory {

	// Caminho do banco de dados.
	private static final String DRIVER = "org.firebirdsql.jdbc.FBDriver";
	private static final String URL = "jdbc:firebirdsql://localhost:3050/c:/database/employee.fdb";
	private static final String USUARIO = "SYSDBA";
	private static final String SENHA = "masterkey";

	public Connection criarConexao() {

		Connection conexao = null;

		try {

			Class.forName(DRIVER);
			conexao = DriverManager.getConnection(URL, USUARIO, SENHA);

		} catch (Exception e) {
			System.out.println("Erro ao criar conexão com o banco: " + URL);
			e.printStackTrace();
		}
		return conexao;
	}

	public void fecharConexao(Connection conexao, PreparedStatement pstmt,
			ResultSet rs) {

		try {

			if (conexao != null) {
				conexao.close();
			}
			if (pstmt != null) {
				pstmt.close();
			}
			if (rs != null) {
				rs.close();
			}

		} catch (Exception e) {
			System.out.println("Erro ao fechar conexão com o banco: " + URL);
		}
	}
}