Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package jdbc;
- import java.sql.*;
- public class ConexionOracle {
- //Atributos
- String user, pass, url;
- Connection conex;
- Statement stm;
- public ConexionOracle(String url, String user, String pass) {
- this.user=user;
- this.pass=pass;
- this.url=url;
- conex=null;
- stm=null;
- }
- public void abrirConexion(){
- try{
- Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
- conex=DriverManager.getConnection(url, user, pass);
- }catch(SQLException e){
- System.out.println("Error al abrir la conexion");
- e.printStackTrace();
- }catch(Exception e){
- System.out.println("Error al cargar el driver");
- e.printStackTrace();
- }
- }
- public void cerrarConexion(){
- try{
- if(conex!=null){
- conex.close();
- }
- }catch(SQLException e){
- System.out.println("Error al cerrar la conexion");
- e.printStackTrace();
- }
- }
- public String leerDatosBD(String query) throws SQLException{
- stm=conex.createStatement();
- String datos="";
- try{
- ResultSet rs=stm.executeQuery(query);
- while(rs.next()){
- datos+=rs.getString(2);
- }
- }catch(Exception e){
- }
- return datos;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement