Advertisement
Guest User

Untitled

a guest
Apr 20th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. import java.sql.*;
  2. class dbaccess {
  3. public static void main (String args []) throws SQLException
  4. {
  5. try {
  6. DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
  7.  
  8. Connection conn = DriverManager.getConnection("jdbc:oracle:thin:g3_jerzy/haslo@oraas:1521:ora2016");
  9.  
  10. Statement stmt = conn.createStatement();
  11. ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");
  12. while (rset.next())
  13. System.out.println(rset.getString(1)); // kol 1
  14. rset.close();
  15. stmt.close();
  16. conn.close();
  17. } catch (SQLException e) {
  18. System.err.println("Blad Oracle: "+ e.getErrorCode() + e.getMessage());
  19. }
  20. }
  21. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement