Segue o código:
[code]package util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Conexao {
private String url = "jdbc:oracle:thin:@localhost:1521:xe";
private String usr = "Marcio";
private String pwd = "Gx12J@";
private Connection con = null;
public Conexao(){}
public Connection conectaBanco() throws SQLException, ClassNotFoundException{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(url,usr,pwd);
return con;
}
public Connection fechaConexaoBanco() throws SQLException, ClassNotFoundException{
if(con != null){
con.close();
}
return con;
}
}[/code]