Advertisement
Guest User

Untitled

a guest
Dec 30th, 2017
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. package app;
  2.  
  3.  
  4. import java.sql.*;
  5.  
  6.  
  7. public class appp {
  8.  
  9.  
  10. public static void main(String[] args) {
  11. String user="SYS";
  12. String pass="12345";
  13. Connection conn= null;
  14. try {
  15.  
  16.  
  17. Class.forName("oracle.jdbc.driver.OracleDriver");
  18.  
  19.  
  20.  
  21. System.out.println("Nawiazujemy polaczenie");
  22. conn = DriverManager.getConnection("jdbc:oracle:thin:SYS@//localhost:1521/xe", "SYS as SYSDBA", "12345" );
  23.  
  24.  
  25. Statement a = conn.createStatement();
  26. ResultSet res = a.executeQuery("select * from pracownik");
  27.  
  28. while(res.next()) {
  29. for(int i=0;i<5;i++) {
  30. System.out.print(res.getString(i+1)+"\t");
  31. }
  32. }
  33.  
  34. }
  35.  
  36.  
  37. catch (ClassNotFoundException e) {
  38. System.out.println("Nie mozna pobrac sterownika");
  39.  
  40. } catch (SQLException e) {
  41. System.out.println("Nie mozna polaczyc z baza danych" + e);
  42. }
  43. }
  44. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement