Advertisement
Guest User

Untitled

a guest
Nov 1st, 2017
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. public class ConexionOracle {
  2. public static void main(String[] args) {
  3. try{
  4. // Carga del driver.
  5. Class.forName("oracle.jdbc.driver.OracleDriver");
  6.  
  7. // Creación de la conexión.
  8. Connection conn = DriverManager.getConnection("jdbc:oracle:thin:"
  9. + "@localhost:1521:xe","dbseries","dbseries");
  10.  
  11. // Creación del objeto Statement.
  12. Statement stmt = conn.createStatement();
  13.  
  14. // Ejecución de la consulta.
  15. ResultSet rs = stmt.executeQuery("SELECT * FROM USUARIO");
  16.  
  17. // Salida por pantalla de los datos.
  18. while(rs.next()){
  19. System.out.println(rs.getInt(1) + "\t" + rs.getString(2));
  20. }
  21.  
  22. // Cerrado de la conexión.
  23. conn.close();
  24.  
  25. }catch (Exception e){
  26. e.printStackTrace();
  27. }
  28. }
  29.  
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement