Advertisement
Guest User

jdbc

a guest
May 5th, 2017
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. package jdbc;
  2. import java.sql.*;
  3.  
  4. public class ConexionOracle {
  5.  
  6. //Atributos
  7. String user, pass, url;
  8. Connection conex;
  9. Statement stm;
  10.  
  11. public ConexionOracle(String url, String user, String pass) {
  12. this.user=user;
  13. this.pass=pass;
  14. this.url=url;
  15. conex=null;
  16. stm=null;
  17. }
  18.  
  19. public void abrirConexion(){
  20. try{
  21. Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
  22. conex=DriverManager.getConnection(url, user, pass);
  23. }catch(SQLException e){
  24. System.out.println("Error al abrir la conexion");
  25. e.printStackTrace();
  26. }catch(Exception e){
  27. System.out.println("Error al cargar el driver");
  28. e.printStackTrace();
  29. }
  30. }
  31.  
  32. public void cerrarConexion(){
  33. try{
  34. if(conex!=null){
  35. conex.close();
  36. }
  37. }catch(SQLException e){
  38. System.out.println("Error al cerrar la conexion");
  39. e.printStackTrace();
  40. }
  41. }
  42.  
  43. public String leerDatosBD(String query) throws SQLException{
  44. stm=conex.createStatement();
  45. String datos="";
  46. try{
  47. ResultSet rs=stm.executeQuery(query);
  48.  
  49. while(rs.next()){
  50. datos+=rs.getString(2);
  51. }
  52. }catch(Exception e){
  53.  
  54. }
  55. return datos;
  56. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement